LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Need to lock one column and allow others to scroll

Hello everyone,

I have a spreadsheet with a long column of data in Column A for which I've
created a summary table on the same spreadsheet page. I want to be able to
scroll my data column (A) and leave the summary table in place, which is to
say scroll Column A vertically and none of the other columns. Is there a way
to do that?

Thanks!
 
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
how do I undo the scroll lock, thscroll lock button does not work scroll lock Excel Discussion (Misc queries) 3 July 19th 08 10:17 PM
Scroll Lock ? Rob L Excel Discussion (Misc queries) 1 August 12th 07 08:54 AM
How do I "lock" a column so I can scroll across to another colum andysarms New Users to Excel 1 February 10th 07 10:21 PM
How do I lock a column so it doesn't move when I scroll across? Lanette Excel Discussion (Misc queries) 1 August 9th 06 07:30 PM
scroll lock PCOR Excel Discussion (Misc queries) 6 December 5th 04 08:08 PM


All times are GMT +1. The time now is 02:59 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"