12

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?

| |
20

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.

Freeze Panes option highlighted

This should work for both Microsoft Excel 2007 and 2010

| |
  • 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
1

Even when the very quick way from the accepted answer somehow does not work for you, then still no trickery is needed at all:

  • Drag the small handles to the left and top of the scrollbars, to split the view:

    handles

  • Or, in the View toolbar, click Split:

    split

    ...and drag the standard split to adjust it:

    adjusted

  • In the View toolbar, click Freeze panes:

    frozen

Screenshots are Office 365, but same applies to previous versions.

But: the accepted answer is much easier!

| |
0

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'
| |
  • I don't think step 2 is needed (and without that, this is the same as the accepted answer). – Arjan Feb 10 '18 at 9:44
0

to freeze multi-columns, you need first to freeze the leading columns in your spreadsheet. then just cut-paste other columns to be the leading column of your spreadsheet. then you will get multi-columns frozen. this work with me in Excel 2010

| |
  • 1
    But why does the accepted answer not work for you? So much easier: click, freeze. – Arjan Feb 10 '18 at 9:44
-3

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

| |
  • This is exactly the same as the accepted answer. – Arjan Feb 10 '18 at 9:46

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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