ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Stationary Column (https://www.excelbanter.com/excel-discussion-misc-queries/27228-stationary-column.html)

Kuch

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.

JE McGimpsey

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.


Gary's Student

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