Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have a large sheet with alist of names in the left hand column. I would
like that column (those names) to stay on the screen as I scroll to the left and read information from the page. I have seen this done before but cannot figure out how to "lock" the first column so it stays on the page. |
#2
![]() |
|||
|
|||
![]()
Select cell B1. Choose Window/Freeze Panes.
In article , "Kuch" wrote: I have a large sheet with alist of names in the left hand column. I would like that column (those names) to stay on the screen as I scroll to the left and read information from the page. I have seen this done before but cannot figure out how to "lock" the first column so it stays on the page. |
#3
![]() |
|||
|
|||
![]()
Say your data is in column A. Click on cell B1. Then select Window Freeze
Panes -- Gary's Student "Kuch" wrote: I have a large sheet with alist of names in the left hand column. I would like that column (those names) to stay on the screen as I scroll to the left and read information from the page. I have seen this done before but cannot figure out how to "lock" the first column so it stays on the page. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
How to group similar column titles together???? | Excel Discussion (Misc queries) | |||
Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
Auto Skipping and protected cells | Excel Discussion (Misc queries) | |||
Creating a stationary column | Excel Worksheet Functions |