Excel Always On Top Row. In our example the headings in row 1 remain frozen as you scroll down to view the data in rows 5 6 7 and 8. Effectively i have a table in excel 2007 and i want to always reference the top row.
The trouble is that rows are added to this table from the top so the top row keeps moving down to. When you want to keep the top row visible in excel 2010 it is because you are having difficulty determining which column a piece of data belongs to as you scroll down to the higher row numbers. How to make top row always stay visible in excel.
Click the view tab at the top of the window.
The top row is frozen when you can scroll down your spreadsheet but the first row or first few rows will remain visible even when they should naturally no longer be on the screen. This quick tip will save you time and tons of frustration in this video learn how to freeze row and column panes so those areas excel excel spreadsheets tips. Excel provides you the feature to freeze the top row or the left column of your sheet or multiple rows and columns simultaneously. How to freeze rows or columns with panes in excel.