Ctrl+Shift+9: Unhide the Selected Rows

The shortcut Ctrl+Shift+9 is to unhide the selected rows. Please check "Ctrl+9" to see how to hide rows, or see more selection functions.

Step 1: Select the row that are hidden;

This image has an empty alt attribute; its file name is excelctrlshfitparenthesis001.jpg

Step 2: Press and hold Ctrl and Shift keys, then press number 9 from the keyboard in the alphanumeric section. The hidden rows will appear.

Check More Excel Shortcuts

Leave a Reply