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 All-in-One For Dummies

Excel 2003 offers a multitude of options — along with keyboard shortcuts — to create glorious spreadsheets (or worksheets, in Excel-ese). Whatever you use Excel 2003 for, you can move around and through the software quickly and easily with a wide range of keyboard shortcuts.

Keyboard Shortcuts for Excel 2003 Worksheets

Excel 2003 — any version of Excel, actually — is about creating spreadsheets (worksheets) contained in workbooks. To navigate around worksheets and workbooks in Excel 2003, use these keyboard shortcuts:

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)

Keyboard Shortcuts for Moving within an Excel 2003 Worksheet

You’re moving cell-by-cell through an Excel 2003 worksheet, thinking "I wish there was a shortcut." Your wish is granted! Excel 2003 keyboard shortcuts make quick work of your spreadsheet.

Press To
An arrow key Move cell pointer one cell in direction of arrow key
Ctrl+arrow key Move to the edge of the current data region (data range bounded by empty cells or worksheet borders) in the direction of arrow key
Home Move to the beginning of current row
Ctrl+Home Move to cell pointer to first cell (A1)
Ctrl+End -Move cell pointer to last cell in the active area (cell in last occupied column and row)
Page Down Move cell pointer down one screen
Page Up Move cell pointer up one screen
Alt+Page Down Move cell pointer one screen to the right
Alt+Page Up Move cell pointer one screen to the left
Tab Move the cell pointer to next unlocked cell in a protected worksheet
Shift+Tab Move the cell pointer to previous unlocked cell in a protected worksheet

Keyboard Shortcuts for Entering Data in Excel 2003

Filling in all those empty Excel 2003 cells may seem daunting, but keyboard shortcuts ease the pain. Use these Excel 2003 keyboard shortcuts to enter data quickly. You'll find Excel a much more enjoyable, and a lot less fatiguing, experience.

Press To
An arrow key Complete cell entry and move cell pointer one cell in direction of the arrow
Enter Complete cell entry and move cell pointer down one row
Shift+Enter Complete cell entry and move cell pointer up one row
Ctrl+Enter Complete cell entry in all cells in selected range
Alt+Enter Begin a new line in a cell entry
Tab Complete cell entry and move cell pointer right one column
Shift+Tab Complete cell entry and move cell pointer left one column
Esc Cancel current cell entry
Ctrl+’ (apostrophe) Copy formula in cell above into current cell entry
Ctrl+Shift+” (quotation) Copy value from formula in cell above into current cell entry
Ctrl+` (accent) Toggle between displaying cell values and cell formulas in worksheet
Ctrl+; Insert current date into current cell entry
Ctrl+Shift+; Insert current time into current cell entry

Keyboard Shortcuts for Editing Cells in Excel 2003

Editing information within a cell in Excel 2003 can get confusing without some guidance. Excel 2003 has plenty of keyboard shortcuts to make editing cells a breeze:

Press To
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
blog comments powered by Disqus
Advertisement

Inside Dummies.com

Dummies.com Sweepstakes

Win $500. Easy.