How to Make the Top Line Stay Visible in Excel

By C. Taylor

The top line in your Microsoft Excel spreadsheet typically contains the column headers, which tells you what data belongs in which column. As you add more rows further down the sheet, the column headers scroll off the page. This makes it easy to confuse the columns and begin adding data in the wrong cells. To make referencing easier, Excel allows you to freeze the top row so it is always visible.

Step 1

Open your spreadsheet in Microsoft Excel.

Step 2

Click the "View" tab in the ribbon.

Step 3

Click "Freeze Panes" in the "Windows" group and click "Freeze Top Row" to make the top line stay visible.