ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to keep 1st column visable when scrolling (https://www.excelbanter.com/excel-discussion-misc-queries/140534-how-keep-1st-column-visable-when-scrolling.html)

TomC

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

Ron Coderre

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