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.

54 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 ....

Muhammad Shahbaz said...

...:::Nice Sharing Dear, Keep Sharing With Us:::...
.
.
.
.
.
.
.
.
.
.
.
.
.
.
Get Free ===>
Hacking Tools, Hacking Videos, Hacking Tutorials

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

Intaj Mondal said...

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

A.S.M. Jibon said...

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

Teechnical Anaalysis said...

Thanks for sharing your info. I truly appreciate your efforts and I will be waiting for your further write ups thank you once again.
http://www.iwalkusa.com/

Casandra Mihaela said...

wao so funny prank hahaha 1 boy date with his friend hahahaha

Simple Date Boy With Boy In FriendShip

Muhammad Shahbaz 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..
☻☻☻☻☻☻☻☻☻☻☻☻☻☻☻☻☻☻

Royal Hacks said...

This was an awesome piece of info you wrote there. I actually couldn't leave your blog without reading each and every words of your article. Keep it up blogger. By the way, if you need any templates for your blog, you are always welcome on my site "NinjaCyber".

Jasmeen Kaur 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

ashlie jon said...

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

johny frank said...
This comment has been removed by a blog administrator.
Abhiram Garikapati said...

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

Bhaskar Kumar said...

Bhaskar Export in Faridabad :- Customer Services Providers 24 Hours Service Computer and Internet Marketing and all computer Service:-


SEO India
Computer Hardware
Computer Troubleshooting
International Courier Services
Internet Marketing
International us Edition

Bhaskar Export in Faridabad
Phone no:- 0129-2242027
Site:- http://www.bhaskarexport.co.in

Anna Listiawati 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

Khondoker Hafizur Rahman said...

Wonderful!! If I had to add to your already great list, it would be just to say "Make a plan". I will need to do for them. To work more efficiently, you definitely need to plan ahead.
Hi Friend, I am a part time blogger, Thanks for your nice post I want to be a professional, If you need to different type of Information.Please collect from many different topics blogs like as http://allvarsityinfo.blogspot.com/ http://earninfo4all.blogspot.com/ http://webmedicineblog.blogspot.com http://earnadvice.blogspot.com/ http://insurancenews4all.blogspot.com/ http://www.worldnewspaperlink.com http://beautypostbd.blogspot.com/ http://bangla-tutors.blogspot.com/ http://onlineearningtips365.blogspot.com/ http://onlinegktoday.blogspot.com/ http://alltips4earn.blogspot.com/ http://cricketnews4world.blogspot.com/ http://cricketblind.blogspot.com/ http://allinfo4world.blogspot.com http://bdedu4all.blogspot.com/ http://techtunesbd365.blogspot.com/ http://earnmoneyordollar.blogspot.com/ http://allrecipesdotcom.blogspot.com/ I WISH YOUR BEST LUCK.

Profit Rhino said...

nice post
thanks for the info

Josh Aidan said...

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

Gitika Arora 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 Singh 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

Bala Kumar said...

Pretty nice post. I simply stumbled upon your blog and wished to say that I’ve truly loved surfing around your blog posts.
In any case I’ll be subscribing in your feed and I hope you write again soon!
Also visit my weblog friend :-)
Frunu Blogger

onnet US said...

april fools jokes, pranks 2015

sony 2014 said...

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

Jasmeen Kaur 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

shrwan swami said...

http://popularpost4u.blogspot.in/
www.jobalert4u.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

sanu kumar said...

www.hactheworldwebsite.tk
Visit here

sanu kumar 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 king 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

Disha Balakrishna said...

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

Computertricksweb Blogspot said...

Nice Blog I like It
How to Keyboard Typing Speed Increase

sandipfadadu said...

www.clonenulled.net

muhammad bilal said...

http://numberonewebworld.blogspot.com see this

Kalpna Var said...

nice

naik said...

powered by translate microsoft excel post good

whatsapp tips and tricks

Googat said...

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

Googat 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

Googat said...

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

Magicjack Support said...

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

Rob Schneider said...

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

Rob Schneider said...

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

Magicjack Support 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

Magicjack Support 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

Magicjack Support 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

Magicjack Support 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

Magicjack Support 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

Safal Trading 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?

THOMAS WILLIAMS 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

socio hub said...

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

Coal Black said...

HACKER IMPOSSIBLE!!! HACKER IMPOSSIBLE!!! HACKER IMPOSSIBLE!!!
Make Millions Of Dollars Today With The World’s Best Hackers.
www.hackerimpossible.com Is The Place To Be For Your:
||Bank Transfers||Western Union Money Transfers||Electronics Shipment||PayPal Top-Up|| And Many More||
All Methods Are 100% Safe & Authentic.
• Get Thousands Of Dollars Loaded Into Your Bank Account For Only A Little Fee.
• Get Dozens Of Latest Electronics Shipped For You At Incredibly Cheap Service Fee.
• Get Thousands Of Dollars Loaded Into Your PayPal Account For Only A Little Fee.
• Get Thousands Of Dollars Sent To You Via Western Union For Only A Little Fee.
Contact Them Today
Visit: www.hackerimpossible.com For More Information.

HACKER IMPOSSIBLE!!! HACKER IMPOSSIBLE!!! HACKER IMPOSSIBLE!!!
Make Millions Of Dollars Today With The World’s Best Hackers.
www.hackerimpossible.com Is The Place To Be For Your:
||Bank Transfers||Western Union Money Transfers||Electronics Shipment||PayPal Top-Up|| And Many More||
All Methods Are 100% Safe & Authentic.
• Get Thousands Of Dollars Loaded Into Your Bank Account For Only A Little Fee.
• Get Dozens Of Latest Electronics Shipped For You At Incredibly Cheap Service Fee.
• Get Thousands Of Dollars Loaded Into Your PayPal Account For Only A Little Fee.
• Get Thousands Of Dollars Sent To You Via Western Union For Only A Little Fee.
Contact Them Today
Visit: www.hackerimpossible.com For More Information.

HACKER IMPOSSIBLE!!! HACKER IMPOSSIBLE!!! HACKER IMPOSSIBLE!!!
Make Millions Of Dollars Today With The World’s Best Hackers.
www.hackerimpossible.com Is The Place To Be For Your:
||Bank Transfers||Western Union Money Transfers||Electronics Shipment||PayPal Top-Up|| And Many More||
All Methods Are 100% Safe & Authentic.
• Get Thousands Of Dollars Loaded Into Your Bank Account For Only A Little Fee.
• Get Dozens Of Latest Electronics Shipped For You At Incredibly Cheap Service Fee.
• Get Thousands Of Dollars Loaded Into Your PayPal Account For Only A Little Fee.
• Get Thousands Of Dollars Sent To You Via Western Union For Only A Little Fee.
Contact Them Today
Visit: www.hackerimpossible.com For More Information.

HACKER IMPOSSIBLE!!! HACKER IMPOSSIBLE!!! HACKER IMPOSSIBLE!!!
Make Millions Of Dollars Today With The World’s Best Hackers.
www.hackerimpossible.com Is The Place To Be For Your:
||Bank Transfers||Western Union Money Transfers||Electronics Shipment||PayPal Top-Up|| And Many More||
All Methods Are 100% Safe & Authentic.
• Get Thousands Of Dollars Loaded Into Your Bank Account For Only A Little Fee.
• Get Dozens Of Latest Electronics Shipped For You At Incredibly Cheap Service Fee.
• Get Thousands Of Dollars Loaded Into Your PayPal Account For Only A Little Fee.
• Get Thousands Of Dollars Sent To You Via Western Union For Only A Little Fee.
Contact Them Today
Visit: www.hackerimpossible.com For More Information.

HACKER IMPOSSIBLE!!! HACKER IMPOSSIBLE!!! HACKER IMPOSSIBLE!!!
Make Millions Of Dollars Today With The World’s Best Hackers.
www.hackerimpossible.com Is The Place To Be For Your:
||Bank Transfers||Western Union Money Transfers||Electronics Shipment||PayPal Top-Up|| And Many More||
All Methods Are 100% Safe & Authentic.
• Get Thousands Of Dollars Loaded Into Your Bank Account For Only A Little Fee.
• Get Dozens Of Latest Electronics Shipped For You At Incredibly Cheap Service Fee.
• Get Thousands Of Dollars Loaded Into Your PayPal Account For Only A Little Fee.
• Get Thousands Of Dollars Sent To You Via Western Union For Only A Little Fee.
Contact Them Today
Visit: www.hackerimpossible.com For More Information.

Post a Comment

Powered by Blogger.