ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Freezing Panes In Excel 2007 (https://www.excelbanter.com/excel-discussion-misc-queries/159571-freezing-panes-excel-2007-a.html)

Railrd

Freezing Panes In Excel 2007
 
Is there a way to freeze both the top row and left column of a worksheet?
When I try it undos one to do the other.
Thanks

Ron de Bruin

Freezing Panes In Excel 2007
 
Hi Railrd

Select A2 and use ViewFreeze Panes

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Railrd" wrote in message ...
Is there a way to freeze both the top row and left column of a worksheet?
When I try it undos one to do the other.
Thanks


Bob Phillips

Freezing Panes In Excel 2007
 
Select the cell below and to the right of where you want the freeze to be,
and then do the Freeze Panes.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Railrd" wrote in message
...
Is there a way to freeze both the top row and left column of a worksheet?
When I try it undos one to do the other.
Thanks




Railrd

Freezing Panes In Excel 2007
 
Thanks a lot. Feel like a fool now

"Ron de Bruin" wrote:

Hi Railrd

Select A2 and use ViewFreeze Panes

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Railrd" wrote in message ...
Is there a way to freeze both the top row and left column of a worksheet?
When I try it undos one to do the other.
Thanks




All times are GMT +1. The time now is 12:59 PM.

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