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