LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 376
Default Freeze Column

To the OP

You can use Freeze Panes wherever you like on a sheet.
Place the cursor in the cell below the first row you wish to freeze, and
to the right of the first column you want to freeze, before selecting
Freeze panes.
--
Regards
Roger Govier

Ric in Tx wrote:
In Microsoft 2007,

I usually do this. In the 'View' tab, select "Split." A bar will appear in
the middle which can be moved left or right.

This will create a duplicate of your spreadsheet. BUT WAIT! It's not a
regular copy. If you make an edit on one side, the edit automatically edits
the other side. So you don't have to worry about more than one document.

Now you can drag the split where you want. This will allow the right side
to be scrollable while the left side of the split stays visible.

Say you want to hide a column, select it, and right click hide.

Hope that helps!


"ManhattanRebel" wrote:

Other than the first column, is there a way to freeze other columns in my
excel spread sheet?

 
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
Freeze more than one column Kim Excel Discussion (Misc queries) 8 April 29th 23 11:42 AM
Can I freeze BOTH a column and a row in the same spreadsheet? Todd Excel Discussion (Misc queries) 1 February 19th 08 04:28 PM
Freeze column AG [email protected] Excel Discussion (Misc queries) 4 January 2nd 07 10:06 PM
freeze row and column 00KobeBrian Excel Discussion (Misc queries) 3 May 8th 06 06:58 AM
Freeze column and row vapor77 New Users to Excel 3 February 3rd 06 05:44 PM


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