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 |
>
>
dummies
Source:http://www.dummies.com/how-to/content/excel-2003-allinone-for-dummies-cheat-sheet.html
No comments:
Post a Comment