Excel Shortcut Keys

MS Excel Shortcuts

Shortcuts with Function Key
F1 Open “Microsoft Office Excel Help”.
F2 Edit an Excel cell.
F3 Displays the “Paste Name” dialog box.
F4 Repeats the last action.
F5 Opens “Go To” dialog box.
F6 Switches between worksheet and menu / Ribbon.
F7 Spelling Check.
F8 Switches Extend mode on / off.
F9 Calculates all worksheets in all open workbooks.
F10 Highlights shortcut keys of Menu and Ribbon items.
F11 Creates chart of selected cells.
F12 Opens “Save As” dialog box.

Shortcuts with Control Key

CTRL + 1 Opens “Format Cells” dialog box.
CTRL + 2 Makes selected cell text bold.
CTRL + 3 Makes selected cell text italic.
CTRL + 4 Makes selected cell text underline.
CTRL + 5 Makes selected cell text strikethrough.
CTRL + 6 Displays / hides objects.
CTRL + 8 Displays / hides outline symbols.
CTRL + 9 Hides selected rows.
CTRL + 0 Hides selected columns.
CTRL + A CTRL + A once will select current data range, second time it will select whole sheet and third time it will select whole worksheet.
CTRL + B Makes selected cell text bold.
CTRL + C Copy data.
CTRL + D Fill Down command to paste topmost cell to all selected cells below it.
CTRL + F Opens “Find and Replace” dialog box with “Find” tab.
CTRL + G Opens “Go To” dialog box.
CTRL + H Opens “Find and Replace” dialog box with “Replace” tab.
CTRL + I Makes selected cell text italic.
CTRL + K Opens insert “Insert Hyperlink” dialog box.
CTRL + N Opens new workbook.
CTRL + O Opens “Open” dialog box.
CTRL + P Opens “Print”dialog box.
CTRL + R “Fill Right” command to paste leftmost cell to all selected cells in the right side.
CTRL + S Opens “Save As” dialog box.
CTRL + T Opens “Create Table” dialog box.
CTRL + U Makes selected cell text underline.
CTRL + V Paste data.
CTRL + W Close current sheet.
CTRL + X Cut data.
CTRL + Y Redo last action.
CTRL + Z Undo last action.

Miscellaneous Shortcuts

ESC Escapes dialog box, message box and discards text while writing in cell.
TAB selects right side cell.
SHIFT + TAB selects left side cell.
CTRL + TAB Switches to next tab in dialog box.
CTRL + SHIFT + TAB Switches to previous tab in dialog box.
ENTER Moves to one cell downwards.
ALT + ENTER Inserts a line break within a cell.
CTRL + ENTER Paste copied cell to all selected cells.
SHIFT + ENTER Moves to one cell upwards.
CTRL + SPACEBAR Selects an entire column in a worksheet.
SHIFT + SPACEBAR Selects an entire row in a worksheet.
CTRL + SHIFT + SPACEBAR CTRL + SHIFT + SPACEBAR once will select current data range, second time it will select whole sheet cells and third time it will select whole worksheet.
ALT +SPACEBAR Displays the Control menu for the Microsoft Office Excel window.
DELETE Removes the text data from cell (Not formatting).
HOME Moves to leftmost cell in the row.
CTRL + HOME Moves to the top-left cell of a worksheet.
CTRL + SHIFT + HOME Selects cells to the beginning of the data range from current cell.
END Moves to the cell in the lower-right corner of the window (If SCROLL LOCK is turned on).
CTRL + END Moves to the last cell in the lower-right corner of window.
CTRL + SHIFT END Selects cells to the end of the data range from current cell.
PAGE UP Moves the current view of worksheet to one screen up.
CTRL + PAGE UP Moves to the previous sheet in workbook.
ALT + PAGE UP Moves the current view of worksheet to one screen to the left.
CTRL + SHIFT + PAGE UP Moves to the previous sheet in workbook.
PAGE DOWN Moves the current view of worksheet to one screen down.
CTRL + PAGE DOWN Moves to the next sheet in workbook.
ALT + PAGE DOWN Moves the current view of worksheet to one screen to the right.
CTRL + SHIFT + PAGE DOWN Moves to the next sheet in workbook.
ARROW Move to one cell left / right / up / down.
CTRL + ARROW Move to extreme left / right / up / down in a selected data range or blank sheet.
SHIFT + ARROW Select / deselect one cell in the left / right / up / down from current cell.
CTRL + SHIFT + ARROW Select / deselect current range of data or blank sheet in the left / right / up / down from current cell.
ALT + DOWN ARROW Show a list of data in cells above to current cell as a dropdown.

62 thoughts on “Excel Shortcut Keys

  1. I got what you mean , appreciate it for putting up.Woh I am lucky to find this website through google. “I was walking down the street wearing glasses when the prescription ran out.” by Steven Wright.

  2. Good blog! I truly love how it is easy on my eyes and the data are well written. I’m wondering how I might be notified when a new post has been made. I have subscribed to your RSS which must do the trick! Have a great day!

  3. I was just seeking this information for a while. After 6 hours of continuous Googleing, at last I got it in your web site. I wonder what’s the lack of Google strategy that don’t rank this kind of informative web sites in top of the list. Normally the top web sites are full of garbage.

  4. I’m not sure where you are getting your info, but good topic. I needs to spend some time learning more or understanding more. Thanks for wonderful info I was looking for this info for my mission.

  5. Great – I should certainly pronounce, impressed with your website. I had no trouble navigating through all tabs and related information ended up being truly easy to do to access. I recently found what I hoped for before you know it at all. Reasonably unusual. Is likely to appreciate it for those who add forums or anything, web site theme . a tones way for your customer to communicate. Nice task.

  6. Wow! This could be one particular of the most useful blogs We’ve ever arrive across on this subject. Basically Fantastic. I am also a specialist in this topic therefore I can understand your hard work.

  7. Simply wanna comment on few general things, The website design is perfect, the subject material is real good. “If a man does his best, what else is there” by George Smith Patton, Jr..

  8. I think this internet site holds some really great info for everyone :D. “Heat cannot be separated from fire, or beauty from The Eternal.” by Alighieri Dante.

  9. fantastic points altogether, you just gained a new reader. What would you suggest about your post that you simply made some days in the past? Any positive?

  10. Hi, i think that i saw you visited my blog thus i came to “return the favor”.I’m attempting to find things to improve my web site!I suppose its ok to use a few of your ideas!!

  11. I am glad for commenting to let you understand what a incredible discovery my cousin’s daughter experienced using the blog. She learned a good number of pieces, not to mention how it is like to possess a wonderful coaching nature to let most people smoothly fully understand several hard to do issues. You truly surpassed people’s desires. Thanks for offering such warm and friendly, dependable, explanatory and also easy tips about this topic to Janet.

  12. I’ve recently started a blog, the info you provide on this website has helped me tremendously. Thanks for all of your time & work. “The only winner in the War of 1812 was Tchaikovsky” by Solomon Short.

  13. I do consider all of the concepts you have offered for your post. They are very convincing and will definitely work. Still, the posts are too brief for novices. May you please lengthen them a little from next time? Thanks for the post.

  14. You actually make it seem so easy with your presentation but I find this topic to be actually something that I think I would never understand. It seems too complex and very broad for me. I’m looking forward for your next post, I will try to get the hang of it!

  15. I like what you guys are up also. Such clever work and reporting! Carry on the excellent works guys I¡¦ve incorporated you guys to my blogroll. I think it’ll improve the value of my website 🙂

  16. I do consider all of the ideas you’ve introduced to your post. They’re very convincing and will definitely work. Still, the posts are very quick for newbies. Could you please lengthen them a bit from subsequent time? Thanks for the post.

  17. Pretty nice post. I just stumbled upon your weblog and wanted to say that I have truly enjoyed surfing around your blog posts. In any case I will be subscribing to your rss feed and I hope you write again very soon!

  18. I just could not go away your site prior to suggesting that I actually enjoyed the standard information an individual supply for your guests? Is gonna be back incessantly in order to inspect new posts.

  19. I am extremely impressed with your writing skills and also with the layout on your blog. Is this a paid theme or did you customize it yourself? Either way keep up the excellent quality writing, it’s rare to see a great blog like this one these days..

  20. I am glad for writing to let you know what a helpful encounter my friend’s daughter enjoyed checking your site. She came to understand a wide variety of details, not to mention how it is like to possess an amazing teaching mindset to make many people easily thoroughly grasp specified multifaceted subject matter. You undoubtedly surpassed readers’ expectations. Thanks for displaying the priceless, dependable, explanatory and as well as unique tips on that topic to Ethel.

  21. Fantastic web site. A lot of useful info here. I am sending it to a few pals ans additionally sharing in delicious. And of course, thanks on your sweat!

  22. Thank you for sharing excellent informations. Your web-site is very cool. I’m impressed by the details that you’ve on this web site. It reveals how nicely you understand this subject. Bookmarked this website page, will come back for extra articles. You, my friend, ROCK! I found simply the information I already searched everywhere and simply couldn’t come across. What a great site.

  23. You really make it appear really easy with your presentation but I find this matter to be really one thing which I believe I’d by no means understand. It kind of feels too complicated and extremely extensive for me. I am taking a look forward for your subsequent submit, I¡¦ll try to get the dangle of it!

  24. Excellent goods from you, man. I have understand your stuff previous to and you’re just extremely excellent. I actually like what you’ve acquired here, certainly like what you are stating and the way in which you say it. You make it entertaining and you still take care of to keep it smart. I can not wait to read far more from you. This is actually a terrific website.

  25. I loved as much as you’ll receive carried out right here. The sketch is attractive, your authored subject matter stylish. nonetheless, you command get got an shakiness over that you wish be delivering the following. unwell unquestionably come further formerly again since exactly the same nearly very often inside case you shield this hike.

  26. Just desire to say your article is as amazing. The clearness in your post is simply great and i could assume you’re an expert on this subject. Well with your permission let me to grab your feed to keep updated with forthcoming post. Thanks a million and please carry on the rewarding work.

  27. I needed to put you that little bit of remark to be able to say thanks a lot as before on the striking advice you have documented in this article. It was so pretty generous of you to present openly just what most of us would have marketed for an e book to earn some profit on their own, principally now that you could have done it if you considered necessary. The techniques as well served to become good way to understand that many people have the identical zeal the same as my own to know the truth a little more when considering this matter. I know there are numerous more enjoyable opportunities up front for individuals who examine your site.

  28. What i do not realize is actually how you are now not really a lot more neatly-preferred than you may be now. You’re very intelligent. You know thus considerably when it comes to this subject, produced me in my opinion imagine it from so many numerous angles. Its like women and men are not interested except it is something to do with Lady gaga! Your personal stuffs great. At all times care for it up!

  29. Pretty section of content. I just stumbled upon your blog and in accession capital to assert that I get actually enjoyed account your blog posts. Anyway I will be subscribing to your augment and even I achievement you access consistently quickly.

  30. I’m just writing to let you understand of the extraordinary experience our princess obtained visiting your web site. She noticed lots of pieces, with the inclusion of what it is like to possess an incredible helping heart to get other people completely learn various specialized subject areas. You truly did more than people’s expected results. Thanks for coming up with these practical, healthy, educational not to mention easy guidance on that topic to Emily.

  31. What i do not realize is actually how you are no longer really a lot more neatly-favored than you might be right now. You’re very intelligent. You already know thus significantly when it comes to this matter, made me individually believe it from a lot of various angles. Its like men and women don’t seem to be interested unless it is one thing to do with Girl gaga! Your individual stuffs nice. At all times take care of it up!

  32. I¡¦m no longer positive the place you’re getting your info, but great topic. I must spend a while finding out much more or figuring out more. Thank you for fantastic info I was on the lookout for this information for my mission.

  33. I actually wanted to jot down a remark to be able to express gratitude to you for the magnificent facts you are posting at this site. My time-consuming internet research has now been honored with reasonable facts and strategies to exchange with my company. I ‘d repeat that most of us readers are very endowed to be in a useful website with so many brilliant professionals with beneficial strategies. I feel very much happy to have seen your web site and look forward to plenty of more excellent moments reading here. Thanks once more for everything.

Leave a Reply

Your email address will not be published.

Enjoy the tutorial? Please spread the word :)

Follow by Email
Facebook
Facebook
Google+2k
Google+
http://hirdeshbhardwaj.com/2016/11/08/excel-shortcut-keys
YouTube49
YouTube