Guest Author - Chris Curtis
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 Words 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
