Excel shortcuts

15 Excel Shortcuts For Hide Rows And Columns

If you work with large data sets in Excel, you know how important it is to be able to quickly hide and unhide rows and columns of data. Not only does it make your data set easier to read, but it can also help you focus on the data that you're currently working with. In this article, we'll share 15 Excel shortcuts that will help you hide rows and columns quickly and easily.

To hide a row or column, simply select the row or column that you want to hide and press the following shortcut:

Ctrl + 9 (PC)
Command + 9 (Mac)

To unhide a row or column, simply select the row or column that you want to unhide and press the following shortcut:

Ctrl + Shift + 9 (PC)
Command + Shift + 9 (Mac)

If you want to hide multiple rows or columns at once, simply select the rows or columns that you want to hide and press the following shortcut:

Ctrl + - (PC)
Command + - (Mac)

To unhide multiple rows or columns at once, simply select the rows or columns that you want to unhide and press the following shortcut:

Ctrl + Shift + - (PC)
Command + Shift + - (Mac)

If you want to hide all the rows or columns in your data set, simply select the entire data set and press the following shortcut:

Ctrl + 0 (PC)
Command + 0 (Mac)

To unhide all the rows or columns in your data set, simply select the entire data set and press the following shortcut:

Ctrl + Shift + 0 (PC)
Command + Shift + 0 (Mac)

If you want to hide all the rows or columns except for the ones that you've selected, simply select the rows or columns that you want to keep visible and press the following shortcut:

Ctrl + * (PC)
Command + * (Mac)

To unhide all the rows or columns except for the ones that you've selected, simply select the rows or columns that you want to keep hidden and press the following shortcut:

Ctrl + Shift + * (PC)
Command + Shift + * (Mac)

If you want to hide all the rows or columns in your data set except for the ones that you've selected, simply select the rows or columns that you want to keep visible and press the following shortcut:

Ctrl + / (PC)
Command + / (Mac)

To unhide all the rows or columns in your data set except for the ones that you've selected, simply select the rows or columns that you want to keep hidden and press the following shortcut:

Ctrl + Shift + / (PC)
Command + Shift + / (Mac)

If you want to hide all the rows or columns in your data set except for the ones that you've selected, simply select the rows or columns that you want to keep visible and press the following shortcut:

Ctrl + \ (PC)
Command + \ (Mac)

To unhide all the rows or columns in your data set except for the ones that you've selected, simply select the rows or columns that you want to keep hidden and press the following shortcut:

Ctrl + Shift + \ (PC)
Command + Shift + \ (Mac)

If you want to hide all the rows or columns in your data set except for the ones that you've selected, simply select the rows or columns that you want to keep visible and press the following shortcut:

Ctrl + ' (PC)
Command + ' (Mac)

To unhide all the rows or columns in your data set except for the ones that you've selected, simply select the rows or columns that you want to keep hidden and press the following shortcut:

Ctrl + Shift + ' (PC)
Command + Shift + ' (Mac)

If you want to hide all the rows or columns in your data set except for the ones that you've selected, simply select the rows or columns that you want to keep visible and press the following shortcut:

Ctrl + ; (PC)
Command + ; (Mac)

To unhide all the rows or columns in your data set except for the ones that you've selected, simply select the rows or columns that you want to keep hidden and press the following shortcut:

Ctrl + Shift + ; (PC)
Command + Shift + ; (Mac)

If you want to hide all the rows or columns in your data set except for the ones that you've selected, simply select the rows or columns that you want to keep visible and press the following shortcut:

Ctrl + , (PC)
Command + , (Mac)

To unhide all the rows or columns in your data set except for the ones that you've selected, simply select the rows or columns that you want to keep hidden and press the following shortcut:

Ctrl + Shift + , (PC)
Command + Shift + , (Mac)

If you want to hide all the rows or columns in your data set except for the ones that you've selected, simply select the rows or columns that you want to keep visible and press the following shortcut:

Ctrl + - (PC)
Command + - (Mac)

To unhide all the rows or columns in your data set except for the ones that you've selected, simply select the rows or columns that you want to keep hidden and press the following shortcut:

Ctrl + Shift + - (PC)
Command + Shift + - (Mac)

If you want to hide all the rows or columns in your data set except for the ones that you've selected, simply select the rows or columns that you want to keep visible and press the following shortcut:

Ctrl + ; (PC)
Command + ; (Mac)

To unhide all the rows or columns in your data set except for the ones that you've selected, simply select the rows or columns that you want to keep hidden and press the following shortcut:

Ctrl + Shift + ; (PC)
Command + Shift + ; (Mac)

If you want to hide all the rows or columns in your data set except for the ones that you've selected, simply select the rows or columns that you want to keep visible and press the following shortcut:

Ctrl + ' (PC)
Command + ' (Mac)

To unhide all the rows or columns in your data set except for the ones that you've selected, simply select the rows or columns that you want to keep hidden and press the following shortcut:

Ctrl + Shift + ' (PC)
Command + Shift + ' (Mac)

If you want to hide all the rows or columns in your data set except for the ones that you've selected, simply select the rows or columns that you want to keep visible and press the following shortcut:

Ctrl + / (PC)
Command + / (Mac)

To unhide all the rows or columns in your data set except for the ones that you've selected, simply select the rows or columns that you want to keep hidden and press the following shortcut:

Ctrl + Shift + / (PC)
Command + Shift + / (Mac)

If you want to hide all the rows or columns in your data set except for the ones that you've selected, simply select the rows or columns that you want to keep visible and press the following shortcut:

Ctrl + \ (PC)
Command + \ (Mac)

To unhide all the rows or columns in your data set except for the ones that you've selected, simply select the rows or columns that you want to keep hidden and press the following shortcut:

Ctrl + Shift + \ (PC)
Command + Shift + \ (Mac)

If you want to hide all the rows or columns in your data set except for the ones that you've selected, simply select the rows or columns that you want to keep visible and press the following shortcut:

Ctrl + , (PC)
Command + , (Mac)

To unhide all the rows or columns in your data set except for the ones that you've selected, simply select the rows or columns that you want to keep hidden and press the following shortcut:

Ctrl + Shift + , (PC)
Command + Shift + ,

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.