Common Keyboard Shortcuts for Excel

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

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

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

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

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

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

Underline
• 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
• Press CTRL+SPACEBAR
• Note Active cell must be in the column you wish to select

Select Row
• Press SHIFT +SPACEBAR
• 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

Print
• 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




This site needs an editor - click to learn more!


You Should Also Read:
Using Named Ranges (Excel)
Controlling Pagination - Excel
Eight Ways to Add Numbers in Excel

RSS
Related Articles
Editor's Picks Articles
Top Ten Articles
Previous Features
Site Map





Content copyright © 2023 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 BellaOnline Administration for details.