Scribd Logo
Upload

Welcome to Scribd!

  • 526 views

    MS Excel Basic Shortcut Keys

    Uploaded by

    Meetu Saini
    This document provides a summary of the most common Excel shortcut keys for Windows. It includes shortcuts for file operations like creating, opening, saving and printing workbooks. It also lists shortcuts for formatting text like making it bold, italic or underline. Keyboard shortcuts for copying, cutting, pasting and undo/redo are described. Navigation shortcuts like moving between sheets and selecting entire rows or columns are outlined.

    Copyright:

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

    MS Excel Basic Shortcut Keys

    Uploaded by

    Meetu Saini
    526 views7 pages
    This document provides a summary of the most common Excel shortcut keys for Windows. It includes shortcuts for file operations like creating, opening, saving and printing workbooks. It also lists shortcuts for formatting text like making it bold, italic or underline. Keyboard shortcuts for copying, cutting, pasting and undo/redo are described. Navigation shortcuts like moving between sheets and selecting entire rows or columns are outlined.

    Original Title

    MS EXCEL BASIC SHORTCUT KEYS.pptx

    Copyright

    © © All Rights Reserved

    Available Formats

    PPTX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document provides a summary of the most common Excel shortcut keys for Windows. It includes shortcuts for file operations like creating, opening, saving and printing workbooks. It also lists shortcuts for formatting text like making it bold, italic or underline. Keyboard shortcuts for copying, cutting, pasting and undo/redo are described. Navigation shortcuts like moving between sheets and selecting entire rows or columns are outlined.

    Copyright:

    © All Rights Reserved
    Download as PPTX, PDF, TXT or read online from Scribd
    Download as pptx, pdf, or txt
    526 views7 pages

    MS Excel Basic Shortcut Keys

    Uploaded by

    Meetu Saini
    This document provides a summary of the most common Excel shortcut keys for Windows. It includes shortcuts for file operations like creating, opening, saving and printing workbooks. It also lists shortcuts for formatting text like making it bold, italic or underline. Keyboard shortcuts for copying, cutting, pasting and undo/redo are described. Navigation shortcuts like moving between sheets and selecting entire rows or columns are outlined.

    Copyright:

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

    MS EXCEL

    SHORTCUT KEYS
    MOST USED EXCEL SHORTCUTS FOR WINDOWS
    File Shortcuts
     All the workbook or file related shortcuts are as follows:

    SHORTCUT KEYS DESCRIPTION


    Ctrl + N New Workbook
    Ctrl + O Open Workbook
    Ctrl + S Save Workbook
    F12 Save As
    Ctrl + P Print File
    Ctrl + F2 Open Print Preview
    Ctrl + F4 Close Workbook
    Alt + F4 Close Excel
    Ctrl + F1 Expand or Close Ribbon
    Alt Activate Access Keys
    Tab Move to next control on ribbbon
    F1 Help
    Excel Workbook Shortcuts
    All list of Workbook related shortcuts are as follows:
    CTRL + ALPHABET SHORTCUT KEYS
    CTRL+ALPHABET SHORTCUT KEY
    SHORT CUT KEY DESCRIPTION
    Ctrl + V Paste
    Ctrl + A Select all
    Ctrl + I Italic
    Ctrl + C Copy
    Ctrl + K Insert Link
    Ctrl + B Bold
    Ctrl + X Cut
    Ctrl + S Save
    Ctrl + U Underline
    Ctrl + P Print
    Ctrl + R Paste without copy left to right
    Ctrl + D Paste without copy up to down
    Ctrl + Y Redo
    Ctrl + Z Undo
    Ctrl + H Replace the data
    Ctrl + F Find the data
    Excel Workbook Shortcuts
     CTRL + NUMBER SHORTCUT KEYS, ALT SHIFT AND OTHER KEYS COMBINATION
    SHORTCUTS
    CTRL+NUMBER SHORTCUT KEYS
    SHORT CUT KEY DESCRIPTION
    Ctrl+9 Hide entire row
    Ctrl+5 Strike
    Ctrl+4 Underline
    Ctrl+3 Italic
    Ctrl+2 Bold
    Ctrl+1 Open the format cells window
    Ctrl+0 Hide entire column
       
    ALT SHIFT OTHER KEYS COMBINATION SHORTCUT
    SHORT CUT KEY DESCRIPTION
    Shift + Space bar Select entire row
    Shift + F11 Insert new worksheet
    Alt + Shift + F1 Insert new worksheet
    Shift + F5 Search Box
    Alt + F4 Close Worksheet
    Alt + Space Bar + X Maximize
    Alt + Space Bar + c Close workbook
    Alt + = Create a formula to sum all of the above cells
    Alt + A + T Auto Filter apply
    Excel Workbook Shortcuts
     CTRL + OTHER KEY SHORTCUT
    CTRL+OTHER KEY SHORTCUT
    SHORT CUT KEY DESCRIPTION
    Ctrl + ; Enter the current date
    Ctrl + Shift + ; Enter the current time
    Ctrl + Space Bar Select the entire coloumn
    Ctrl + F3 Open name manager
    Ctrl + F9 Minimize Current window
    Ctrl + F6 Switch between open workbooks or windows
    Ctrl + F10 Maximize selected window
    Ctrl + ' Would show formulated cells
    Ctrl + PageDown Move between Excel worksheet(Left to right ) in the same Excel workbook
    Ctrl + PageUp Move between Excel worksheet(Right to Left) in the same Excel workbook
    Ctrl + Shift + # Format number in date format
    Ctrl + Shift + $ Format number in currency format
    Ctrl + Shift + ! Format number in comma format
    Excel Workbook Shortcuts
    Generalized Shortcuts
     Generalized shortcuts can be used in any Program and hence the name. It includes the basic
    copy, cut and paste. It also includes the shortcuts of undo and redo.

    Function Keys Shortcut

    FUNCTION KEYS SHORTCUT


    SHORT CUT
    KEY DESCRIPTION
    F12 Save As
    F11 Create chart for selected data
    F10 Menu shortcut keys enable
    F7 Spell check
    F5 Go to a specific cell
    F4 Repeat the last action
    F3 After a name has been created, F3 will paste names
    F2 Edit cell
    F1 Excel help

    You might also like