Nothing Special   »   [go: up one dir, main page]
Scribd Logo
Upload

Welcome to Scribd!

  • 32 views

    Excel Shortcuts: S.No Shortcut Key Action

    Uploaded by

    Rajesh Arani
    The document lists 75 Excel keyboard shortcuts organized by number. Some of the most common shortcuts include: - Ctrl+A to select all - Ctrl+C to copy - Ctrl+V to paste - Ctrl+S to save - Ctrl+Z to undo - F2 to edit a cell - F4 to fill down - F5 to activate the Go To dialog box - F9 to recalculate all open workbooks

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as XLSX, PDF, TXT or read online from Scribd

    Excel Shortcuts: S.No Shortcut Key Action

    Uploaded by

    Rajesh Arani
    32 views2 pages
    The document lists 75 Excel keyboard shortcuts organized by number. Some of the most common shortcuts include: - Ctrl+A to select all - Ctrl+C to copy - Ctrl+V to paste - Ctrl+S to save - Ctrl+Z to undo - F2 to edit a cell - F4 to fill down - F5 to activate the Go To dialog box - F9 to recalculate all open workbooks

    Original Description:

    excel

    Original Title

    All Shortcuts

    Copyright

    © Attribution Non-Commercial (BY-NC)

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document lists 75 Excel keyboard shortcuts organized by number. Some of the most common shortcuts include: - Ctrl+A to select all - Ctrl+C to copy - Ctrl+V to paste - Ctrl+S to save - Ctrl+Z to undo - F2 to edit a cell - F4 to fill down - F5 to activate the Go To dialog box - F9 to recalculate all open workbooks

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    32 views2 pages

    Excel Shortcuts: S.No Shortcut Key Action

    Uploaded by

    Rajesh Arani
    The document lists 75 Excel keyboard shortcuts organized by number. Some of the most common shortcuts include: - Ctrl+A to select all - Ctrl+C to copy - Ctrl+V to paste - Ctrl+S to save - Ctrl+Z to undo - F2 to edit a cell - F4 to fill down - F5 to activate the Go To dialog box - F9 to recalculate all open workbooks

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    of 2

    Excel shortcuts

    S.No 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 Shortcut key Ctrl+A Ctrl+B Ctrl+C Ctrl+D Ctrl+F Ctrl+G Ctrl+H Ctrl+I Ctrl+K Ctrl+N Ctrl+O Ctrl+P Ctrl+R Ctrl+S Ctrl+U Ctrl+V Ctrl W Ctrl+X Ctrl+Y Ctrl+Z F1 F2 F3 F4 F4 Action Select All Bold Copy Fill Down Find Goto Replace Italic Insert Hyperlink New Workbook Open Print Fill Right Save Underline Paste Close Cut Repeat Undo Help Edit Paste Name Repeat last action

    26 27 28 29 30 31 32 33 34 35 36 37

    While typing a formula, switch between absolute/relative refs Goto F5 Next Pane F6 Spell check F7 Extend mode F8 Recalculate all F9 workbooks Activate Menubar F10 New Chart F11 Save As F12 Ctrl+SpaceSelect bar entire column Select Shift+Space bar entire row Insert Current Ctrl+: Time Insert Current Ctrl+; Date

    38 39 40 41

    42 43 44 45 46 47 48 49

    Copy Value from Cell Above Copy Formula Ctrl+ from Cell Above AutoSum Alt+= Toggle Ctrl+` Value/Formula display General format Ctrl+Shift+~ Comma format Ctrl+Shift+! Time format Ctrl+Shift+@ Date format Ctrl+Shift+# Currency format Ctrl+Shift+$ Percent format Ctrl+Shift+% Exponential format Ctrl+Shift+^ Ctrl+" Place outline Ctrl+Shift+& border around selected cells Remove outline Ctrl+Shift+_ border Select current Ctrl+Shift+* region Insert Ctrl++ Delete Ctrl+Format cells dialog Ctrl+1 box Bold Ctrl+2 Italic Ctrl+3 Underline Ctrl+4 Strikethrough Ctrl+5 Show/Hide objects Ctrl+6 Show/Hide Standard toolbar Toggle Outline Ctrl+8 symbols Hide rows Ctrl+9 Hide columns Ctrl+0 Unhide rows Ctrl+Shift+( Unhide columns Ctrl+Shift+) Ctrl+Tab In toolbar: next toolbar Shift+Tab Previous tool Alt E A A Clear All Alt E A C Clear Contents Alt E A F Clear Formats Alt O C A Autofit to contents Ctrl+7 Alt D F F Autofilter

    50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72

    You might also like