Excel Shortcut Keys - A Quick Guide

Shortcut Keys For Formatting

1. Display the Style dialog box

[Alt]+[']

2. Display the Format Cells dialog box
[Ctrl]+[1] This shortcut works only with the 1 key in the key row, not the 1 key on the keypad.

3. Apply the General format
[Ctrl]+[Shift]+[~]

4. Apply the two-decimal-place Currency format
[Ctrl]+[Shift]+[$]

5. Apply the Percentage format (no decimal places)
[Ctrl]+[Shift]+[%]

6. Apply the Exponential format with two decimal places
[Ctrl]+[Shift]+[^]

7. Apply the DD+MMM+YY date format
[Ctrl]+[Shift]+[#]

8. Apply the HH:MM AM/PM time format
[Ctrl]+[Shift]+[@]

9. Apply the two-decimal-place number format with the thousands separator
[Ctrl]+[Shift]+[!]

10. Toggle strikethrough
[Ctrl]+[5]

Shortcut Keys When hiding and unhiding rows and columns

11. Hide all selected rows
[Ctrl]+[9]

12. Hide all selected columns
[Ctrl]+[0]

13. Unhide hidden rows in the selection
[Ctrl]+[Shift]+[(]

14. Unhide hidden columns in the selection
[Ctrl]+[Shift]+[)]

Shortcut Keys When Moving Cells

1. Move the active cell up or down one row, or left or right one column
[←], [→], [↓], [↑]

2. Insert a new worksheet in the active workbook
[Shift]+[F11], [Alt]+[Shift]+[F1]

3. Move to the first cell in the active row
[Home]

4. Move to the first cell in the worksheet
[Ctrl]+[Home]

5. Move to the last used cell in the worksheet
[Ctrl]+[End]

6. Move to the next worksheet
[Ctrl]+[PageDown]

7. Move to the previous worksheet
[Ctrl]+[PageUp]

8. Select the current worksheet and the next worksheet
[Ctrl]+[Shift]+[PageDown]

9. Select the current worksheet and the previous worksheet
[Ctrl]+[Shift]+[PageUp]

10. Move to the specified edge of the data region
[Ctrl]+[→], [Ctrl]+[←], [Ctrl]+[↓], [Ctrl]+[↑]

11. Move down one screen
[PageDown]

12. Move up one screen
[PageUp]

13. Move to the right by one screen
[Alt]+[PageDown]

14. Move to the left by one screen
[Alt]+[PageUp]

15. Scroll the workbook to display the active cell
[Ctrl]+[Backspace]

16. Display the Go To dialog box
[Ctrl]+[G]

Shortcut Keys When Selecting Cells and ranges

1. Extend the selection in the direction of the arrow key

[Shift]+[→], [Shift]+[←], [Shift]+[↓], [Shift]+[↑]
2. Select the current column
[Ctrl]+[Spacebar]
3. Select the current row
[Shift]+[Spacebar]
4. Select all cells on the current worksheet
[Ctrl]+[A]
5. Reduce the selection to the active cell
[Shift]+[Backspace]
6. Select all the objects on the current worksheet while retaining the current selection
[Ctrl]+[Shift]+[Spacebar]
7. Toggle Extend mode on and off
[F8]
8. Toggle Add mode on and off
[Shift]+[F8]
9. Extend the selection to the first or last cell in the data area
[Ctrl]+[Shift]+[→], [Ctrl]+[Shift]+[←], [Ctrl]+[Shift]+[↓], [Ctrl]+[Shift]+[↑]
10. Extend the selection to the first cell in the row
[Shift]+[Home]
11. Extend the selection to the first cell in the worksheet
[Ctrl]+[Shift]+[Home]
12. Extend the selection to the last cell used on the worksheet
[Ctrl]+[Shift]+[End]
13. Extend the selection to the last cell with contents in the active column or row
[End], then [Shift]+[→], [Shift]+[←], [Shift]+[↓], [Shift]+[↑]
14. Extend the selection to the last cell with contents on the worksheet
[End], then [Shift]+[Home]
15. Extend the selection to the last cell in the active row
[End], then [Shift]+[Enter]
16. Extend the selection downward by one screen
[Shift]+[PageDown]
17. Extend the selection upward by one screen
[Shift]+[PageUp]
18. Extend the selection to the first cell in the window
[ScrollLock], then [Shift]+[Home]
19. Extend the selection to the last cell in the window
[ScrollLock], then [Shift]+[End]

Shortcut Keys When Working with Borders

1. Apply an outline border
[Ctrl]+[Shift]+[&]
2. Remove the outline border
[Ctrl]+[Shift]+[_]
3. Toggle the left border on the selected cells
[Alt]+[L]
4. Toggle the right border on the selected cells
[Alt]+[R]
5. Toggle the top border on the selected cells
[Alt]+[T]
6. Toggle the bottom border on the selected cells
[Alt]+[B]
7. Toggle the horizontal border on the selected cells
[Alt]+[H]
8. Toggle the vertical border on the selected cells
[Alt]+[V]
9. Toggle the downward diagonal border on the selected cells
[Alt]+[D]
10. Toggle the upward diagonal border on the selected cells
[Alt]+[U]

Shortcut Keys When Working with Formulas

1. Start creating a formula
[=]
2. Enter the formula in the cell
[Enter]
3. Enter the formula as an array formula
[Ctrl]+[Shift]+[Enter]
4. Toggle between displaying formula results and formulas
[Ctrl]+`
5. Display the Insert Function dialog box
[Shift]+[F3]
6. Display the Function Arguments dialog box
[Ctrl]+[A]
7. Enter the argument names in the Formula bar
[Ctrl]+[Shift]+[A]
8. Displays the Paste Name dialog box
[F3]
9. Insert an AutoSum formula in the active cell
[Alt]+[=]
10. Copy the value of the cell above the active cell
[Ctrl]+[Shift]+["]
11. Copy the formula from the cell above the active cell
[Ctrl]+[']





Excel Shortcut Keys