Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Fixed columns on left 2

Status
Not open for further replies.

chassid

MIS
Aug 27, 2000
58
US
All,

I would like to know how to have two columns fixed on the left of the screen when using excel. Whenever I would go to the right the columns would stay fixed.

Any help will be greatly appreciated.

Daniel Do you know the Chabad Lubavitch Sheliach in your area?
He is waiting for you!
 
Daniel: Rule of thumb is that everything above your cursor and everything to the left of your cursor will "freeze" when you hit Window-Freeze panes.

So, if you want ONLY column A to be frozen, put your cursor in B1. (There's nothing above B1, so no rows will be frozen, only columns.)

Suppose you want to freeze both Rows 1 and 2 and also Column A and B? Place your cursor in C3.

Anyway, once your cursor is placed in appropriate location, hit Window-Freeze panes.

Hope this helps! dreamboat@nni.com
Brainbench MVP for Microsoft Word
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top