Ctrl+Asterisk: Select Current Range
The shortcut Ctrl+Asterisk (*) is to select the current range around the active cell. Step 1: Click any cell in the data range (e.g., C2); Step 2: Press and …
Category: Excel Shortcuts
Alt+Enter: Start a New Line in the Cell
The shortcut Alt+Enter is to start a new line in the same cell. Step 1: Double click the cell and move the cursor to the end of the content …
Ctrl+A: Selects Current Data
The shortcut Ctrl+A is one of the most useful shortcuts in Excel. The shortcut is to select the current data range where the cursor is or the whole worksheet …
Up Arrow: One Cell Up
The Up Arrow is to move one cell up. Every time you press the key up arrow from the keyboard, the cursor will move up one cell to the …
Tab: One Cell Right
The key Tab is to move one cell to the right. Step 1: Click any cell in the worksheet (e.g., B3) Step 2: Click the "Tab" key from the …
Shift+Tab: the Front Cell
The shortcut Shift+Tab is to move the cursor to the cell in front. Step 1: Click any cell in the worksheet except the cells in the first column (e.g., …