Hide Columns in Excel Using a Keyboard Shortcut
The keyboard key combination for hiding columns isCtrl+0.
Clickon a cell in the column you want to hide to make it the active cell.
Press and holddown theCtrlkey on the keyboard.
Press and release the0key without releasing theCtrlkey.
The column containing the active cell should be hidden from view.
Right-punch the selected column to bring up the context menu.
The selected column, the column letter, and any data in the column will be hidden from view.
Right-press the selected columns.
The selected columns and column letters will be hidden from view.
Hiddenformulascontainingcell referenceswill update if the data in the referenced cells changes.
Hide Separated Columns
In the column header tap on the first column to be hidden.
Press and hold down theCtrlkey on the keyboard.
Continue to hold down theCtrlkey and click once on each additional column to be hidden to select them.
In the column header, right-tap on one of the selected columns and chooseHide.
The selected columns and column letters will be hidden from view.
In our example, we will be usingcolumn A. pop in thecell reference A1into theName Box.
Press theEnterkey on the keyboard to opt for hidden column.
hit theFormaticonon the ribbon to launch the drop-down.
In the Visibility section of the menu, chooseHide & Unhide>Hide ColumnsorUnhide Column.
Unhide Columns Using a Keyboard Shortcut
The key combination for unhiding columns isCtrl+Shift+0.
key in the cell reference A1 into theName Box.
Press and hold down theCtrland theShiftkeys on the keyboard.
Press and release the0key without releasing theCtrlandShiftkeys.
Click and drag with the mouse to highlight columns A to G.
Press and release the0key without releasing theCtrlandShiftkeys.
The hidden column(s) will become visible.
If this shortcut doesn’t work, use another method from the article.
Click and drag with the mouse to highlight columns C to H to unhide all columns at one time.
Right-tap on the selected columns and chooseUnhide.
The hidden column(s) will become visible.
Press and release the9key without releasing theCtrlkey.
The row containing the active cell should be hidden from view.
Right-choose the selected row to launch the context menu.
The selected row, the row letter, and any data in the row will be hidden from view.
Right-clickon the selected rows and chooseHide.
The selected rows will be hidden from view.
Hide Separated Rows
In the row header, hit the first row to be hidden.
Continue to hold down theCtrlkey and click once on each additional row to be hidden to select them.
Right-choose one of the selected rows and chooseHide.
The selected rows will be hidden from view.
In our example, we will be using row 1. throw in the cell reference A1 into theNameBox.
Press theEnterkey on the keyboard to grab the hidden row.
tap on theHome tabof the ribbon.
hit theFormaticonon the ribbon to kick off the drop-down menu.
In the Visibility section of the menu, chooseHide & Unhide>Hide RowsorUnhide Row.
Unhide Rows Using a Keyboard Shortcut
The key combination for unhiding rows isCtrl+Shift+9.
Unhide Rows using Shortcut Keys and Name Box
PresstheEnterkey on the keyboard to choose the hidden row.
Press and hold down theCtrland theShiftkeys on the keyboard.
Row 1 will become visible.
For example, you want to unhide rows 2, 4, and 6.
To unhide all rows,click and drag with the mouse to highlight rows 1 to 7.
Press and release the number9key without releasing theCtrlandShiftkeys.
The hidden row(s) will become visible.
Click and drag with the mouse to highlight rows 2 to 7 to unhide all rows at one time.
Right-press the selected rows and chooseUnhide.
The hidden row(s) will become visible.
Select thePage Layouttab, then turn off theViewcheckbox under Gridlines.
Next, verify thatProtect worksheet and contents of locked cellsis turned on, then selectOK.
