Scribd Logo
Upload

Welcome to Scribd!

  • 28 views

    Top 60 Keyboard Shortcuts For Excel

    Uploaded by

    Vardan
    The document lists 60 useful Excel shortcut keys that can help speed up work in Excel. Some of the keys listed allow users to select cells, copy and paste data, format text, save files, and navigate between sheets. Mastering these shortcut keys can help improve efficiency when using Excel.

    Copyright:

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

    Top 60 Keyboard Shortcuts For Excel

    Uploaded by

    Vardan
    28 views2 pages
    The document lists 60 useful Excel shortcut keys that can help speed up work in Excel. Some of the keys listed allow users to select cells, copy and paste data, format text, save files, and navigate between sheets. Mastering these shortcut keys can help improve efficiency when using Excel.

    Original Description:

    Top 60 Keyboard Shortcuts for Excel

    Original Title

    Top 60 Keyboard Shortcuts for Excel

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document lists 60 useful Excel shortcut keys that can help speed up work in Excel. Some of the keys listed allow users to select cells, copy and paste data, format text, save files, and navigate between sheets. Mastering these shortcut keys can help improve efficiency when using Excel.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    28 views2 pages

    Top 60 Keyboard Shortcuts For Excel

    Uploaded by

    Vardan
    The document lists 60 useful Excel shortcut keys that can help speed up work in Excel. Some of the keys listed allow users to select cells, copy and paste data, format text, save files, and navigate between sheets. Mastering these shortcut keys can help improve efficiency when using Excel.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    You are on page 1of 2

    60 Useful Excel Shortcut Keys (Speed Up Your Excel Work)

    SN Key Combination Used for


    1 Ctrl + A Select Whole Worksheet
    2 Ctrl + B Make the Font Style Bold
    3 Ctrl + C Copy The Selection
    4 Ctrl + D Fill to Down
    5 Ctrl + E Flash Fill (Auto Sense Previous Pattern and Repeat)
    6 Ctrl + F Open Find and Replace Dialog Box
    7 Ctrl + G Open Go to Dialog Box
    8 Ctrl + H Open Replace Dialog Box
    9 Ctrl + I Make the Font Style Italic
    10 Ctrl + K Insert Hyperlink
    11 Ctrl + L Launch Insert Table Dialog Box
    12 Ctrl + N Open a new Workbook
    13 Ctrl + O Open existing Workbook
    14 Ctrl + P Open Print Window
    15 Ctrl + Q Opens Quick Analysis Tool
    16 Ctrl + R Fill to Right
    17 Ctrl + S Save the Workbook File
    18 Ctrl + T Launch Create Table Dialog Box
    19 Ctrl + U Underline the Text or Value
    20 Ctrl + V Duplicate or Move the Copied or Cut field to Another Place
    21 Ctrl + W Close the Active Workbook
    22 Ctrl + X Cut The Selection
    23 Ctrl + Y Redo the last change
    24 Ctrl + Z Undo The last change
    25 Ctrl + 1 Open Format Cell Dialog Box
    26 Ctrl + 2 Make the Font Style Bold
    27 Ctrl + 3 Make the Font Style Italic
    28 Ctrl + 4 Underline the Text
    29 Ctrl + 5 Strikethrough the Text
    30 Ctrl + 9 Hide Selected Cell's Row
    31 Ctrl + 0 Hide the Selected Cell's Column
    32 Ctrl + ; Insert Current Data (Today's Date)
    33 Ctrl + ' Insert the formula of above cell without changing cell reference
    34 Ctrl + F1 Show/Hide Excel Ribbon
    35 Ctrl + F2 Take the Cursor to Formula Bar
    36 Ctrl + F3 Open Name Manager
    37 Ctrl + F4 Close the Workbook
    38 Ctrl + F5 Restore Down The Workbook
    39 Ctrl + F9 Minimize The Workbook
    40 Ctrl + - Delete Selected Rows, Columns
    41 Shift + Space Key Selects entire Row
    42 Ctrl + Space Key Selects entire column
    43 Ctrl + Shift + Down Arrow Select Data Downward
    44 Ctrl + Shift + Up Arrow Select Data Upward
    45 Ctrl + Shift + Right Arrow Select Data to Right
    46 Ctrl + Shift + Left Arrow Select Data to left
    47 Ctrl + Up Arrow Go to First Record
    48 Ctrl + Down Arrow Go To Last Record
    49 Ctrl + Left Arrow Go To Last Column Data to Left
    50 Ctrl + Right Arrow Go To First Column Data to Right
    51 Ctrl+PgUP Select the Sheet of Left
    52 Ctrl + PgDn Select the Sheet of Right
    53 Shift + Left Click Selects the Range (Active to Clicked) for Sheets as Well
    54 F2 Edit the Current Cell
    55 F3 Bring Defined Name and Formulas to Cell
    Repeat the Last Actions and In Formula editing mode, swithces to absolute, relative
    56 F4
    and mixed reference
    57 F6 Goes to Sheets, Tabs, Namebox Selection
    58 F12 Open Save As Dialog Box
    59 Alt Key Assigns Shortcut Keys to All Tabs and Menus
    60 Alt + = Add the SUM Function Quickly

    You might also like