Excel Basics – Keyboard Shortcuts in Excel

Excel keyboard shortcuts are a great way to save time and increase your productivity. There are shortcuts for almost every task in Excel, from basic navigation to complex formulas.

Basic Keyboard Shortcuts

Select cell B2.

1. To select the entire range, press CTRL + a (if you press CTRL + a one more time Excel selects the entire sheet).

2. To copy the range, press CTRL + c (to cut a range, press CTRL + x).

3. Select cell A6 and press CTRL + v to paste this range.

4. To undo this operation, press CTRL + z

Keyboard Shortcuts for Moving active Cell

Select cell B2.

1. To quickly move to the bottom of the range, hold down CTRL and press ↓

2. To quickly move to the right of the range, hold down CTRL and press →

Try it yourself. Hold down CTRL and press the arrow keys to move from edge to edge.

Selecting

Select cell A1.

1. To select cells while moving down, hold down SHIFT and press ↓ a few times.

2. To select cells while moving to the right, hold down SHIFT and press → a few times.

Formulas

Select cell F2.

1. To quickly insert the SUM function, press ATL + =, and press Enter.

2. Select cell F2, hold down SHIFT and press ↓ Five times.

3. To fill a formula down, press CTRL + d (down).

Note: in a similar way, you can fill a formula right by pressing CTRL + r (right).

Formatting

Select the range B2:F7.

1. To launch the ‘Format cells’ dialog box, press CTRL + 1

2. Press TAB and press ↓ two times to select the Currency format.

3. Press TAB and press ↓ two times to set the number of decimal places to 0.

4. Press Enter.

Result:

5. To quickly bold a range, select the range and press CTRL + b

These are just a few of the many Excel keyboard shortcuts available. To learn more, you can consult the Excel help file or search online for tutorials.

Here are some additional tips for using Excel keyboard shortcuts:

• You can use keyboard shortcuts in combination with the mouse. For example, you can press Ctrl+A to select all cells in a worksheet, and then press Ctrl+C to copy them.
• You can use this shortcuts to quickly navigate to specific cells or ranges of cells. For example, you can press Ctrl+Home to move to the top of the worksheet, or Ctrl+End to move to the bottom of the worksheet.
• You can use keyboard shortcuts to perform complex tasks that would be difficult or time-consuming to do with the mouse. For example, you can use keyboard shortcuts to create pivot tables, macros, and custom functions.

By learning and using Excel keyboard shortcuts, you can save time and increase your productivity.

For more Keyboard shortcuts in Excel click here

Download this file for some useful Excel Shortcut Keys