ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   freezing panes (https://www.excelbanter.com/setting-up-configuration-excel/72206-freezing-panes.html)

peter

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


Paul B

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




peter

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



All times are GMT +1. The time now is 09:07 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com