Tuesday, September 6, 2011

MS EXCEL Shortcuts:-

MS EXCEL Shortcuts:-

Shortcut Keys Description


  • F2         = Edit the selected cell.

  • F5         = Go to a specific cell. For example, C6.
  • F7         =  Spell check selected text or document.
  • F11        = Create chart.
  • Ctrl + Shift + ;   =  Enter the current time.
  • Ctrl + ;              =  Enter the current date.
  • Alt + Shift + F1         = Insert New Worksheet.
  • Shift + F3                = Open the Excel formula window.
  • Shift + F5                  = Bring up search box.
  • Ctrl + A                    = Select all contents of the worksheet.
  • Ctrl + B                     = Bold highlighted selection.
  • Ctrl + I Italic            =  highlighted selection.
  • Ctrl + K                     = Insert link.
  • Ctrl + U                    = Underline highlighted selection.
  • Ctrl + 5                     = Strike-through highlighted selection.
  • Ctrl + P                     = Bring up the print dialog box to begin printing.
  • Ctrl + Z                     = Undo last action.
  • Ctrl + F9                   = Minimize current window.
  • Ctrl + F10                  = Maximize currently selected window.
  • Ctrl + F6                   = Switch between open workbooks / windows.
  • Ctrl + Page up           =  Move between Excel work sheets in the same Excel document.
  • Ctrl + Page down     =  Move between Excel work sheets in the same Excel document.
  • Ctrl + Tab                    =  Move between Two or more open Excel files.
  • Alt + =                        = Create a formula to sum all of the above cells
  • Ctrl + ' Insert              = the value of the above cell into cell currently selected.
  • Ctrl + Shift + !              =  Format number in comma format.
  • Ctrl + Shift + $             =  Format number in currency format.
  • Ctrl + Shift + #              = Format number in date format.
  • Ctrl + Shift + %               =  Format number in percentage format.
  • Ctrl + Shift + ^               =  Format number in scientific format.
  • Ctrl + Shift + @               = Format number in time format.
  • Ctrl + Arrow key             = Move to next section of text.
  • Ctrl + Space                     =  Select entire column.
  • Shift + Space                     = Select entire row.

MS EXCEL Shortcuts:-
Shortcut Keys Description
F2 Edit the selected cell.
F5 Go to a specific cell. For example, C6.
F7 Spell check selected text or document.
F11 Create chart.
Ctrl + Shift + ; Enter the current time.
Ctrl + ; Enter the current date.
Alt + Shift + F1 Insert New Worksheet.
Shift + F3 Open the Excel formula window.
Shift + F5 Bring up search box.
Ctrl + A Select all contents of the worksheet.
Ctrl + B Bold highlighted selection.
Ctrl + I Italic highlighted selection.
Ctrl + K Insert link.
Ctrl + U Underline highlighted selection.
Ctrl + 5 Strikethrough highlighted selection.
Ctrl + P Bring up the print dialog box to begin printing.
Ctrl + Z Undo last action.
Ctrl + F9 Minimize current window.
Ctrl + F10 Maximize currently selected window.
Ctrl + F6 Switch between open workbooks / windows.
Ctrl + Page up Move between Excel work sheets in the same Excel document.
Ctrl + Page down Move between Excel work sheets in the same Excel document.
Ctrl + Tab Move between Two or more open Excel files.
Alt + = Create a formula to sum all of the above cells
Ctrl + ' Insert the value of the above cell into cell currently selected.
Ctrl + Shift + ! Format number in comma format.
Ctrl + Shift + $ Format number in currency format.
Ctrl + Shift + # Format number in date format.
Ctrl + Shift + % Format number in percentage format.
Ctrl + Shift + ^ Format number in scientific format.
Ctrl + Shift + @ Format number in time format.
Ctrl + Arrow key Move to next section of text.
Ctrl + Space Select entire column.

Shift + Space Select entire row.




Note: For Sharing Our any Tricks or Post Contact us Directly via Comments Feel Free To Contact with us Thanks for Visiting

No comments:

Post a Comment

Comment Here

or

Add Your Feedback about this Post

All Posts

3G (1) 7Must HAVE Gaming Software (1) AAA-LOGO v1.2 Full (1) Activate Windows (1) Add Item in Send to (1) Adobe CS5 Keys (1) Aero FLIP 3D (1) Airtel (7) Airtel 2012 (1) Airtel 3G (2) Airtel Handler (2) Airtel opera 6 (1) All Internet Settings (1) ALT codes (1) Android Secret Codes (1) Antivirus Offline Updates (1) Antivirus Test Using notepad (1) Apps (1) Auto Hide Ip v5.1.7.2 (1) Autoconnect Modem (1) Avoid Windows 7 crash (1) Before Buying smartphones (1) Benchmark Ur Broswer (1) Blocked or Unblocked any Site (1) Blogging Guides (1) Boot loader missing? (2) Buying something (3) Buying tips (2) Bypass Firewall (1) C language (1) C Language tricks (1) Change Boot Animation Of Windows 7 (1) CMD CODES (1) CMD tricks (2) Computer and Laptop (1) Computer Buses (1) Computer Error fix (7) Computer Gender (1) Computer Hardware (4) computer Knowledge (4) computer review (2) Computer Security (8) Computer Software World (22) Computer tips (19) connecting wan pppoe problem in vista or windows7 (1) Convert movies (1) Cooling Care (1) Cooling Pad (1) CPU Slot / Socket (1) Create Invisible Folder (1) Delete all Restore Points in Windows 7 (1) disable automatic logon in windows 7/vista and xp (1) Disable USB port or Enable Disabled Usb port (1) Docomo (1) Docomo Handler (1) Download (3) Download Torrent Using IDM (2) Driverscanner 2012 (1) Earn Money (2) Enable or Disable Autorun (1) Facbook emotion pART 1 2012 (1) facebook tips (4) Firefox (1) Fix Bad Sector of Harddisk (1) Fix File Intregrity Violated Error (1) Fix USB not Recognized (1) Fix Windows Unable to Format (1) Fixed NTLDR (1) Free Recharge (3) Gaming News (1) Godmode OF WiNDOWS7 (1) GPRS World (19) GS messenger (1) Hack Symbian Phone for Installing Unsigned apps (1) HAcking (2) Hacking Deep Freeze (1) Handler Download (1) Heat Problem (1) History (5) History of Autofocus (1) History Of Computers (1) History of Mobiles (1) How to (1) How to Add HTML Codes To Blog (1) How to Add smsgupshup group widget to Blog (1) How to Add Widgets to Blog (1) Iberry Auxus AX01 (1) Idea Handler (1) iDENTIFY online phishing attack on site (1) IDM (2) IDM V6.07 B12 (1) IDM V6.09 B3 (1) Install Driver From Windows Updates (1) Install GPEDIT.MSC (1) Install Important Software (1) Install Java Games on Samsung mOb (1) Intel DP67BG (1) Internet and computer tips (11) Internet Domain (1) Internet Error Codes (1) INTERNET SECURITY (1) IT JOBS (1) Java (1) Knowledge (8) Laptop care (1) laptop Heating Problem (1) Laptop Heats up (1) latest gadgets (19) latest Movies (1) Latest tips (1) LCD problems (1) leaked... (1) Macro Shots On Full focus Camera (1) make auto-connect setting for my modem (1) Messaging (1) MISSING NTLDR (1) Mobile Free Streaming (1) Mobile Hidden Security Codes (2) Mobile History . Android History (1) Mobile Manufactures sites (1) Mobile Networks (1) Mobile Price in india (3) Mobile Review (21) Mobile security (3) Mobile Tips (15) Mobile Tutorials (3) Monday 9-6-2012 Alert (1) MS EXCEL Shortcuts (1) Must Have Softwares (2) Net Protector Error fix (1) Network Error Fix (1) New technology (2) News (21) Nokia (2) Nokia Hack (1) Nokia Nseries Project (1) Notepad As Dairy (1) Notepad Tricks (2) Opera Tricks (1) Password Protect Your Folder in Windows (1) PC Games (1) PCSX2 Tutorial (1) Pendrive tips (2) Performance (1) Publish your Blog (1) Random post (1) Recovery Softwares (2) Register product (1) Reliance (2) Reliance 2g (4) Reliance 3G (3) Remove Rootkit (1) Revo uninstaller 2.5.8 (1) s40 TIPS (1) Samsung (1) Samsung Note 10.1 (1) Samsung Secret codes (2) Security Code (1) Serial (2) Set Your Desired Wallpaper as Folder Background (1) Setup GPRS (1) Shortcuts (1) Sign Symbian Apps (2) Sony Funny Things they sold IR Camrecoders (1) Take care of (1) technology (3) Ten Must hav Software (1) Themes (1) Top TIPS For Cooling (1) Torrific Alternative (1) uc (1) UNBRICK ZUK Z1 (1) Uninor (1) Update S40 - Mobile (1) WAPSITE (1) Windows (21) wINDOWS 7 (11) Windows 8 Consumer Preview (1) Windows 8 Download (2) WINDOWS XP (4) ZUK (1) ZUK LOGO (1) ZUK LOGO STUCK (1) ZUK RESTART PROBLEM (1) ZUK Z1 BOOTLOOP (1) ZUK Z1 BRICK (1) ZUK Z1 FAILED TO BOOT (1) ZUK Z1 HOW TO UNBRICK (1) ZUK Z1 ZUK LOGO PROBLEM (1)