![]() |
How to keep 1st column visable when scrolling
I am trying to figure out how to keep the 1st column visable when scrolling
across the spreadsheet. -- MCP |
How to keep 1st column visable when scrolling
Try this:
Select the 1st cell under and to the right of the rows/columns you want to always display. From the Excel main menu: <window<freeze panes Note: to unfreeze the panes <window<unfreeze panes Example: Select cell C3 <window<freeze panes Now columns A and B, and rows 1 and 2 will always be visible as you scroll. Does that help? *********** Regards, Ron XL2002, WinXP "TomC" wrote: I am trying to figure out how to keep the 1st column visable when scrolling across the spreadsheet. -- MCP |
All times are GMT +1. The time now is 09:40 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com