Hide Columns in Excel Using a Keyboard Shortcut

The keyboard key combination for hiding columns is Ctrl+0.

Hide Separated Columns

Hide and Unhide Columns in Excel Using the Name Box

This method can be used to unhide any single column. In our example, we will be using column A.

Hide Columns Using the Context Menu

The options available in the context — or right-click menu — change depending upon the object selected when you open the menu. If the Hide option, as shown in the image below, is not available in the context menu it is likely that you didn’t select the entire column before right-clicking.

Hide a Single Column

Hide Adjacent Columns

Unhide Columns Using a Keyboard Shortcut

The key combination for unhiding columns is Ctrl+Shift+0. To unhide one or more columns, highlight at least one cell in the columns on either side of the hidden column(s) with the mouse pointer.

Hide Rows Using Shortcut Keys

The keyboard key combination for hiding rows is Ctrl+9:

Unhide Columns Using the Context Menu

As with the shortcut key method above, you must select at least one column on either side of a hidden column or columns to unhide them. For example, to unhide columns D, E, and G:

Hide Rows Using the Context Menu

The options available in the context menu — or right-click — change depending upon the object selected when you open it. If the Hide option, as shown in the image above, is not available in the context menu it is because you probably didn’t select the entire row.

Hide a Single Row

Hide Adjacent Rows

Hide Separated Rows

Hide and Unhide Rows Using the Name Box

This method can be used to unhide any single row. In our example, we will be using row 1.

Unhide Rows Using a Keyboard Shortcut

The key combination for unhiding rows is Ctrl+Shift+9.

Unhide Rows using Shortcut Keys and Name Box

Unhide Rows Using a Keyboard Shortcut

To unhide one or more rows, highlight at least one cell in the rows on either side of the hidden row(s) with the mouse pointer. For example, you want to unhide rows 2, 4, and 6.

Unhide Rows Using the Context Menu

As with the shortcut key method above, you must select at least one row on either side of a hidden row or rows to unhide them. For example, to unhide rows 3, 4, and 6: