Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
freezing panes
I know that you can freeze panes vertically or horizontally, but can
you do both at the same time? What I basically want is a sheet with 2 rows as as always visible header on the top, but also froze on the right so no matter how far someone scrolls to the right, the original screen still mostly shows. Thanks, Peter |
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
freezing panes
Peter, click in row 3, column ?? and freeze panes, you will have the two
rows at the top and how depending on which column you pick that many columns on the left will stay visible -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "peter" wrote in message oups.com... I know that you can freeze panes vertically or horizontally, but can you do both at the same time? What I basically want is a sheet with 2 rows as as always visible header on the top, but also froze on the right so no matter how far someone scrolls to the right, the original screen still mostly shows. Thanks, Peter |
#3
Posted to microsoft.public.excel.setup
|
|||
|
|||
freezing panes
Oh, ok, I was doing it highlighting the whole row, then hitting ctrl
and highlighting the column. How I got it! Thanks, Peter |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Freezing panes | Excel Discussion (Misc queries) | |||
Freezing panes | Excel Discussion (Misc queries) | |||
Freezing two columns in addition to Freeze Panes | Excel Discussion (Misc queries) | |||
Freezing Panes | Excel Discussion (Misc queries) | |||
Freezing panes | Excel Worksheet Functions |