Excel spreadsheets can grow to be very large and if you have column headings, it can be hard to remember what each column is for as more data is entered. As you move farther down the spreadsheet, you will no longer be able to see your column headings. If you don’t mind scrolling up every so often to refresh your memory, you can leave things as they are. Other wise, you can perform the simple steps below so your column headings are constantly visible.
- Select the entire row directly below your column headings.
- From the Window menu, click Freeze Panes.
Your column headings are now frozen and constantly visible. You can undo this by once again completing the steps above, only this time select Unfreeze panes.