Alt+A: Open Data Tab
The shortcut Alt+A is to go to the Data tab in the Ribbon. Step 1: Click any cell in the worksheet; Step 2: Press the Alt key from the …
Category: Excel Shortcuts
F10: Select Active Tab in the Ribbon
The F10 is to select the active tab in the Ribbon, and activate the access keys (Alt key does the same work). Step 1: Click any cell in the …
Alt: Selects Active Tab of Ribbon
The Alt key is to select the active tab of the Ribbon and activate the access keys (F10 does the same thing). Step 1: Click any cell in the …
Shift+F2: Add/Edit Cell Comment
The shortcut Shift+F2 is to add or edit the cell comment. Step 1: Click the cell you want to add the comment; Step 2: Press and hold the "Shift" …
F2: Put Insertion Point
The F2 function is to put the insertion point at the end of the contents. Step 1: Select the data range; Step 2: Press the F2 key from the …
Ctrl+X: Moves Selected Cells
The shortcut Ctrl+X is to move the selected cells. Step 1: Select data range A1:C1; Step 2: Right-click and copy data range (or using shortcut Ctrl+C); Step 3: Click …