How do I lock N left hand columns

  • Thread starter Thread starter Don J
  • Start date Start date
D

Don J

How do I lock N left hand columns in excel so that when I want to see some
right hand columns and slide the columns on the right to the left the locked
columns do not move and remain visible?

Don J

------------------------------------------------------------------------
 
With A,B,C visible select D1 and hit Window / Freeze panes. This will freeze
A,B,C in view

If you hit D2 and do it you will also lock the headers in view (ie Row 1)

Whatever cell you select it will freeze to the left and above that cell.
 
How do I hit Window / Freeze panes?

Don J

------------------------------------------------------------------------
Ken Wright said:
With A,B,C visible select D1 and hit Window / Freeze panes. This will
freeze A,B,C in view

If you hit D2 and do it you will also lock the headers in view (ie Row 1)

Whatever cell you select it will freeze to the left and above that cell.
Click to expand...
 
Well, I can at least say that you are able to find your original message and
read the suggestion and post a follow up question.
That's more then a lot of other new folks to these groups can do.

The top few rows of your XL screen contain the name of the workbook, the
menu bar, and maybe a couple of tool bars.

The menu bar is usually the second one down, and contains, would you
believe, "menus".
Usually starts with <File> <Edit> <View> etc...
When you click on a "Menu", you'll get drop-down "sub-menu".
So, if someone would say, click on <Window> <FreezePanes>,
The first word would depict the Menu, and the next word would mean the
sub-menu selection.
There could be 4 or 5 names in a suggestion, meaning, how "deep" you would
go into a menu, and it's corresponding sub-menus.

Following Ken's suggestion, you must first select (click in (on)) a cell,
and *then* click on the menu selection of <Window>.
Then, from the sub-menu, click on <FreezePanes>.

Depending on which cell you selected (clicked in) *before* you selected
<Window> <FreezePanes>, you will force columns and/or rows to remain in
view, as the rest of the sheet is scrolled.

You can click on this link to bring up an old post, which describes
"FreezePanes" a little more fully.

http://tinyurl.com/2qdzt

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
Don J said:
How do I hit Window / Freeze panes?

Don J

------------------------------------------------------------------------
Ken Wright said:
With A,B,C visible select D1 and hit Window / Freeze panes. This will
freeze A,B,C in view

If you hit D2 and do it you will also lock the headers in view (ie Row 1)

Whatever cell you select it will freeze to the left and above that cell.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

--------------------------------------------------------------------------
Click to expand...
--
It's easier to beg forgiveness than ask permission :-)
--------------------------------------------------------------------------
Click to expand...
--
Click to expand...
 
Back
Top