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.

Excel Basics - Keyboard Shortcuts Basic Example

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

Excel Basics - Keyboard Shortcuts CTRL + a

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

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

CTRL + v

4. To undo this operation, press +

Keyboard Shortcuts for Moving active Cell

Select cell B2.

Moving Example

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

CTRL + down

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

CTRL + right

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

Selecting

Select cell A1.

- Advertisement -

Selecting Example

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

Shift + Down

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

Shift + Right

Formulas

Select cell F2.

Formulas Example

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

ALT

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

Shift + Down1

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

CTRL + d

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

See also  Excel Example - Skip Blanks in Excel

Formatting

Select the range B2:F7.

Formatting Example

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

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

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

Format Cells dialog box

4. Press

Result:

Format Cells dialog box result

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

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.

Download this file for some useful Excel Shortcut Keys

Next Chapter: Print

LEAVE A REPLY

Please enter your comment!
Please enter your name here

Stay in Touch

Stay in touch to boost your skills in Excel, HTML, and JavaScript! Get tips, tutorials, and practical examples to make your learning journey efficient, fun, and highly rewarding.

Related Articles