#1   Report Post  
Kuch
 
Posts: n/a
Default 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.
  #2   Report Post  
JE McGimpsey
 
Posts: n/a
Default

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   Report Post  
Gary's Student
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Count Position of Filtered TEXT cells in a column Sam via OfficeKB.com Excel Worksheet Functions 8 May 18th 05 04:23 AM
How to group similar column titles together???? vrk1 Excel Discussion (Misc queries) 2 April 30th 05 12:17 AM
Return Count for LAST NonBlank Cell in each Row Sam via OfficeKB.com Excel Worksheet Functions 12 April 17th 05 10:36 PM
Auto Skipping and protected cells Dave Peterson Excel Discussion (Misc queries) 6 January 27th 05 11:35 PM
Creating a stationary column Still Learning Excel Worksheet Functions 2 December 7th 04 06:25 PM


All times are GMT +1. The time now is 08:23 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"