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.

  1. Select the entire row directly below your column headings.
  2. On the View tab, within the Window group, click the arrow beside Freeze Panes.
  3. Click Freeze Top Row.

Your column headings are now frozen and constantly visible.