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 |
dummies
Source:http://www.dummies.com/how-to/content/shortcut-keys-for-editing-and-formatting-cell-entr.html
No comments:
Post a Comment