Is there a way to freeze a column(s) or row(s) in place so that when I scroll up or down my worksheet, the column(s) or row(s) remain visible?
Office 2010, do the following:
- Make your selection that you want to remain in place
- Go to ribbon
view - freeze panes
- Choose to freeze the
- The chosen selection will be frozen in place as you move up or down the sheet
You can't do only specific column.
But you can target specific column and that corresponding row using
View Menu --> Freeze Pane
Example: If you are on
Cell F5 (that is column F & row 5) and select Freeze Pane from View Menu then
Freezed Column will be, till Column E
Freezed Row will be, till Row 4
For more clarity, refer this screenshot:-
I found it Very Difficult to figure out how to do this for the Top row and for a couple of Columns. I did figure it out however,
First Split the panes
and then move the large black Lines to the rows and columns that you want Static (or Fixed)
you can click
Freeze panes > Freeze Panes and then click
Split or you can just click
Split. if you do anything else in the
Freeze Panes and then Try to Split it will only Give you One Thick Black Line.
if your focus is in the area that is Static (Fixed/Locked) and try to scroll you will scroll only that pane.
I am using Excel 2010