Let’s say you have a spreadsheet that goes on for days (rows and rows). You probably want to see the headers, since those are your guide for what information goes in those columns and/or your spreadsheet is wide and you want to see your row labels. Here’s how:
- Decide what row will be your first “ok to scroll” row and which column will be the first scrollable column.
- Select at least 2 cells from the the top scrollable row – like this:
- Go to the “View” tab on the menu bar (2007 and 2010) and click on “Freeze Panes.”
- Click “Freeze Panes”
To freeze a column or more, at least 2 cells of the first scrollable column next to the last column you want to keep stationary and repeat the Freeze Panes steps.
To freeze both a header row or rows, select the first 4 cells (two across and two down) immediately following your stationary header and stationary column(s) – like figure below – and repeat the Freeze Panes steps.
Thanks for stopping by! Please comment below; and if you haven’t subscribed yet, please do!