Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
AAS AAS is offline
external usenet poster
 
Posts: 24
Default how to make left side stay still and right side can move left to r

trying to get the excel sheet to allow columns A and B to stay in one place
yet allow C thru infinity to move right and left with the scroll bar
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,316
Default how to make left side stay still and right side can move left to r

Move the cell pointer to C1 if you only want to lock columns, or C2 if you
want to lock Columns A and B and row 1.

Click WINDOW on the menu and select FREEZE PANES.


To undo this just click WINDOW in the menu and select UNFREEZE PANES. You
don't have to be anywhere special to unfreeze the pane.
--
Kevin Backmann


"AAS" wrote:

trying to get the excel sheet to allow columns A and B to stay in one place
yet allow C thru infinity to move right and left with the scroll bar

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
rows are on the left side of the sheet, I need to move them to th. Rows on wrong side of worksheet Excel Discussion (Misc queries) 2 July 26th 07 10:48 PM
Move the negaive symbol from the right to the left side of a numbe Oldersox Excel Worksheet Functions 2 March 19th 07 03:46 AM
I need me first row to stay on left side as I move across thepage Mat Master Excel Discussion (Misc queries) 2 April 20th 06 01:19 PM
How do I Move column A, B, etc. to left side. TeesPlus New Users to Excel 1 February 24th 06 07:32 PM
In Excel can I move the tabs to the left side of the workbook? kit Excel Worksheet Functions 1 December 6th 04 08:15 PM


All times are GMT +1. The time now is 07:06 PM.

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"