how to make left side stay still and right side can move left to r

A

AAS

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
 
K

Kevin B

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can you freeze one side of the Excel window so the other side stay 1
fix left column(s) and/or upper row 6
how to move sheet tabs to the side of the worksheet in excel 2003 1
Make left-to-right default direction 1
Sum Left Side & Right Side Numbers 4
Move tab bar 3
How do I print column on left of page then break & go to right 2
Default left-to-right columns for imported files 2

Top