Shortcut keys are a great way to quickly hide or unhide rows or columns in Excel. To quickly hide a row, select the row number(s) at the left side of your worksheet and press Ctrl + 9. To quickly unhide a hidden row, select the row number(s) at the left side of your worksheet and press Ctrl + Shift + 9.
To quickly hide a column, select the column letter(s) at the top of your worksheet and press Ctrl + 0 (zero). To quickly unhide a hidden column, select the column letter(s) at the top of your worksheet and press Ctrl + Shift+ 0 (zero).
To unhide all rows and columns, select the whole sheet as explained above, and then press Ctrl + Shift + 9 to show hidden rows and Ctrl + Shift + 0 to show hidden columns.
Hide Rows Using Shortcut Keys The keyboard key combination for hiding rows is Ctrl+9: Click on a cell in the row you want to hide to make it the active cell. Press and hold down the Ctrl key on the keyboard. Press and release the 9 key without releasing the Ctrl key.
The shortcut for hiding columns in Excel is Ctrl + 0. For the sake of clarity, the last key is zero, not the uppercase letter "O". To hide a single column, select any cell within it, then use the shortcut. To hide multiple columns, select one or more cells in each column, and then press the key combination.
First, Press Ctrl + A + A to select the entire sheet to unhide all the hidden columns from the whole sheet. Or select only the specific columns range using Ctrl + Space and Shift + < or > arrow keys if you want to unhide columns only from that specific range of columns and not from the entire sheet.