Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
liu liu is offline
external usenet poster
 
Posts: 17
Default how to set columns that will stay on screen?

I notice a few Excel files created by others have this feature that
the first 2 columns at the left will not move when scroll it
horizontally. The scrolling only starts column C. It's great for
column or row with labels. How is it set? How to disable it?

Thanks,
  #2   Report Post  
Posted to microsoft.public.excel.newusers
liu liu is offline
external usenet poster
 
Posts: 17
Default how to set columns that will stay on screen?

On Apr 8, 5:04*pm, liu wrote:
I notice a few Excel files created by others have this feature that
the first 2 columns at the left will not move when scroll it
horizontally. The scrolling only starts column C. It's great for
column or row with labels. How is it set? How to disable it?

Thanks,


Found it on another thread. WindowFreeze Panes.
  #3   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 5
Default how to set columns that will stay on screen?

HI LIU,

I THINK THE COLUMN HS BEEN FREEZED (WINDOWS/FREEZE PANS)



"liu" wrote:

I notice a few Excel files created by others have this feature that
the first 2 columns at the left will not move when scroll it
horizontally. The scrolling only starts column C. It's great for
column or row with labels. How is it set? How to disable it?

Thanks,

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
I need to set colums and rows to stay on the screen as I scroll ksholars Excel Worksheet Functions 0 August 19th 06 08:50 PM
I need to set colums and rows to stay on the screen as I scroll Toppers Excel Worksheet Functions 0 August 19th 06 08:48 PM
formula to stay fixed on two columns as you add more columns usingexcel Excel Discussion (Misc queries) 1 August 3rd 06 01:25 AM
Excel sheet won't stay on my screen SueM Excel Discussion (Misc queries) 3 April 12th 06 07:19 PM
rows and columns won't stay resized vulcan88 Excel Worksheet Functions 0 March 15th 05 11:11 PM


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