Common Keyboard Shortcuts for Excel

Document Sample
Common Keyboard Shortcuts for Excel Powered By Docstoc
					Common Keyboard Shortcuts for Excel
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

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:30
posted:9/15/2012
language:English
pages:2