Templates Services SQL Reports Excel Shortcuts Blog About Contact
⌨ Excel Shortcut Guide

Hide row Shortcut in Excel

Use this quick reference to learn the Windows shortcut, Mac shortcut, Ribbon path, and best use case for hide row in Excel.

Shortcut keys

WindowsCtrl + 9
MacCmd + 9

Ribbon path

Home → Format → Hide & Unhide → Hide Rows

What it does

Hides the selected rows. Use Ctrl+Shift+9 (or Cmd+Shift+9 on Mac) to unhide. Select surrounding rows first to unhide.

How to use this shortcut

  1. Open the Excel workbook and select the relevant cell, row, column, range, or sheet.
  2. Press the shortcut keys shown above for your platform.
  3. Confirm any dialog options if Excel opens a menu or prompt.

FAQ

What is the Excel shortcut for hide row?

On Windows, use Ctrl + 9. On Mac, use Cmd + 9.

Where is hide row in the Excel Ribbon?

The Ribbon path is Home → Format → Hide & Unhide → Hide Rows.

What does hide row do in Excel?

Hides the selected rows. Use Ctrl+Shift+9 (or Cmd+Shift+9 on Mac) to unhide. Select surrounding rows first to unhide.