How to Use Shortcut to Auto Sum in Excel
The shortcut "Alt+=" is to AutoSum the numbers that are adjacent in the same row or column. The shortcut will sum only the adjacent numbers. Please see below for …
Category: Excel Shortcuts
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 …
Alt+Apostrophe: Format Style Box
The shortcut Alt+Apostrophe is to display the format "Style" dialog box. Step 1: Click any cell in the worksheet; Step 2: Press and hold the Alt key, then press …
Alt, W, I: Switch to Page Break Preview
The shortcut Alt, W, I is to switch to the page break preview. Step 1: Click any cell in the worksheet; Step 2: Press the Alt key from the …
Alt, W, L: Switch to Normal View
The shortcut of "Alt, W, L" is to switch the worksheet to the normal view from the "Page Layout" view or the "Page Break Preview" view. This shortcut is …
Alt, W, P: Switch to Page Layout View
The shortcut Alt, W, P is to switch the worksheet to the "Page Layout" view. Step 1: Click anywhere in the worksheet; Step 2: Click the "Alt" key from …