Freezing Column Headings in Long Excel Spreadsheets

Have you ever found yourself frustrated when trying to read a really long spreadsheet full of data because the column headings do not appear on all pages?

Houston IT consultant Cheryl Smith shares a few tips on how to freeze cells so you can read the column headins of long spreadsheets.

Simple way to read column headings in long spreadsheets:

1. Click the row below the heading aka titles of the spreadsheet

1. Select the Window tab on the toolbar

1. Click Freeze Panes

Note: A line will appear directly under the information that will be frozen.

This allows you to continue scrolling through the entire spreadsheet and still be able to read the titles of the columns.

We hope you have found this information helpful. If you would like to learn more about this subject, please feel free to contact us:

·        Questions about this article?

·        Suggest a topic

·        Learn more about our Houston IT Consulting