Skip to content

Basic Spreadsheet Keyboard Shortcuts

One of the best ways to improve your spreadsheet development efficiency is to use keyboard shortcuts. Keyboard shortcuts allow you to perform actions with your keyboard instead of your mouse to increase your speed.

This article will cover twelve basic keyboard shortcuts that you can start using today!

CTRL + a

This keyboard shortcut selects an entire range of cells that contain data.

 

If you press CTRL + a once more, you will select all cells in the worksheet.

CTRL + c

This keyboard shortcut copies all selected cells.

CTRL + v

This keyboard shortcut will paste the copied cells.

CTRL + z

This keyboard shortcut undoes any previous action. It is the equivalent of pressing the undo button.

CTRL + arrow key

If you hold CTRL and press one of the arrow keys, you will quickly navigate to the end of a range of cells that contain data.

For example, using CTRL + down arrow key will cause the selection to jump to the end of the range.

 

Similarly, using CTRL + right arrow key will cause the selection to jump to the right edge of the range.

SHIFT + arrow key

If you hold SHIFT and press one of the arrow keys, you will expand the selection in the direction of the arrow key.

For instance, using SHIFT + down arrow key will cause the selection to expand down.

 

Similarly, using SHFIT + right arrow key will cause the selection to expand to the right.

CTRL + SHIFT + arrow key

You can combine the previous two shortcuts by holding CTRL and SHIFT simultaneously. This will allow you to select all cells in a range containing data.

For example, if you use CTRL + SHIFT + down arrow key, you will select all cells in the first column of the range containing data.

CTRL + d

This keyboard shortcut fills a formula or value down a selected range.

For example, if you have a formula in E1, you can select cells E1 through E4 and then use CTRL + d. This will copy the formula down into the selected cells.

Note: The cell with the formula must be selected. Otherwise, Excel will not know what to copy down the selection.

CTRL + r

Similar to CTRL + d, this keyboard shortcut will copy a formula or value to the right instead of down.

 

CTRL + b

This keyboard shortcut will bold the selected cells.

CTRL + i

This keyboard shortcut will italicize the selected cells.

CTRL + s

This will save your spreadsheet file. Use this shortcut often to avoid accidentally losing your work.

Although these keyboard shortcuts are simple and perhaps trivial, they can go a long way in improving your spreadsheet development skill and effectiveness overall!

This Post Has One Comment

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Back To Top