![]() |
Stationary Column
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. |
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. |
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. |
All times are GMT +1. The time now is 05:11 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com