Alt+Semicolon: Select Visible Cells

The shortcut Alt+Semicolon (;) is to select the visible cells in the current selection.

Step 1: Click any cell in the worksheet;

Step 2: Hide one of the columns in the worksheet (e.g., column B)

Step 3: Press and hold the Alt key, then press the semicolon (;) from the keyboard. The cells in the worksheet will be selected.

Check More Excel Shortcuts

Leave a Reply