Discription Keystroke
| A Absolute/relative/mixed reference | F4 |
| AutoSum | Alt = |
|
B Bold | Ctrl-B |
| Border lines off | Ctrl-Shift _ |
| Border lines on | Ctrl-Shift & |
|
C Calculate active sheet | Shift-F9 |
| Calculate all worksheets | F9 |
| Close | Ctrl-W |
| Collapse selection to active cell | Shift-Backspace |
| Comment insert/edit | Shift-F2 |
| Copy | Ctrl-C |
| Copy formula from cell above | Ctrl ‘ |
| Copy value from cell above | Ctrl-Shift “ |
| Cut | Ctrl-X |
|
D Date | Ctrl ; |
| Delete range | Ctrl - |
| Delete to end of line | Ctrl-Del |
| Show values/formulas | Ctrl ` |
|
E Edit cell | F2 |
| Enter formula as array | Ctrl-Shift-Enter |
|
F Fill down | Ctrl-D |
| Fill right | Ctrl-R |
| Find | Ctrl-F |
| Format commas (2 decimal places) | Ctrl-Shift ! |
| Format currency (2 decimal places) | Ctrl-Shift $ |
| Format date (day, month, year) | Ctrl-Shift # |
| Format exponential number (2 decimal places) | Ctrl-Shift ^ |
| Format general number | Ctrl-Shift ~ |
| Format percentage (0 decimal places) | Ctrl-Shift % |
| Format time (hour and minute) | Ctrl-Shift @ |
|
|
|
|
| |
| GoTo | Ctrl-G |
| Group row/column | Alt-Shift-Right |
|
H Hard Return in cell | Alt-Enter |
| Hide selected column(s) | Ctrl-0 (zero) |
| Hide selected row(s) | Ctrl-9 |
|
I Insert chart sheet | F11 |
| Insert Function components | Ctrl-Shift-A |
| Insert range | Ctrl-Shift-Plus |
| Insert worksheet | Shift-F11 |
| Italics | Ctrl-I |
|
M Menu bar | F10 |
| Move between noncontiguous selections | Ctrl-Alt-Left/Right |
| Move left/right one screen | Alt-PgUp/PgDn |
| Move to beginning of worksheet | Ctrl-Home |
| Move to edge of region | Ctrl-Arrow |
| Move to end of row | End, Enter |
| Move to end of worksheet | Ctrl-End |
| Move to next corner of selection | Ctrl . |
| Move up through a selection | Shift-Enter |
|
N Name a range (Insert/Name/Create) | Ctrl-Shift-F3 |
| Name a range (Insert/Name/Define) | Ctrl-F3 |
| New | Ctrl-N |
| Next window | Ctrl-F6 |
| Next worksheet | Ctrl-PgUp |
|
O Open | Ctrl-O |
| Outline symbols display/hide | Ctrl-8 |
|
P Paste | Ctrl-V |
| Paste named range (Insert/Name/Paste) | F3 |
| Previous window | Ctrl-Shift-F6 |
| Previous worksheet | Ctrl-PgDn |
| | Ctrl-P |
|
R Repeat Find | Shift-F4 |
| Repeat/Redo | Ctrl-Y |
| Replace | Ctrl-H |
|
S Save | Ctrl-S |
| Save As | F12 |
| Scroll to display active cell | Ctrl-Backspace |
| Select array to which active cell belongs | Ctrl / |
| Select cells directly referred to by selected formula | Ctrl [ |
| Select cells referred to by selected formula | Ctrl-Shift { |
| Select cells with comments | Ctrl-Shift ? |
| Select column | Ctrl-spacebar |
| Select current region | Ctrl-Shift * |
| Select formulas that directly refer to active cell | Ctrl ] |
| Select formulas that refer to active cell | Ctrl-Shift } |
| Select objects on worksheet | Ctrl-Shift-spacebar |
| Select row | Shift-spacebar |
| Select to beginning of row | Shift-Home |
| Select to beginning of worksheet | Ctrl-Shift-Home |
| Select to edge of region | Ctrl-Shift-(Arrow) |
| Select to end of row | End, Shift-Enter |
| Select to end of worksheet | Ctrl-Shift-End |
| Select visible cells in selection | Alt ; |
| Select worksheet | Ctrl-A |
| Shortcut menu | Shift-F10 |
| Spelling and Grammar check | F7 |
| Strikethrough on/off | Ctrl-5 |
| Style box | Alt ‘ |
|
T Tab inserted | Ctrl-Alt-Tab |
| Time | Ctrl-Shift-Colon |
|
U Underline | Ctrl-U |
| Undo | Ctrl-Z |
| Ungroup row/column | Alt-Shift-Left |
| Unhide column(s) | Ctrl-Shift ) |
| Unhide row(s) | Ctrl-Shift ( |
No comments:
Post a Comment