I need to see the 20th column, but need to see the contents of the first 5 columns.
How can I temporarily freeze the first 5 columns?
Thanks.
I need to see the 20th column, but need to see the contents of the first 5 columns.
How can I temporarily freeze the first 5 columns?
Thanks.
Try this:
Click on cell F1 > View > Freeze Panes > Freeze Panes
i get 3 options only
unfreeze panes
freeze top row
freeze first column
this is using excel 2013
what am i doing wrong?
thanks
Put the cursor in the 1st cell that you want to "move". ie if you want to freeze row 1 and columns A and B, put the cursor in cell C2, then follow the steps given by 63
If you only have an UNfeeze option, that means you already have rows and/or columns frozen. Click UNfreeze then apply it again, how you want it.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Alternately, if you want to freeze columns but not rows.
For first 3 columns...
Select entire D column. Freeze panes.
"Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something."
― Robert A. Heinlein
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks