A detailed guide on Microsoft Excel shortcuts:
1. Navigation Shortcuts:
- Ctrl + ↑ (Up Arrow): Moves to the top cell of the current column.
- Ctrl + ↓ (Down Arrow): Moves to the bottom cell of the current column.
- Ctrl + ← (Left Arrow): Moves to the leftmost cell of the current row.
- Ctrl + → (Right Arrow): Moves to the rightmost cell of the current row.
- Ctrl + Home: Moves to the top-left cell of the worksheet.
- Ctrl + End: Moves to the last cell that contains data in the worksheet.
2. Selection Shortcuts:
- Shift + ↑ (Up Arrow): Extends the selection up by one cell.
- Shift + ↓ (Down Arrow): Extends the selection down by one cell.
- Shift + ← (Left Arrow): Extends the selection to the left by one cell.
- Shift + → (Right Arrow): Extends the selection to the right by one cell.
- Ctrl + Shift + ↑ (Up Arrow): Extends the selection to the top cell of the current column.
- Ctrl + Shift + ↓ (Down Arrow): Extends the selection to the bottom cell of the current column.
- Ctrl + Shift + ← (Left Arrow): Extends the selection to the leftmost cell of the current row.
- Ctrl + Shift + → (Right Arrow): Extends the selection to the rightmost cell of the current row.
3. Editing Shortcuts:
- F2: Activates the active cell for editing.
- Ctrl + X: Cuts the selected cells or content.
- Ctrl + C: Copies the selected cells or content.
- Ctrl + V: Pastes the cut or copied cells or content.
- Ctrl + Z: Undoes the last action.
- Ctrl + Y: Redoes the last action.
- Ctrl + D: Copies the contents of the topmost cell of a selected range to the cells below.
- Ctrl + R: Copies the contents of the leftmost cell of a selected range to the cells on the right.
4. Formatting Shortcuts:
- Ctrl + B: Applies or removes bold formatting.
- Ctrl + I: Applies or removes italic formatting.
- Ctrl + U: Applies or removes underline formatting.
- Ctrl + 1: Opens the Format Cells dialog box.
- Ctrl + Shift + $: Applies the currency format.
- Ctrl + Shift + %: Applies the percentage format.
- Ctrl + Shift + #: Applies the date format.
- Ctrl + Shift + @: Applies the time format.
5. Formula Shortcuts:
- Ctrl + A: Selects all cells in the current region if the cells are empty. Otherwise, selects the entire worksheet.
- F4: Repeats the last action.
- F9: Calculates all worksheets in all open workbooks.
- Shift + F9: Calculates the active worksheet.
- Ctrl + Shift + U: Switches between displaying cell values and formulas in the worksheet.
- Alt + =: Inserts the SUM() function and adds up the numbers in the range above.
- Ctrl + Shift + ~: Applies the General number format.
These shortcuts can significantly enhance your productivity when working with Microsoft Excel. Practice using them regularly, and you'll find yourself navigating, selecting, editing, formatting, and using formulas more efficiently.