Earn Money By Online

Sunday 26 January 2014

Microsoft Excel Shortcut Keys

Microsoft Excel Shortcut Keys

The followings are Microsoft Excel shortcuts. Some short-cuts might be version specific.
Use at your own risk.
Mouse shortcuts


http://likesplanet.com/promote.php?ref=imerxwebtech 

Shortcut Description
Double-click (on a cell) Edit the cell contents.
Double-click (on a row/column divider) Adjust height/width to auto-fit
High-light headers of multiple rows/columns then Double-click on a row/column divider Adjust height/width to auto-fit of all high-lighted rows/columns
Triple-click Select the entire contents in the cell
Click on row/column divider then drag Adjust height/width of the row/colunn
High-light headers of multiple rows/columns then Click on row/column divider then drag Adjust height/width of the rows/colunns
Ctrl + Mouse wheel Zooms in and out of document.
Hold Shift + Click the cells Select multiple cells


Keyboard shortcuts

Shortcut Description
F2 Edit the selected cell.
F5 Goto a specific cell. For example, C6.
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 Strikethrough 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 + (Arrow key) Move to next section.

46 comments:

Stephen said...

nice list of Excel shortcut keys. most of the persons know half of the shortcuts which mentioned .... they will now know the remaining from the above list. But there are some tricks you may missed to mention ... check this list of 10 tricks we didnt know in excel 2013 ... check the list ....

Bikramjit Sarker said...

Awesome post blogger. If you need any free blogger template, then please visit NinjaCyber

Sumit Kumar said...

Awesome blog post. it is very useful for me plz help to my blog computer trickz improve design and traffic

Franchise Master said...

Track any parcel online in one place:
http://trackmypacks.com

Unknown said...

Great and nice Tips. This is really helpful for all. Here is the another helpful site CTOPTIPS.

Unknown said...

☻☻☻☻☻☻☻☻☻☻☻☻☻☻☻☻☻☻
,-,_,-,
'-,_Nice Sharing Dear, Keep Sharing With Us...

.
You May Also Like....
Hacking Tools, Hacking Tutorials, Ethical And Professional Hacking Courses, Premium Free Hacking eBooks And Videos.
Also Get Hackers Interview..
☻☻☻☻☻☻☻☻☻☻☻☻☻☻☻☻☻☻

Unknown said...

Awesome Blog, Your Tips and Tricks are well written and I also made many seo and design updates after reading your posts

Please Sir Visit My Blog - http://freetrickshub.blogspot.com

Unknown said...

Waooow!! Nice blog, this will be greatly helpful.
hp envy reviews

Unknown said...
This comment has been removed by a blog administrator.
Unknown said...

nice post about shortcuts of keyboard
http://itadminstration.blogspot.com/

Unknown said...

Today’s age is the age of information,HP laptops are best of best in Pakistan technology for more detail visit our website:hplaptop.co

laptop computer repair

hplaptop.co

HP Elite-book 820 G1 Core i5-4200U Laptop Price in Pakistan

dell laptop computer costs

pink laptop computer

Unknown said...

nice post
thanks for the info

Unknown said...

Great share shot-cut lists for computer users. This is valuable for all.

Unknown said...

Excel is very useful for us every one know that normally we create our data sheet and maintain all data in excel. But sometimes we don't know about short cut keys. Here you offer lots of short cut key that why I would like to say you Thank you very much for useful short keys
Thank you,
Professional Web Development in Delhi

Jaivinder Bhandari said...

Thanks for your post. this really great trick for any user because all are basic things for any user keep sharing always this types of helpful news. Thanks.
Gate 2015 Download Admit Card

rrrr said...

april fools jokes, pranks 2015

Unknown said...

very good blog for latest gadgets and computer tips for more visit http://www.techbeatus.blogspot.in/

Unknown said...

Your Posts are well written and unique keyboards and i like your posts about computer & blog tips
Check out this new trick i think its useful for you http://freetrickshub.blogspot.com

SAHADAT HOSAIN said...

This post is very useful and helpful. I like your posts. I always follow your Posts. I hope, in the future, you will present us with such important posts.
Computer tech BD AND IT Tips Youtube Tutorial If you want to get this video tutorial about
Please subscribe to this channel in

Vivek Singh said...

www.hactheworldwebsite.tk
Visit here

Vivek Singh said...

www.hactheworldwebsite.tk
Visit here

Anupam said...

Good information. Why you are not trying adsense? Are you banned by google? I am also.

http://www.balkuria.com/computer-engineering-internal-parts-of-c-p-u/

Mustafa said...

Latest and Most popular status for all social app such as whatsapp,viver,line and many more

Birhday status

Miss ustatus

Romantic Status

Cool status

Unknown said...

TOP RESUMES BLOG,DEGREE RESUMES,DIPLOMA RESUMES
http://www.topjobssearchblog.blogspot.in/

Anonymous said...

www.clonenulled.net

Unknown said...

http://numberonewebworld.blogspot.com see this

naik said...

powered by translate microsoft excel post good

whatsapp tips and tricks

Unknown said...

http://www.googat.blogspot.com/

Unknown said...

Free Download Softwares From Googat
Free Download Softwares From Googat
Free Download Softwares From Googat
Free Download Softwares From Googat
Free Download Softwares From Googat
Free Download Softwares From Googat

Unknown said...

Free Download Softwares From Googat
Free Download Softwares From GoogatFree Download Softwares From Googat
Free Download Softwares From GoogatFree Download Softwares From Googat

Unknown said...

Magicjack Support 1-800-653-4096
http://www.cpcsolution.info/supportt.html
Installation Support
Magicjack Renew Support
Magcijack Device Support
Internet Support

Unknown said...

This is a nice brief list of shortcuts , very helpful.
DSR Tech Computer Trading llc - Citibann.com

Unknown said...

This is a nice brief list of shortcuts , very helpful.
DSR Tech Computer Trading llc - Citibann.com

Unknown said...

Magicjack Support 1-800-653-4096,
Customer Support For Magicjack
COMPLETEPCSOLUTION is one of the best way to resolve
all problems like magicjack technical support,s
magicjack customer suppport and installation,
magicjack contact number

Unknown said...

Magicjack Support 1-800-653-4096,
Customer Support For Magicjack
COMPLETEPCSOLUTION is one of the best way to resolve
all problems like magicjack technical support,s
magicjack customer suppport and installation,
magicjack contact number

Unknown said...

Magicjack Support 1-800-653-4096,
Customer Support For Magicjack
COMPLETEPCSOLUTION is one of the best way to resolve
all problems like magicjack technical support,s
magicjack customer suppport and installation,
magicjack contact number

Unknown said...

Magicjack Support 1-800-653-4096,
Customer Support For Magicjack
COMPLETEPCSOLUTION is one of the best way to resolve
all problems like magicjack technical support,s
magicjack customer suppport and installation,
magicjack contact numbe

Unknown said...

Magicjack Support 1-800-653-4096,
Customer Support For Magicjack
COMPLETEPCSOLUTION is one of the best way to resolve
all problems like magicjack technical support,s
magicjack customer suppport and installation,
magicjack contact numbe

Unknown said...

wooo i got info about Excel Shortcut Key.

Thanks,

crude oil hni free tips

Blogger said...

Do you need free Facebook Likes?
Did you know that you can get them AUTOMATICALLY AND ABSOLUTELY FREE by registering on You Like Hits?

Anonymous said...

I am very thankful for comment here.When there are so many such Custom Built Website Delray Beach options available we all can work on the tremendous level of efforts as well as make the thing all completed. There are amazing as well as Custom Apps South Florida most necessary facts all coming up in the life span. There are all areas which we all can manage and follow up in years to come.

Maani kamili said...

A nice article here, i think that people who have grown up with the idea of using computers are showing more responsibility towards writing posts that are thoughtful, do not have grammar mistakes and pertinent to the post..

SEO company in Chennai

thesociohub said...

thanks for this.. nice blogBuy Real google followers just bookmarked it.thanks

Anonymous said...

mmorpg
instagram takipçi satın al
TİKTOK JETON HİLESİ
tiktok jeton hilesi
antalya saç ekimi
referans kimliği nedir
instagram takipçi satın al
metin2 pvp serverlar
İNSTAGRAM TAKİPCİ

Anonymous said...

perde modelleri
sms onay
TURKCELL MOBİL ÖDEME BOZDURMA
nft nasıl alınır
Ankara Evden Eve Nakliyat
trafik sigortası
dedektör
WEBSİTE.KURMA
aşk kitapları

Anonymous said...

üsküdar toshiba klima servisi
kadıköy toshiba klima servisi
kartal arçelik klima servisi
ümraniye arçelik klima servisi
beykoz samsung klima servisi
üsküdar samsung klima servisi
beykoz mitsubishi klima servisi
üsküdar mitsubishi klima servisi
pendik vestel klima servisi

Post a Comment

Powered by Blogger.