Printer Friendly Version

BellaOnline's Desktop Publishing / Ebooks Editor

Common Keyboard Shortcuts for Excel

If you become practiced at using keyboard shortcuts, you will find that your proficiency in Excel will improve and your work will be accomplished more quickly. These keyboard techniques are called shortcuts because they take less time to execute a command then using the mouse to click on an icon or selecting a menu command. One way to make using shortcuts a habit is to start by selecting one or two commands that you use frequently and instead of reaching for the mouse, use the short cut instead. Once those have become a habit, select a couple more.

Open a New Document
• Press CTRL+N

Open an existing document
• Press CTRL+O – Launches Word’s Open Dialog Box Default Folder (usually My Documents)

Close a document
• Press CTRL+W

Save a document
• Press CTRL+S

• Select cell or range of cells or object to be copied.
• Press CTRL+C

• Select cell or range of cells or object to be cut.
• Press CTRL+X

• Activate cell where copied or cut text is to be placed.
• Press CTRL+V

• Select range of cells to make bold.
• Press CTRL+B

• Select range of cells to make italicized.
• Press CTRL+I

• Select range of cells to make underlined.
• Press CTRL+U

Open the Go To Dialog Box
• Press F5

Open the Go To Dialog Box
• Press CTRL + G

Open the Find Dialog Box
• Press CTRL + F

Open the Replace Dialog Box
• Press CTRL + H

Select Column
• Note Active cell must be in the column you wish to select

Select Row
• Note Active cell must be in the row you want to select

Select Range of Cells
• Activate the 1st cell in the range where you want to begin the selection
• Hold the shift key down
• Click in the last cell of the range selection (lower right hand corner)

Select All (entire document)
• Press CTRL+A

Undo the last action
• Press CTRL+Z

Redo the last action
• Press CTRL+Y

• Press CTRL+P

Print Preview
• Press Alt+F
• Press V

Create a Bar Chart
• Select range of data to be charted
• Press F11

Go to beginning of the row
• Press Home

Go to Cell A1
• Press CTRL + Home

Desktop Publishing / Ebooks Site @ BellaOnline
View This Article in Regular Layout

Content copyright © 2013 by Chris Curtis. All rights reserved.
This content was written by Chris Curtis. If you wish to use this content in any manner, you need written permission. Contact Laura Nunn for details.

| About BellaOnline | Privacy Policy | Advertising | Become an Editor |
Website copyright © 2016 Minerva WebWorks LLC. All rights reserved.

BellaOnline Editor