Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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
add comment

1 Answer

up vote 1 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
show 2 more comments

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.