Excel – Stationary Column or Row Headers

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!

Advertisements

Leave a comment

Filed under MS Excel

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s