Google Sheets Freeze Bottom Row: What Works Instead

No. Google Sheets can freeze rows at the top of a sheet, but it has no built-in command to keep the bottom row fixed on screen while you scroll. To keep a total or other key information visible, place a summary in the top rows and freeze those rows, or use another practical workaround.

Can You Freeze the Bottom Row?

Google Sheets’ freeze feature is designed to keep rows at the top and columns at the left of the grid visible while you move through the rest of a sheet. It does not let you choose a row at the bottom and anchor it to the bottom edge of the browser window. Scrolling to the last row does not change that: the row may be visible until you scroll away, but it is not pinned there.

This is a common request for sheets with a grand total, running balance, status line, or final summary below a long list. The distinction matters: freezing a row means it stays in place as the grid scrolls; putting a calculation in a cell that references data farther down the sheet can keep the information current, but it does not freeze the original bottom row.

There is no hidden bottom-row option in the browser menus, and selecting the last row before opening the Freeze menu does not turn it into a bottom-anchored row. The workable solution depends on whether you need a value to remain visible, need the actual final record to stay on screen, or need repeated information on printed pages.

How Freezing Works in Google Sheets

In Google Sheets in a web browser, choose View > Freeze to see the available row and column options. Depending on the sheet and selection, you can freeze one or two top rows, freeze up to a particular row, or remove frozen rows. The frozen area remains at the top of the grid; the unfrozen area scrolls beneath it. The equivalent column options keep columns at the left.

For example, freezing the first row keeps row 1 visible while you scroll through rows 2, 200, or 2,000. Freezing the first two rows keeps both of those rows visible. The menu does not offer a bottom position, and freezing more rows does not shift the frozen area down to the bottom. It simply makes a taller fixed section at the top.

Frozen rows take up screen space, so freeze only what readers need to identify or interpret the data. A header row is often useful; a large block of introductory notes usually is not. You can still edit cells in frozen rows, and freezing does not protect them from changes. Use protected ranges separately if you need to limit who can edit particular cells.

Freeze a Header and Put a Summary at the Top

For a long list that ends with a total, the closest built-in substitute is a compact summary row near the top. Put column headings in row 1, place the important total or status in row 2, and freeze both rows. Your data can then scroll while the labels and summary remain visible.

Insert a row near the top if your data already starts immediately below its headings.
Keep the column names in row 1 and add a clear label such as Total in row 2.
Put a calculation or other summary value in row 2, making sure its range covers the data rows rather than the summary row itself.
Choose View > Freeze > 2 rows.
Scroll down to check that the header and summary stay in view and do not cover too much of the usable grid.

For a concrete example, assume A1:B1 contains the headings Item and Amount, A2 contains the label Total, and the amounts 12, 8, 15, and 5 are in B3:B6. In that layout, enter =SUM(B3:B6) in B2. The displayed result is 40. Freeze the first two rows, and the total remains visible as the list scrolls. This shows a summary of the bottom data; it does not pin the original final row.

If new entries will be added, leave room in the calculation range or update it as the list grows. A bounded range such as B3:B500 is simple and compatible with both Sheets and Excel, but entries beyond row 500 will not be included unless the formula is expanded. Choose a range that fits the sheet’s intended use and check it when the data structure changes.

Other Ways to Keep a Bottom Total Handy

If you do not want a summary row above the data, consider one of these alternatives. Each solves a slightly different problem, and none makes the original bottom row stick to the bottom of the window.

Use a separate summary tab. Put totals, key measures, or a link to the latest result on a dedicated tab. This keeps the working list uncluttered and makes a useful overview for readers, but it does not display the summary and the list together.
Keep the total at the end and use Find or navigation. This preserves the familiar table layout and is suitable when readers only need the total occasionally. It is less convenient when they need to compare it with entries while scrolling.
Move the total row to the top. This is quick for a small, informal sheet, but placing a total inside the data range can disrupt sorting, filters, or formulas that assume one uninterrupted block of records.
Create a compact top summary area. This is often the best balance for a large working sheet: the detail stays in one table, while a few important figures remain visible in frozen rows.

For a structured data table, avoid inserting a total line among the records that users sort or filter. If the summary is at the top, keep it clearly separated from the header and data, and make sure a filter range includes only the actual column headings and records.

What Freezing Can and Cannot Do

Freezing changes how the grid is displayed while scrolling. It does not move a row, lock its contents, change a formula, or make the row appear at the bottom of every screen. It is also separate from sharing permissions: if a value should not be edited, freezing is not a substitute for restricting edits.

There is no direct bottom-row equivalent to select in the Sheets Freeze menu, and Google Sheets does not provide an Excel-style split-pane control that creates a separately scrolling lower section. Resizing the browser window or zooming out may make the last row visible along with more of the sheet, but that is a temporary view adjustment, not a pinned row. It can also make text harder to read and will vary with the user’s display.

Excel has a different interface, but its standard Freeze Panes feature likewise keeps rows above and columns to the left of a selected position fixed; it is not a command for pinning the last row at the bottom. Menu names and available view controls differ between Excel and Sheets, so instructions for one program should not be assumed to apply to the other.

Freeze Rows Versus Filters, Sorting, and Printing

Filters and frozen rows work together, but they solve different problems. A filter helps show a subset of records; freezing keeps chosen top rows visible as you scroll. Sorting changes the order of records, which can move a total if it is included in the sorted range. Keeping totals outside the filter’s data range, or in a separate summary area, reduces the chance that a sort treats the total as an ordinary record.

Printing is another distinct case. A row frozen on screen does not mean that the row at the bottom of the sheet will repeat as a footer on printed pages. If your goal is to print a long table with its column headings repeated, check the print settings and available header options in Sheets rather than relying on the on-screen freeze. Preview the pages before printing, because page breaks and scaling affect what appears on each sheet of paper.

Likewise, a freeze setting does not guarantee that a collaborator will see a particular bottom record. For sharing, a clearly labeled summary tab, a stable top summary, or a saved view of the relevant data is usually easier to understand than asking people to scroll to a certain position.

Common Problems and Fixes

The wrong rows stay visible: Open View > Freeze and choose the intended number of top rows, or remove the freeze and set it again. Check the dividing line between the fixed and scrolling areas.
The summary repeats or shifts during sorting: Keep summary cells outside the records being sorted. Select only the table’s data range when sorting, and ensure the header row is identified correctly.
The total does not include new entries: Inspect the formula range. A formula that ends at row 100 will not include an entry placed in row 101. Extend the range or use a setup that accounts for the expected growth.
Frozen rows occupy too much of the screen: Reduce the number of frozen rows. On a small laptop or with browser zoom increased, even two or three fixed rows can leave little room for scrolling data.
Someone expects the bottom record to remain visible: Explain that Sheets only anchors frozen rows at the top. Put the information they need in a top summary, or give them a separate summary tab.

If a menu option appears unavailable or the sheet behaves unexpectedly, confirm that you are editing the intended tab and that you are using Google Sheets in a browser. Also check whether the sheet has been opened in another spreadsheet program, since menus and behavior may differ there.

Choosing the Right Workaround

Choose based on the reader’s task. If people need to compare a total with records throughout a long list, a frozen summary row is usually the most convenient option. If they need a clean dataset for sorting and filtering, keep the table as a single block and place the summary on another tab. If the total is only needed at the end of a review, leaving it below the data may be simplest.

Before changing a shared sheet, consider how collaborators use its current layout. A new top row can affect filters, formulas, charts, and instructions that refer to specific row numbers. Make the purpose of each row obvious, verify that calculations still refer to the intended records, and test the view by scrolling through the sheet. That small check catches many layout problems before the change becomes confusing to others.

Frequently Asked Questions

Can Google Sheets freeze the last row?
No. Sheets can freeze rows at the top and columns at the left, but it cannot anchor a last row to the bottom of the browser window.

What is the closest way to keep a total visible?
Put the total in a summary row near the top, then choose View > Freeze and freeze enough top rows to include it. This keeps the result visible, not the original bottom row.

Can I freeze a row that is not at the top?
You can freeze rows up to a selected row, but the frozen block begins at row 1 and stays at the top. You cannot freeze an isolated lower row in place.

Does freezing a row stop people from editing it?
No. Freezing affects the scrolling view only. To control editing, use the sheet’s protection and permissions features.

Will a frozen row repeat at the bottom when I print?
No. Screen freezing and print layout are separate. Check the print preview and print settings for options relevant to repeating headings or adjusting page layout.

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.