Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
when what I really want it to do is freeze the first column. How can I
change it? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi,
I think you should: 1. Unfreeze the panes 2. Select B1 3. Freeze the panes If you want just column a frozen Ken Johnson |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi Joe,
Select B1 before freezing the panes. Ken Johnson |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi!
Unfeeze panes, select cell B1, then try it again! The panes will be frozen at the column to the left and the row above the selected cell. If you select cell B2, both column A and row 1 will be frozen. Biff wrote in message oups.com... when what I really want it to do is freeze the first column. How can I change it? |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Thanks all. Biff the B2 tip was excellent, thanks.
|
#6
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
You're welcome. Thanks for the feedback!
Biff wrote in message oups.com... Thanks all. Biff the B2 tip was excellent, thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Problem with Page Numbering | Excel Discussion (Misc queries) | |||
Page Numbers | Excel Discussion (Misc queries) | |||
How do i use multiple splits or frozen panes? | Excel Discussion (Misc queries) | |||
Excel should have a second 'Freeze Panes' option that works in re. | Excel Discussion (Misc queries) | |||
Shared File & Freeze panes issue | Excel Discussion (Misc queries) |