How do I freeze panes horizontally and vertically at same time

BW

unread,

Aug 31, 2006, 2:54:02 PM8/31/06

to

I would like to be able to freeze panes, such as headers, horizontally, as
well as freezing panes in a column, such as listing of names.

Sloth

unread,

Aug 31, 2006, 3:03:02 PM8/31/06

to

when you freeze panes the rows above, and the columns left of the selected
cell are frozen. So to freeze columns A-B and rows 1-3 select C4 and then
select window->freeze panes.

Pete_UK

unread,

Aug 31, 2006, 3:05:27 PM8/31/06

to

If you place the cursor in cell B2 then Window | Freeze Panes you will
find the top row and column A will be "frozen" as you scroll around the
sheet. Try it with C2 selected - this will fix A and B in place as well
as the top row, i.e. all rows above and all columns to the left of the
cell you select when doing Window | Freeze Panes will be frozen on
screen.

Hope this helps.

Pete

Ibrahim Shb@discussions.microsoft.com Leo Ibrahim Shb

unread,

Aug 27, 2008, 6:55:01 AM8/27/08

to

"Pete_UK" wrote:

This is not work on Excel 2007.
Please help me.

Mike Kaufman

unread,

Oct 1, 2008, 4:33:03 PM10/1/08

to

"Leo Ibrahim Shb" wrote:

1) Click on the Freeze Panes button and select "Unfreeze Panes".

2) Click on the cell below and to the right of the row and column you want
to freeze, cell B2 for example.

3) Click on the Freeze Panes button and select "Freeze Panes".

These options are toggle switches, and you cannot select Freeze Row and
Freeze Column independently. Selecting one turns off the other. And if you
have freezing set for any cell, you have to turn it off before you can freeze
rows and columns at the same time.

Lewis@discussions.microsoft.com Dana Lewis

unread,

Oct 27, 2008, 3:31:19 PM10/27/08

to

I don't have a Freeze Panes option under the button Freeze Panes. All I see
is Unfreeze Panes, Freeze Top Row, and Freeze First Column.

Dana

Mike Kaufman

unread,

Oct 27, 2008, 3:38:28 PM10/27/08

to

Read my response again. You overlooked something rather important.

Narusha

unread,

Dec 17, 2008, 4:39:01 AM12/17/08

to

Mike is saying:

1) Click on the Freeze Panes button and select "Unfreeze Panes".

First you have to unfreeze your panes (they have been frozen when you tried
to freeze them), and then you can continue with Mike's step 2 & 3

Thanks Mike, you helped me a lot!

Groeten, Narusha

Jon Peltier

unread,

Mar 27, 2009, 8:30:50 AM3/27/09

to

On the View tab, find the Freeze Panes dropdown (in the Windows group). The
first option, Freeze Panes, freezes the rows above the active cell and the
columns to the left of the active cell.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______

"Darlene" <Dar...@discussions.microsoft.com> wrote in message
news:271F4DC2-92D2-42D9...@microsoft.com...
> the options in 2007 are difference from 2003...2003 will allow you to
> chose a
> column of cell...
> 2007 only gives you 3 options:
> 1-freeze top column
> 2-freeze first column
> 3-unfreeze
>
> does anyone know 2007 freeze frame, additional options for freezing the
> second column from the top?
> Darlene

JJ in LA

unread,

Aug 12, 2009, 2:58:02 PM8/12/09

to

Only the 3 options listed above have any effect. How do you make the Rows
and Columns option work together? Clicking on Freeze Panes only opens up the
three choices and nothing else

Mike Middleton

unread,

Aug 12, 2009, 4:05:54 PM8/12/09

to

JJ in LA -

In Excel 2007, on the View ribbon, if the worksheet does not have any frozen
panes, the three Freeze Panes options are Freeze Panes (both rows and
columns), Freeze Top Row, and Freeze First Column.

If the worksheet does have a frozen pane or panes, the three Freeze Panes
options are Unfreeze Panes, Freeze Top Row, and Freeze First Column.

- Mike

http://www.MikeMiddleton.com

"JJ in LA" <JJi...@discussions.microsoft.com> wrote in message
news:052A5B24-2FD3-4F5D...@microsoft.com...

Theresa

unread,

Sep 8, 2009, 9:52:02 PM9/8/09

to

Thank you for the question & answer. I'm not very good at excel. This is
helpful indeed.

Dan DeHaven

unread,

Sep 8, 2009, 11:12:26 PM9/8/09

to

As Sloth wrote you need to select the cell just to the left of the
column that you want to freeze and below the row that you want to
freeze. Say you wanted column A and row 1 to always be visible. Select
cell B2 and then (In Excel 2007) go-to the "View" tab and from the
"Window" group click on the "Freeze Panes" icon. Usually you'd want to
select the top choice "Freeze Panes" to get the results mentioned above.
but you can also just freeze the top

--
Dan DeHaven
------------------------------------------------------------------------
Dan DeHaven's Profile: http://www.thecodecage.com/forumz/member.php?userid=748
View this thread: http://www.thecodecage.com/forumz/showthread.php?t=132751

rrusson

unread,

Oct 16, 2009, 11:38:30 AM10/16/09

to

"Sloth" wrote:

> when you freeze panes the rows above, and the columns left of the selected
> cell are frozen. So to freeze columns A-B and rows 1-3 select C4 and then
> select window->freeze panes.
>

Thanks. I struggled for a half-hour trying to freeze multiple columns and
rows --and I'm a software developer! MS really screwed up on this feature,
IMHO. You should be able to ctrl-click on multiple rows/columns and then
freeze. That would be much more intuitive. A lot of things seemed easier
before "The Ribbon."

Bob I

unread,

Oct 16, 2009, 11:45:55 AM10/16/09

to

try this, press F1, enter the word FREEZE, press enter, click
appropriate link.

Gord Dibben

unread,

Oct 16, 2009, 1:51:17 PM10/16/09

to

It was no different or more intuitive before "The Ribbon"

Gord Dibben MS Excel MVP