Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a spreadsheet in which I want to keep all of columns A:H and all of row 1 always visible while I scroll through data in the other section. I've tried using Freeze Panes and some other settings, but just can't seem to get it quite right.

Is there something I've missed, or is this something that can't be done?

share|improve this question
up vote 3 down vote accepted

To lock both rows and columns, click the cell below and to the right of the rows and columns that you want to keep visible when you scroll (source).

Select I2. Now go to the View ribbon and click Freeze Panes. Choose the first option which will freeze the columns and rows to the left and above your selection.

enter image description here

share|improve this answer
That froze A:I and rows 1:12. – Iszi Oct 24 '12 at 19:05
Is this a pivot table or is there already some filtering of some sort? I noticed that on mine but thought it was because I had a bunch of filters on the data. – CharlieRB Oct 24 '12 at 19:07
No tables, no filters. There's some named ranges, but none for which this makes sense. – Iszi Oct 24 '12 at 19:08
Weird. I just moved my data to a fresh sheet and have the same problem. I have done this before, but not with so many columns. Wonder if it's a glitch. Will keep looking. – CharlieRB Oct 24 '12 at 19:11
Ok. I think I found the answer to the question I asked, but then realized the question I asked is the wrong question. Select I2, then use Freeze Panes. This will freeze what I've described, but not quite in the way I really want it. – Iszi Oct 24 '12 at 19:15

To freeze any row, and any column together:

  1. Unfreeze panes - use the 'View' tab; 'Freeze Panes' option to unfreeze all panes
  2. Select the entire row below the row to be frozen
  3. Select the first cell to the right of the column to be frozen
  4. Freeze panes - use the 'View' tab; 'Freeze Panes'
share|improve this answer

If you want to keep all of columns A:H and all of row 1 always visible: Select cell I2 and then click on 'Freeze Panes' option

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .