Online Test Banks
Score higher
See Online Test Banks
eLearning
Learning anything is easy
Browse Online Courses
Mobile Apps
Learning on the go
Explore Mobile Apps
Dummies Store
Shop for books and more
Start Shopping

Cheat Sheet

Excel 2003 for Dummies

From Excel 2003 For Dummies by Greg Harvey

Running Excel 2003 is easier when you know the shortcut keys to manage your worksheets and cell entries. The Speech Recognition feature in Excel 2003 lets you enter data, like symbols and punctuation, by dictating specific words and phrases.

Shortcut Keys for Manipulating Worksheets in Excel 2003

Learning keyboard shortcuts will make operating your worksheets easier in Excel 2003. Here are some shortcut keys to basic commands in your Excel worksheets:

Press To
Ctrl+Page Down Activate next sheet in the workbook
Ctrl+Page Up Activate previous sheet in the workbook
Shift+Ctrl+Page Down Select current and next sheet in workbook
Shift+Ctrl+Page Up Select current and previous sheet in workbook
Shift+F11 or Alt+Shift+F1 Insert new sheet in workbook
Alt+OHR Rename current sheet (Format→Sheet→Rename
Alt+OHH Hide current sheet (Format→Sheet→Hide)
Alt+OHU Unhide current sheet (Format→Sheet→Unhide)
Alt+OHT Select new color for sheet tab (Format→Sheet→Tab Color)
Alt+EM Move or copy current sheet in workbook or to new workbook (Edit→Move or Copy Sheet)
Alt+ED Delete current sheet (Edit→Delete)

Shortcut Keys for Editing and Formatting Cell Entries in Excel 2003

Each one of those little squares on a worksheet in Excel 2003 is called a cell and it holds important information. Here are some keyboard shortcut keys that help you organize and correct your cell entries:

Press To
Ctrl+1 Display Format Cells dialog box
Alt+’ (apostrophe) Display Style dialog box
Ctrl+Shift+~ (tilde) Apply General number format
Ctrl+Shift+$ Apply Currency number format with two decimal places and negative numbers in parentheses
Ctrl+Shift+% Apply Percent number format with no decimal places
Ctrl+Shift+# Apply Date number format with day, month, and year as in 15-Feb-05
Ctrl+Shift+@ Apply Time number format with hour and minute and AM/PM as in 12:05 PM
Ctrl+Shift+! Apply Comma number format with two decimal places
Ctrl+B Add or remove bold
Ctrl+I Add or remove italics
Ctrl+U Add or remove underlining
Ctrl+5 Add or remove strikethrough
Ctrl+Shift+& Apply outline border to current range
Ctrl+Shift+_ (underline) Remove outline border from current range
Ctrl+F1 Open and close the Task pane at the right side of the workbook document window
F2 Edit current cell entry and position insertion point at the end of cell contents
Shift+F2 Edit comment attached to current cell and position insertion point in comment box
Backspace Delete character to left of insertion point when editing cell entry
Delete Delete character to right of insertion point when editing cell entry: otherwise, clear cell entries in current range
Esc Cancel editing in current cell entry
Enter Complete editing in current cell entry
Ctrl+CC Open Clipboard Task pane
Ctrl+C Copy cell selection to Clipboard
Ctrl+X Cut cell selection to Clipboard
Ctrl+V Paste last copied or cut cells from Clipboard
Ctrl+hyphen (-) Open Delete dialog box to delete cell selection and shift remaining cells left or up
Ctrl+Shift+plus (+) Open Insert dialog box to insert new cells and shift existing cells right or down
Ctrl+Z Undo last action
Ctrl+Y Redo last action

Dictating to Excel: What to Say for Common Punctuation

The Speech Recognition feature in Excel 2003 dictates a word or phrase you speak into your PC's microphone for common punctuation and symbols. Here are the words to say and what Speech Recognition executes:

Word(s) You Say What Speech Recognition Enters
Ampersand &
Asterisk *
At sign @
Backslash \
Close paren )
Close quote
Colon :
Comma ,
Dash -
Dollar sign $
Dot .
Ellipsis . . .
End quote
Equals =
Exclamation point !
Greater than >
Hyphen -
Less than <
Open paren (
Open quote
Percent sign %
Period .
Plus sign +
Question mark ?
Quote
Semi-colon ;
Single quote
Slash /
blog comments powered by Disqus
Advertisement

Inside Dummies.com

Dummies.com Sweepstakes

Win $500. Easy.