Excel Short Keys Command Keystroke Absolute/relative/mixed reference F4 Auto Sum Alt = Bold Ctrl-B Border lines off Ctrl-Shift _ Border lines on Ctrl-Shift & 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 Date Ctrl ; Delete range Ctrl - Delete to end of line Ctrl-Del Show values/formulas Ctrl ` Edit cell F2 Enter formula as array Ctrl-Shift-Enter 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 @ Formula = Function Wizard Shift-F3 GoTo Ctrl-G Group row/column Alt-Shift-Right Hard Return in cell Alt-Enter Hide selected column(s) Ctrl-0 (zero) Hide selected row(s) Ctrl-9 Insert chart sheet F11 Insert Function components Ctrl-Shift-A Insert range Ctrl-Shift-Plus Insert worksheet Shift-F11 Italics Ctrl-I 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 worksheet Ctrl-End Move up through a selection Shift-Enter 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 Open Ctrl-O Outline symbols display/hide Ctrl-8 Paste Ctrl-V Paste named range (Insert/Name/Paste) F3 Previous window Ctrl-Shift-F6 Previous worksheet Ctrl-PgDn Print Ctrl-P Repeat Find Shift-F4 Repeat/Redo Ctrl-Y Replace Ctrl-H Save Ctrl-S Save As F12 Scroll to display active cell Ctrl-Backspace Select array to which active cell belongs 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 worksheet Ctrl-Shift-End Select worksheet Ctrl-A Shortcut menu Shift-F10 Spelling and Grammar check F7 Strikethrough on/off Ctrl-5 Tab inserted Ctrl-Alt-Tab Time Ctrl-Shift-Colon Underline Ctrl-U Undo Ctrl-Z Ungroup row/column Alt-Shift-Left Unhide column(s) Ctrl-Shift ) Unhide row(s) Ctrl-Shift (
Posted on: Fri, 08 Nov 2013 13:48:13 +0000
Trending Topics
Recently Viewed Topics
© 2015