How to Hide and Unhide Rows in Google Sheets

Spreadsheets frequently grow to contain hundreds or even thousands of rows, making it difficult to focus on the data that currently matters. If you have rows containing intermediary calculations, old historical records, reference data, or archived information that you do not want to delete but also do not need to see right now, hiding them is the ideal solution.

Hidden rows remain fully functional in Google Sheets. Any formulas referencing hidden cells continue to calculate correctly, and the data remains accessible whenever you need it. The rows simply disappear from view, giving you a cleaner, more focused workspace.

How to Hide a Single Row

1. Open your Google Sheets document.
2. Look at the far-left edge of your screen where the row numbers (1, 2, 3, etc.) are displayed.
3. Right-click exactly on the number of the row you want to hide (for example, right-click the number 5).
4. A context menu will appear. Click on Hide row.

The row will immediately disappear from view. You will notice a gap in the numbering sequence (for example, it will skip from 4 directly to 6), and small arrow icons will appear between the remaining row numbers, indicating that data is hidden at that location.

How to Hide Multiple Consecutive Rows

1. Click on the number of the first row you want to hide in the row header on the left.
2. Hold down your mouse button and drag downward to select multiple consecutive row numbers. The selected rows will highlight in blue.
3. Right-click anywhere within the highlighted row numbers.
4. Click on Hide rows [X – Y] (for example, “Hide rows 5 – 10”).

All selected rows will be hidden simultaneously.

How to Hide Non-Consecutive Rows

Sometimes you need to hide rows that are scattered throughout your spreadsheet rather than in a continuous block.

1. Click on the first row number you want to hide.
2. Hold down the Ctrl key (or ⌘ Command on Mac) and click on each additional row number you want to hide.
3. Right-click on any of the highlighted row numbers.
4. Click Hide rows.

All selected rows will be hidden in one action, regardless of their position in the spreadsheet.

How to Unhide Rows

When you need to access hidden data again, restoring rows takes only a single click.

1. Look at the row numbers on the left side of the screen and find the gap where your rows are hidden (for example, between rows 4 and 11).
2. You will see small directional arrow icons in that gap — two arrows pointing outward.
3. Click directly on either arrow icon.

The hidden rows will instantly reappear, restoring your spreadsheet to its previous state.

How to Unhide All Rows at Once

If you have hidden rows scattered throughout a large spreadsheet and want to reveal everything at once:

1. Select the entire sheet by clicking the small rectangle in the top-left corner where the row numbers and column letters meet. Alternatively, press Ctrl + A (or ⌘ + A on Mac).
2. Right-click on any row number in the header.
3. Click Unhide rows.

Every hidden row in the entire sheet will instantly reappear.

Using the Menu Bar Method

If you prefer using the menu bar rather than right-clicking:

1. Select the row or rows you want to hide by clicking their row numbers.
2. Click Format in the top menu bar.
3. Hover over Rows (or the relevant option).
4. Click Hide rows.

This method is particularly useful on devices where right-clicking is less convenient, such as certain trackpad configurations.

Important Considerations When Hiding Rows

• Formulas remain intact: Any formulas that reference cells within hidden rows will continue to work correctly. For example, a SUM formula that includes hidden rows will still calculate the complete total. This is one of the key advantages of hiding rather than deleting data.
• Charts update correctly: If your hidden rows are part of a chart’s data range, the chart will continue to display data from those rows. Hiding rows does not exclude them from charts.
• Printing behaviour: When you print a Google Sheets document, hidden rows are excluded from the printout by default. This is useful for creating clean reports without intermediary data.
• Sharing and collaboration: Hidden rows are visible to all collaborators who have edit access. Other editors can unhide the rows at any time. If you need to prevent others from seeing specific data, consider using protected ranges or separate sheets instead.
• Filters vs. hiding: If you regularly need to show and hide specific subsets of data based on criteria, using Google Sheets’ built-in filter feature (Data > Create a filter) is often more efficient than manually hiding and unhiding rows.

Keyboard Shortcuts for Hiding and Unhiding Rows

Google Sheets does not provide built-in keyboard shortcuts for hiding rows by default. However, you can access the feature quickly through the menu system:

1. Select the rows you want to hide.
2. Press Alt + Shift + 9 (Windows) to open the context menu options.

For users who frequently hide and unhide rows, creating a macro through Extensions > Macros can automate the process with a custom keyboard shortcut.

Hiding and unhiding rows is a fundamental spreadsheet skill that keeps your workspace organised without losing any data. Combined with filters and grouping features, it gives you complete control over which data is visible at any given time.