Ctrl+Shift+Home Select from active cell to A1 Ctrl+Page Move Down to the next sheet, Ctrl+Page Move Up to the previous sheet Ctrl+Tab Move to next open workbook Ctrl+N Open new workbook Shift+F11 Insert new worksheet Shift+F3 Paste function window Err:508 Insert new function Alt+F11 Open VBE Ctrl+Shift+Enter Array formula Ctrl+F3, Define F3 name, Paste name Ctrl+Spacebar Select Shift+Spacebar columns, Select rows Ctrl+1, Format Ctrl+B, Ctrl+U cells, Bold, Underline Ctrl+ Current, Ctrl+shift+: date, Current time Absolute/relative/mixed reference AutoSum Bold Border lines off Border lines on Calculate active sheet Calculate all worksheets Close Collapse selection to active cell Comment insert/edit Copy Copy formula from cell above Copy value from cell above Cut Date Delete range Delete to end of line Show values/formulas Edit cell Enter formula as array Fill down Fill right Find Format commas (2 decimal places) Format currency (2 decimal places) Format date (day, month, year) Format exponential number (2 decimal places) Format general number Format percentage (0 decimal places) Format time (hour and minute) Formula Function Wizard GoTo Group row/column Hard Return in cell Hide selected column(s) Hide selected row(s) Insert chart sheet Insert Function components Insert range Insert worksheet Italics Menu bar Move between noncontiguous selections Move left/right one screen F4 Alt = Ctrl-B Ctrl-Shift _ Ctrl-Shift & Shift-F9 F9 Ctrl-W Shift-Backspace Shift-F2 Ctrl-C Ctrl ' Ctrl-Shift ' Ctrl-X Ctrl Ctrl Ctrl-Del Ctrl ` F2 Ctrl-Shift-Enter Ctrl-D Ctrl-R Ctrl-F Ctrl-Shift ! Ctrl-Shift $ Ctrl-Shift # Ctrl-Shift ^ Ctrl-Shift ~ Ctrl-Shift % Ctrl-Shift = Shift-F3 Ctrl-G Alt-Shift-Right Alt-Enter Ctrl-0 (zero) Ctrl-9 F11 Ctrl-Shift-A Ctrl-Shift-Plus Shift-F11 Ctrl-I F10 Ctrl-Alt-Left/Right Alt-PgUp/PgDn Move to beginning of worksheet Move to edge of region Move to end of row Move to end of worksheet Move to next corner of selection Move up through a selection Name a range (Insert/Name/Create) Name a range (Insert/Name/Define) New Next window Next worksheet Open Outline symbols display/hide Paste Paste named range (Insert/Name/Paste) Previous window Previous worksheet Print Repeat Find Repeat/Redo Replace Save Save As Scroll to display active cell Select array to which active cell belongs Select cells directly referred to by selected formula Select cells referred to by selected formula Select cells with comments Select column Select current region Select formulas that directly refer to active cell Select formulas that refer to active cell Select objects on worksheet Select row Select to beginning of row Select to beginning of worksheet Select to edge of region Select to end of row Select to end of worksheet Select visible cells in selection Select worksheet Shortcut menu Spelling and Grammar check Ctrl-Home Ctrl-Arrow End, Enter Ctrl-End Ctrl. Ctrl+Z Undo Ctrl+C Copy, Enter, Paste, Ctrl+V Multiple Paste, Ctrl+X Cut Ctrl+F, Find, Ctrl+H Find&Replace Ctrl+P, Print, Ctrl+S, Ctrl+F4, Alt+F4 Save, Close, Close Excel Ctrl+Arrow Move to edge of region Ctrl+* Select current region Ctrl+A Select all cells Ctrl+Home Select Ctrl+End A1, Select last cell in used range Ctrl+Shift+End Select from active cell to last cell in used range. Ctrl + Arrow key Ctrl + Space Move to next section of text. Createthe a formula sum all ofcell theinto above Insert value oftothe above cellcells currently selected. Move between Two or more open Excel files. Move between Excel work sheets in the same Excel document. Switch betweenExcel openwork workbooks Move between sheets/inwindows.

Bring up the print dialog box to begin printing. Spell check selected text and/or document. Shortcut Keys F2 F5 F7 F11 Ctrl + Shift + Ctrl + Alt + Shift + F1 Shift + F3 Shift + F5 Ctrl + A Ctrl + B Ctrl + I Ctrl + K Ctrl + U Ctrl + 5 Ctrl + P Ctrl + Z Ctrl + F9 Ctrl + F10 Ctrl + F6 Ctrl + Page up Ctrl + Page down Ctrl + Tab Alt + = Ctrl + ' Ctrl + Shift + ! Ctrl + Shift + $ Ctrl + Shift + # Ctrl + Shift + % Ctrl + Shift + ^ Ctrl + Shift + Description Edit the selected cell.

Microsoft excel shortcut keys pdf