Dashboard > Non-Metrix Tech Tips > Home > Make column headers float in Excel
Non-Metrix Tech Tips Log In   View a printable version of the current page.
Make column headers float in Excel
Added by Anthony Hernandez, last edited by Anthony Hernandez on Nov 20, 2008  (view change)

There is a way to make the column headers "float" in Excel 2003 when you scroll through a spreadsheet. To make column headers float:

  1. Select the row underneath the header column by clicking the row number to highlight it.
  2. Click Window and select Freeze Panes.

Figure: Making column headers "float"

Now when you scroll through the spreadsheet, the column headers will scroll too.

Site powered by a free Open Source Project / Non-profit License (more) of Confluence - the Enterprise wiki.
Learn more or evaluate Confluence for your organisation.
Powered by Atlassian Confluence, the Enterprise Wiki. (Version: 2.1.1 Build:#406 Dec 23, 2005) - Bug/feature request - Contact Administrators