Home Excel Content

How to Freeze a Row in Excel

Tips 2022-05-19 15:05:26 Excel 865

Freezing the First Row

Simple spreadsheet layouts often use the first row as data headers. For example, a contact resource management spreadsheet might include cells for first name, last name, address, state, phone number and so on. As you add data, it will eventually scroll down the bottom of your monitor, pushing data at the top off-screen. You can simply freeze your data headers in row 1. Click the "View" tab, then click "Freeze Panes" and select "Freeze Top Row." Your data headers now remain visible as you scroll down.

How to Freeze a Row in Excel1

Using Freeze Panes

It's common to include information and formatting for printing your worksheet above your data header row, making a first-row freeze ineffective. Locking a row below the first row follows similar steps. First, select the cell in column A below the last row to freeze. Click the "View" tab, click "Freeze Panes," then click "Freeze Panes" from the drop-down menu. All rows above the selected cell will now freeze.

How to Freeze a Row in Excel2