Excel Row Always on Top? Keep It Visible While Scrolling

Yes—if you mean keeping a heading row visible while you scroll, choose View > Freeze Panes > Freeze Top Row in Excel for Microsoft 365 on Windows. If you mean moving a row so it is physically first in the worksheet, that is a different operation; freezing changes what stays on screen, not the order of the data.

What “always on top” means in Excel

Excel does not have a general setting that pins any chosen row above every other row. The feature people usually want is called Freeze Panes. It keeps selected rows or columns visible in the worksheet window while the rest of the sheet scrolls. The frozen area remains in place as you move down or across the sheet, making it easier to identify what each value means.

For example, a sales sheet might have headings in row 1: Date, Region, Product, and Revenue. After you freeze the top row, those labels remain visible as you scroll to row 200. The worksheet data has not moved, and the frozen row is not a special kind of cell; Excel is simply dividing the window into a scrolling area and a stationary area.

That distinction matters. Freezing is useful when you need a heading visible during on-screen work. It does not make a row stay at the top of a printed page, change its position in a sort, or guarantee that it appears in front of other application windows.

Keep the first row visible while scrolling

In the Windows desktop version of Excel for Microsoft 365, use the built-in command for the first row:

Open the worksheet you want to work with.
Select the View tab on the ribbon.
Choose Freeze Panes in the Window group.
Select Freeze Top Row.

Scroll down to check the result. Row 1 should remain visible while later rows move beneath it. A thin line below the frozen row marks the boundary between the stationary and scrolling portions of the worksheet. The command targets the worksheet’s first row; it does not freeze whichever row happens to be selected.

In Excel for Mac, the equivalent command is on View > Freeze Panes > Freeze Top Row. Excel for the web also offers Freeze Panes commands on the View tab, though the ribbon layout can differ slightly from the desktop app. If you do not see the exact control, look in the View tab’s Freeze Panes menu.

Freeze more than one heading row

If your headings occupy several rows, freeze them together rather than using Freeze Top Row. The general rule is to select the cell immediately below the rows you want to keep visible, then choose View > Freeze Panes > Freeze Panes. Excel freezes the rows above the selected cell. It also freezes any columns to the left of that cell, so the selection determines both parts of the result.

For example, if rows 1 through 3 contain a report title, a note, and column headings, select cell A4 and choose Freeze Panes. Rows 1, 2, and 3 stay visible while you scroll down. If you select A3 instead, only rows 1 and 2 are above the selection, so row 3 will scroll with the rest of the sheet.

There is an important limitation: freezing works from the top and left edges of the worksheet. You cannot freeze only row 3 while allowing rows 1 and 2 to scroll away. To keep row 3 visible, you would need to reorganize the sheet so the desired heading is at the top, or freeze all rows above it as well.

Keep a row and a column visible together

Freeze Panes can hold rows and columns at the same time. Select the cell that is one row below the last row to freeze and one column to the right of the last column to freeze. Excel keeps everything above and to the left of that cell stationary.

For instance, to keep row 1 and column A visible, select cell B2 and choose View > Freeze Panes > Freeze Panes. Row 1 remains at the top, and column A remains at the left, while the main area scrolls vertically or horizontally. To freeze rows 1 through 3 and columns A through B, select C4 first.

Choosing the wrong cell is a common source of confusion. If you want only the top row frozen, use the dedicated Freeze Top Row command. If you use the general Freeze Panes command, check the selected cell’s position first: everything above it and everything to its left will be frozen.

Unfreeze panes or change the frozen area

To remove a freeze, open View > Freeze Panes and choose Unfreeze Panes. The worksheet returns to normal scrolling. Then select the correct cell and apply the appropriate freeze command again. Excel does not let you add a second, independent frozen region to the same worksheet; unfreeze first if you want to redefine the boundary.

Unfreezing does not delete, edit, or rearrange worksheet data. It only changes how the sheet is displayed. The same is true of freezing: it is a view setting rather than a change to cell contents. If the frozen line appears in an unexpected place, unfreeze and repeat the steps with a more suitable selection.

Why the row may not stay visible

When a freeze seems not to work, first confirm that you are scrolling the worksheet rather than moving the active cell without scrolling. Then check whether the intended row is actually at the top of the sheet and whether the command was applied to the right worksheet. Freeze settings apply to the current worksheet, so another tab can have a different arrangement.

The wrong command was used: Freeze Panes depends on the selected cell. For just row 1, use Freeze Top Row.
More rows are frozen than expected: The cell selected for Freeze Panes may have been several rows below the top. Choose Unfreeze Panes and repeat the operation.
The heading is not in row 1: Freeze Top Row always means worksheet row 1, not the first row of a table or the row currently visible on screen.
You are looking at a print preview: Frozen panes affect the worksheet view, not printed page layout. Use print titles if headings must repeat on paper or in a PDF.
The sheet is protected or shared in a particular way: Some workbook settings can limit changes. If the command is unavailable, check whether the worksheet or workbook is protected and whether you have permission to modify it.

Also distinguish Freeze Panes from Split, another command in the View tab. Split divides the window into separately scrollable panes; it is useful for comparing distant parts of a sheet, but it is not the same as keeping a heading row fixed. If you see multiple scroll bars or movable divider lines, you may have activated a split instead.

Freezing rows versus repeating them in print

A frozen row stays visible in the on-screen worksheet as you scroll. It does not automatically repeat at the top of every printed page. For a multipage report, use Excel’s print-title setting instead: open Page Layout > Print Titles, then, in the Page Setup dialog, set the desired rows in Rows to repeat at top. A common entry for row 1 is $1:$1. This setting controls printed output, including a PDF created through printing; it does not pin the row during ordinary scrolling.

It is possible to need both features. Freeze row 1 to navigate a long worksheet on screen, and set row 1 as a print title so the heading also appears on each printed page. Check Print Preview to see how the pages break. A heading may repeat correctly but still be separated from some data by an awkward page break, so print layout may need further adjustment.

When a table or moving the row is a better choice

If your data is a simple list with one header row, converting the range to an Excel table can make the headings easier to work with. Select a cell in the data and choose Insert > Table, confirming that the table has headers if appropriate. Tables add filtering and structured formatting features. When you scroll within a table, Excel can display its column names in the worksheet’s column-heading area in place of the usual column letters. This behavior is tied to working in the table; it is not a general way to pin an arbitrary row in every worksheet situation.

If the actual requirement is that a particular record become the first row, freezing is not the answer. You need to move or sort the data. To move an entire row, select its row number, cut it, then right-click the destination row number and choose Insert Cut Cells. Moving a row can affect formulas, references, and the meaning of the dataset, so review the result before saving. If you only want records displayed in a different order, sorting the full dataset is often safer than manually moving one row; include all related columns so records stay together.

Frequently Asked Questions

Can I keep row 2 at the top while row 1 scrolls?
No. Freeze Panes freezes a continuous area starting at the worksheet’s top edge. To keep row 2 visible, you must freeze row 1 as well, or move the desired heading into row 1.

Can I freeze the top row and the first column?
Yes. Select cell B2, then choose View > Freeze Panes > Freeze Panes. That selection freezes row 1 above it and column A to its left.

Does Freeze Top Row affect every sheet in the workbook?
No. The setting applies to the active worksheet. Repeat the command on each sheet where you want a heading to stay visible.

Will a frozen row appear on every printed page?
No. Use Page Layout > Print Titles and set Rows to repeat at top for that purpose. Freeze Panes is for the on-screen worksheet view.

How do I remove the line under a frozen row?
Choose View > Freeze Panes > Unfreeze Panes. The boundary line disappears because the frozen region is removed; the worksheet’s data remains unchanged.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.