MS Office Excel Shortcut Keys

Shortcut                  Description


F2                            Edit the selected cell.
F5                            Goto a specific cell.
F7                            Spell check selected text and/or document.
F11                          Create chart.
Ctrl + A                    Select all.
Ctrl + B                    Bold.
Ctrl + C                    Copy.
Ctrl + F                     Find(same as Shift + F5).
Ctrl + G                    Go To.
Ctrl + H                    Replace.
Ctrl + I                      Italic.
Ctrl + K                    Insert link.
Ctrl + N                    New Workbook.
Ctrl + O                    Open Workbook.
Ctrl + P                     Print dialog.
Ctrl + S                     Save.
Ctrl + U                     Underline.
Ctrl + V                     Paste.
Ctrl + Z                     Undo.
Ctrl + Y                     Redo.
Ctrl + X                     Cut.
Ctrl + 5                      Strike through text.
Ctrl + F3                    Define Name.
Ctrl + F4                    Exit Excel.
Ctrl + F6                    Switch between open workbooks.
Ctrl + F9                    Minimize current window.
Ctrl + F10                  Maximize current window.
Shift + F1                   Activate Help on Item.
Shift + F2                   Insert Comments.
Shift + F3                   Insert Function.
Ctrl + Shift + ;            Enter the current time.
Ctrl + ;                        Enter the current date.
Ctrl + Page down        Move to next worksheet.
Ctrl + Page up             Move to previous worksheet.
Ctrl + Shift + #            Number Format: Date
Ctrl + Shift + @          Number Format: Time.
Ctrl + Shift + !             Number Format: Commas.
Ctrl + Shift + $            Number Format: Currency
Ctrl + Shift + %           Number Format: Percentage.
Ctrl + Shift + ^            Number Format: Scientific.
Ctrl + Space                Select entire column.
Shift + Space               Select entire row.
Ctrl + (Arrowkey)        Move to next section.


Comments

Post a Comment

Popular posts from this blog

How To Remove "Powered By Blogger' Attribution In Blog

Image
Go to Blogger.com and login to your Blogger profile Select  your blog that you wish to remove this attribute Now go to template and click edit HTML Here drop-down “jump to widget” option and from that list select Attribution1 as highlighted below Now in the editor press ctrl + F and find for this line  <b:widget id=’Attribution1′ locked=’true’ title=” type=’Attribution’> Now replace the locked=’true’ in to locked=’false’ as you can see highlighted below Once done click save template Now go to layout option and at the below you can see attribution gadget, click edit. In that popup window click remove and you are done Now go and view your site where you won’t see the “powered by Blogger” attribution. Your copyright text is also removed along with powered by Blogger attribution. To add copyright text just click add a gadget in layout settings select HTML/JavaScript, add your copyright text and drag and drop it below. Removing this powered by Blogger attribution adds un...
Read more

China sends jets into air zone as Japan South Korea defy it

Image
  China sent fighter jets and an early warning aircraft into its newly declared air defence zone state media said Friday as Japan and South Korea stated they had defied the zone with military overflights. Related Stories   Japan S.Korean military planes defy China's new defense zone Reuters   US backs Japan as China tensions soar on air zone AFP   China sends warplanes into air defense zone Associated Press   China military sends air patrols through new defense zone: Xinhua Reuters   Defying China U.S. bombers and Japanese planes fly through new air zone Reuters The Chinese planes had conducted normal air patrols on Thursday as a defensive measure and in line with international common practices said Shen Jinke spokesman for the People's Liberation Army (PLA) Air Force according to state news agency Xinhua. Shen said China's air force would remain on high alert and take measures to protect the security of the country's airspace Xinhua reported. Japan and So...
Read more