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:
You can't do only specific column.
But you can target specific column and that corresponding row using
Example: If you are on
For more clarity, refer this screenshot:-
|show 2 more comments|
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
if your focus is in the are that is Static (Fixed/Locked) and try to scroll you will scroll only that pane.
I am using Excel 2010