Excel Printing Options

Learn how to utilize the Excel Printing Options to customize your printing.

Excel gives you a vast amount of options for printing spreadsheets, worksheets and specific print areas.  For example, you can set repeating rows for each page printed or even set a specific area within a worksheet to print.  NOTE:  Prior to printing, it is a good idea to preview the worksheet to make sure it’s going to look the way you want it to.  Below are the step by step instructions for Excel Printing. Continue reading “Excel Printing Options”

Freezing Panes in Excel

Learn how to freeze panes in Excel – Columns, Rows, and both columns and rows.

Freezing Panes

Working with large spreadsheets can become unmanageable very quickly.  Trying to enter data in rows or columns is impossible when the headings disappear off the screen as you can easily enter data into the wrong cells.  Event trying to review the data can become very cumbersome.  The ability to freeze rows and/or columns allows you to efficiently enter data into large spreadsheets without having to continually scroll to the headings to ensure you are in the right cells.  It also allows you to hone into specific data quickly.  Below are the step-by-step instructions for freezing rows, columns, and both rows and columns. Continue reading “Freezing Panes in Excel”