![]() |
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 |
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 |
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 |
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