Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vertical scrolling...jumps rather than smooth scrolling | Excel Discussion (Misc queries) | |||
Live Scrolling/Real-Time /Smooth Scrolling doesn't work for me in Excel, even 2007 beta | Excel Discussion (Misc queries) | |||
Live Scrolling/Real-Time /Smooth Scrolling doesn't work for me in Excel 2003 | Excel Discussion (Misc queries) | |||
Visable Cells | Excel Discussion (Misc queries) | |||
Can you keep column (field) names visible while scrolling downwar. | Excel Worksheet Functions |