Computer Plus Logo
Quick Clicks Panel
Home Services Links Ask Us Contact Internet Tips Word Tips Excel Tips Power Point Tips Publisher Tips

The menu has downgraded. It is at the bottom of this page.

 

Excel Shortcuts

Here is a list of helpful shortcuts for Excel. The more you use them, the easier it gets.

File Shortcuts

New (Ctrl+N) - Opens a New Document
Close (Ctrl+W) - Closes the document
Open (Ctrl+O) - Opens a Saved Document
Save (Ctrl+S) - Saves a Document
Save As (F12) - Brings up the 'Save As' box
Print (Ctrl+P) - Prints the Document

Editing Shortcuts

Undo (Ctrl+Z) - Undoes your last action
Repeat (Ctrl+Y) - Repeats your last action
Cut (Ctrl+X) - Cuts selected text / object (so it can be moved)
Copy (Ctrl+C) - Copies text / object to clipboard
Paste (Ctrl+V) - Pastes whatever is on clipboard into document
Paste Formula(Ctrl+Shift+") - Pastes formula from cell above into current cell
Select All (Ctrl+C) - Selects everything in the document
Find (Ctrl+F) - Finds a word or phrase
Replace (Ctrl+G) - Use this to replace one word with another word

Formatting Shortcuts

Bold (Ctrl+B) - Bolds selected text
Italics (Ctrl+I) - Italicises selected text
Underline (Ctrl+U) - Underlines selected text
Font Size (Ctrl+Shift+P) - Changes font size
Font Style (Ctrl+Shift+F) - Changes font

Try These !
(Originally seen on Lockergnome)
Currency Style - (Ctrl+Shift+$)
Percentage Style - (Ctrl+Shift+%)
Exponent Style - (Ctrl+Shift+^)
Comma / Decimal Style - (Ctrl+Shift+!)

Draw Border - (Ctrl+Shift+&)
Remove Border - (Ctrl+Shift+_)
Select Current Region - (Ctrl+Shift+*)

Autosum - (Ctrl+Alt+=)

Tools Shortcuts

Spellcheck (F7) - Checks the spelling in a document

Moving and Selecting

Left to Right (Tab)
Right to Left (Shift+Tab)
Down (Enter)
Up (Shift+Enter)
To cell A1 (Ctrl+PgUp)
End of Data (Ctrl+PgDn)
End of Row (Ctrl+Right Arrow)
Start of Row (Ctrl+Left Arrow)
End of Column (Ctrl+Down Arrow)
Start of Column (Ctrl+Up Arrow)