I have a spreadsheet in which I want to keep all of columns A:H and all of row 1 always visible while I scroll through data in the other section. I've tried using Freeze Panes and some other settings, but just can't seem to get it quite right.
Is there something I've missed, or is this something that can't be done?
Best Answer
To lock both rows and columns, click the cell below and to the right of the rows and columns that you want to keep visible when you scroll (source).
Select
I2
. Now go to theView
ribbon and clickFreeze Panes
. Choose the first option which will freeze the columns and rows to the left and above your selection.This should work for both Microsoft Excel 2007 and 2010