I’ve looked for this feature in the Help function but I don’t even know the term to look for. I have seen spreadsheets in which the top row always remains visible so that it acts as a header row when I scroll for several pages. It’s an easy and intuitive function in Word tables but I just can’t find how it’s done in Excel spreadsheets. I’m not concerned about the printed version, only on a computer screen.
A list of steps would be greatly appreciated. Thank you very much
Select the first cell in the row you want to be the first to still scroll and then find Freeze Panes under the View menu.
If you select the second cell in that row instead it will lock the rows above it and the first column so you can fix it wherever you want.
I believe you are looking for “Freeze Panes” under the View tab.
ETA: Beat to it. As usual.
You are gods. Thank you very much for that.
If you are using Excel 2007 or 2010, you can your data into a Table and it’s automatic.