Ctrl+Shift+1: Formats Numbers
Ctrl+Shift+1 formats numbers to have two decimals, thousands separator, and minus sign (-) for negative values. Please also check shortcut Ctrl+Shift+Exclamation Point (!). Step 1: Select the data you …
Category: Excel Shortcuts
Scroll Lock+End: Bottom-right Corner
The shortcut Scroll Lock+End is to move the cursor to the bottom-right corner of the window. Step 1: Click any cell in the worksheet, e.g., Cell A1 in this …
Ctrl+Shift+): Unhide Columns
The shortcut Ctrl+Shift+) is to unhide the selected columns. Check shortcut "Ctrl+0" to see how to hide columns. Step 1: Click any cell in the worksheet which contains hidden …
Shift+F4: Next Blank Cell
The shortcut Shift+F4 is to move cursor to the next blank cell. Step 1: Click any cell in the worksheet (e.g., A1); Step 2: Press and hold the Shift …
Shift+F5: "Find and Replace" Window
The shortcut Shift+F5 is to display the "Find and Replace" dialog box with the "Find" box as the default window. It is the same as the shortcut "Ctrl+F". Step …
Shift+F12: Save the Workbook
The shortcut Shift+F12 is to save the workbook. Please also refer to the shortcut Alt+F2. Step 1: Click any cell in the worksheet; Step 2: Press and hold the …