Excel Shortcuts to Hide or Unhide Rows and Columns

Written by

Editorial Team

Reviewed by

Steve Rynearson

Last updated on October 18, 2023

This tutorial will demonstrate how to hide and unhide columns and rows with shortcuts.

Hide Columns & Rows

Hide Columns

To hide column(s):

1. Click on a cell in the Column you want to hide. (Use CTRL and/or SHIFT to select multiple cells).
2.

PC Shortcut:Ctrl+0
Mac Shortcut:^+0

Hide Columns

Hide Rows

To hide row(s):

1. Click on a cell in the Row you want to hide. (Use CTRL and/or SHIFT to select multiple cells).

2.

PC Shortcut:Ctrl+9
Mac Shortcut:^+9

Hide Rows

Unhide Rows

To unhide row(s):

1. Highlight the two rows before and after the hidden row.
2.

PC Shortcut:Ctrl+Shift+9
Mac Shortcut:^++9

Unhide Rows

Note: This shortcut is the same as the hide row shortcut (CTRL + 9), except add SHIFT to unhide instead.

Unhide Columns

To unhide column(s):

1. Highlight the two columns around the hidden column.

2.

PC Shortcut:Ctrl+Shift+0
Mac Shortcut:^++0

Unhide Columns

AI Formula Generator

Try for Free