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: