Skip to content
  • Home
  • Places To Visit
    • India
      • Andhra Pradesh
      • Bihar
      • Goa
      • Gujarat
      • Himachal Pradesh
      • Jammu and Kashmir
      • Karnataka
      • Kerala
      • Madhya Pradesh
      • Maharashtra
      • Orissa
      • Rajasthan
      • Tamil Nadu
      • Telangana
      • Uttar Pradesh
      • Uttarakhand
      • West Bengal
  • Recipes & Remedies
    • Recipes
      • Cakes
    • Remedies
  • Your Interests
    • Computer
    • General Knowledge
    • Mathematics
Menu
BigUses
  • Home
  • Places To Visit
    • India
      • Andhra Pradesh
      • Bihar
      • Goa
      • Gujarat
      • Himachal Pradesh
      • Jammu and Kashmir
      • Karnataka
      • Kerala
      • Madhya Pradesh
      • Maharashtra
      • Orissa
      • Rajasthan
      • Tamil Nadu
      • Telangana
      • Uttar Pradesh
      • Uttarakhand
      • West Bengal
  • Recipes & Remedies
    • Recipes
      • Cakes
    • Remedies
  • Your Interests
    • Computer
    • General Knowledge
    • Mathematics
Hit enter to search or esc to close
Home / Computer • Shortcut Keys • Your Interests / Shortcut keys for MS-Excel
Posted inComputer Shortcut Keys Your Interests

Shortcut keys for MS-Excel

list of mind blowing tricks for ms excel
Posted By BigUses Posted on November 13, 2019
2

Shortcut keys for MS-Excel-

Here is a list of mind blowing shortcut keys(tricks) of MS-Excel which will improve your work efficiency and performance and thus will make your task easier.

MS-Excel Shortcut Keys List :

  • F2 : For editing the selected cell.
  • F5 : To ask for specific cell. For example let say, C6.
  • F7 : For checking the spelling of selected text and/or document.
  • F11 : For creating chart in a new tab.
  • Ctrl + Shift + ; : To enter the current time.
  • Ctrl + ; : To enter the current date.
  • Alt + Shift + F1 : To insert a new worksheet.
  • Shift + F3 : To open the excel formula window.
  • Shift + F5/Ctrl + F : This bring up a search box.
  • Ctrl + A : This selects all contents of the worksheet.
  • Ctrl + B : To bold the highlighted selection.
  • Ctrl + I : To italic highlighted selection.
  • Ctrl + K : To insert a link.
  • Ctrl + U : To underline highlighted selection.
  • Ctrl + 5 : To strike through highlighted selection.
  • F2 : To edit the active cell.
  • F11 : For creating a chart.
  • Shift + F2 : For inserting cell comment.
  • Shift + F3 : For opening a function dialogue box.
  • Shift + F11 : For inserting a new worksheet.
  • Ctrl + F3 : For opening name manager dialogue box.
  • Alt + F11 : For opening visual basic editor.
  • Alt + F8 : For opening a macro dialogue box.
  • Ctrl + 0 : For hiding the selected columns.
  • Ctrl + Shift + 0 : To unhide the columns.
  • Ctrl + 9 : To hide the selected rows.
  • Ctrl + Shift + 9 : To unhide the rows.
  • Ctrl + Shift + O : For selecting all the cells with comment.
  • Ctrl + D : Down Fill.
  • Ctrl + R : Right Fill.
  • Alt + = : Enter sum function in cell.
  • Alt + 0128 : Euro symbol.
  • Alt + 0162 : Cent Symbol.
  • Alt + 0163 : Pound Symbol.
  • Alt + 0165 : Yen Symbol.
  • Alt + Enter : Enter new line in active cell.
  • Ctrl + ; : Current date.
  • Ctrl + Shift + ; : Current time.
  • Ctrl + ` : Show formula.
  • Ctrl + Spacebar : Select entire column.
  • Shift + Spacebar : Select entire row.
  • Ctrl + Shift + ! : Applies number format.
  • Ctrl + Shift + $ : Applies currency format.
  • Ctrl + Shift + % : Applies percentage format.
  • Ctrl + Shift + ^ : Applies exponential format.
  • Ctrl + Shift + ~ : Applies general number format.
  • Ctrl + Shift + @ : Applies time format.
  • Ctrl + Shift + # : Applies date format.
  • Ctrl + Shift + & : Applies outline border.
  • Ctrl + Shift + _ : Remove outline border.
Tags: 50 shortcut keys of ms excel 50+ mindblowing short tricks for ms excel advanced excel shortcuts Andhra Pradesh mein ghumne ki jagah användbara genvägstangenter för MS Excel excel shortcuts cheat sheet excel shortcuts formulas how to operate ms excel how to work on ms excel important shortcut keys of ms excel list of mind blowing shortcut tricks for ms excel list of useful shortcut keys of ms excel most useful shortcut keys for ms excel ms excel shortcut keys list ms excel有用的快捷鍵 MS Excel的快捷鍵 nützliche Tastenkombinationen für MS Excel shortcut keys for ms excel shortcuts for ms excel simple shortcut keys for ms excel teclas de acceso directo útiles para ms excel touches de raccourci utiles pour ms excel مفاتيح الاختصار مفيدة ل MS التفوق एमएस एक्सेल के लिए शॉर्टकट कुंजी
Previous Article Benefits of garlic to cure various infections
Next Article Eggless vanilla cake sponge recipe in oven, kadhai and pressure cooker

2 Comments

  1. Monica
    December 23, 2019 at 11:10 pm

    Very helpful information.

    Thank you!

    Reply
  2. AffiliateLabz
    February 15, 2020 at 5:12 pm

    Great content! Super high-quality! Keep it up! 🙂

    Reply

Leave a Reply

Cancel reply

Recent Posts

  • Simple and easy eggless vanilla cake sponge recipe steps in hindi and englishEggless vanilla cake sponge recipe in oven, kadhai and pressure cooker
    By BigUses
    February 3, 2022
  • list of mind blowing tricks for ms excelShortcut keys for MS-Excel
    By BigUses
    November 13, 2019
  • Importance of Garlic to cure various diseasesBenefits of garlic to cure various infections
    By BigUses
    November 7, 2019
  • Easy and simple recipe for Eggless Date(Khajoor) CakeEasy and simple recipe for Eggless Date Palm Khajoor Cake
    By BigUses
    October 30, 2019
  • Short trick for finding a square of a numberEasy short trick for finding a square of a two digit number
    By BigUses
    October 23, 2019

Recent Comments

  • AffiliateLabz on Shortcut keys for MS-Excel
  • LOCAL SEO SERVICES on Top 10 tourist destinations list in Andhra Pradesh
  • Rupesh agrawal on Useful full forms list
  • Monica on Shortcut keys for MS-Excel
  • kiet giang melbourne on Top 10 tourist destinations list in Andhra Pradesh
January 2023
M T W T F S S
« Feb    
 1
2345678
9101112131415
16171819202122
23242526272829
3031  
Copyright © 2019 BigUses. All rights reserved.
  • About Us
  • Privacy Policy
  • Terms & Conditions