Scribd Logo
Upload

Welcome to Scribd!

  • 51 views

    Excel Keyboard Shortcuts For A PC v2

    Uploaded by

    ahmedmostafaibrahim22

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    Excel Keyboard Shortcuts For A PC v2

    Uploaded by

    ahmedmostafaibrahim22
    51 views1 page

    Original Title

    Excel Keyboard Shortcuts for a PC v2

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    51 views1 page

    Excel Keyboard Shortcuts For A PC v2

    Uploaded by

    ahmedmostafaibrahim22

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    of 1

    Excel Keyboard Shortcuts for a PC

    NAVIGATING SHORTCUTS
    Alt + Tab Toggle between programs Ctrl + End Move to the last cell on the
    worksheet
    Ctrl + Esc Show the Windows Start End (press and Move by one block of data
    menu release) + Arrow keys within a row or column
    Ctrl + Tab Toggle between open Excel Ctrl + Arrow keys Move by one block of data
    files within a row or column
    Ctrl+ PageUp Move between worksheets Ctrl + [ / Ctrl + ] Jump to precedent cells /
    (PageDown) within the active file Jump to dependent cells
    Shift + Ctrl + PageUp Toggle between open Excel F5 (GoTo) and then Return to the last cell visited
    (PageDown) files Enter
    Home Move to the beginning of the Ctrl + \ In a selected row, select the
    line cells that don’t match the
    formula in the active cell
    Ctrl + Home Move to the beginning of the
    worksheet

    FORMATTING SHORTCUTS EDITING SHORTCUTS


    Ctrl + 1 Format Cells command F2 Edit the active cell
    Ctrl + B Apply bold formatting Ctrl + C Copy
    Ctrl + I Apply italic formatting Ctrl + D Copy down
    Ctrl + U Underline cells Ctrl + F Find
    Ctrl + ; Enter the date Ctrl + G Go To
    Ctrl + Shift + ; Enter the time Ctrl + H Replace
    Ctrl + Shift + ! Apply the number format Ctrl + R Copyright
    Ctrl + Shift + # Apply the date format Ctrl + V Paste
    Ctrl + Shift + $ Apply the currency format Ctrl + X Cut
    Ctrl + Shift + % Apply the percent format Ctrl + Alt + V Paste Special
    Ctrl + Shift + & Apply an outline border Ctrl + Y Repeat the last action
    Ctrl + Shift + _ Remove an outline border Ctrl + Z Undo last action
    Ctrl + 0 Hide selected column(s) Alt + Enter Start new line in same cell
    Ctrl + Shift + 0 Unhide selected column(s) Alt + Down arrow Open a filter drop down box
    Ctrl + 9 Hide selected row(s) Ctrl + Delete Delete text to end of line
    Ctrl + Shift + 9 Unhide selected row(s) Ctrl + ‘ Copy formula from cell above
    Ctrl + ~ View cell formulas Ctrl + Shift + ‘ Copy value from cell above

    SELECTING CELLS MENU TIP


    Ctrl + A Select entire sheet You can select any menu command by pressing Alt
    Ctrl + Spacebar Select the column and then the underlined letter in the menu name.
    Shift + Select the row
    Spacebar
    Shift + Ctrl + K Group selected rows or columns
    Alt + Shift + Group (Ungroup) selected rows or
    Right (or left) columns
    arrow
    Shift + End + Extend the selection to the last
    Arrow keys non-blank cell in the same row or
    column

    You might also like