Excel keyboard shortcuts

This article describes keyboard shortcuts, function keys, and some other common shortcut keys for Microsoft Excel for Windows. This includes the access keys that you can use for Ribbon commands. If you’re using a Mac, please see Excel keyboard shortcuts and function keys for Mac.

IMPORTANT:

  • These shortcuts refer to the US keyboard layout. Keys for other layouts might not correspond exactly to the keys on a US keyboard.
  • If a shortcut requires pressing two or more keys at the same time, this topic separates the keys with a plus sign (+). If you have to press one key immediately after another, the keys are separated by a comma (,).
2016 2013 2010 2007

This article describes keyboard shortcuts, function keys, and some other common shortcut keys for Excel 2016. This includes the access keys that you can use for ribbon commands. For Excel Online, see Keyboard shortcuts in Excel Online.

TIPS:

  • To keep this reference available when you work, you may want to print this topic. To print this topic, press CTRL+P.
  • To see an online workbook with this information, check out our spreadsheet on Docs.com. This workbook lets you scroll, sort, and filter for any key combination. And, you can also download it.
  • Get these keyboard shortcuts in a Word document at this link: Excel 2016 for Windows keyboard shortcuts

Frequently used shortcuts

If you’re new to the Ribbon, the information in this section can help you understand the Ribbon’s keyboard shortcut model. The Ribbon comes with new shortcuts, called Key Tips, which you can make appear when you press the Alt key. The Ribbon groups related commands on tabs. For example, on the Home tab, the Number group includes the Number Format command.

This table lists the most frequently used shortcuts in Excel 2016.

To do this Press
Close a spreadsheet Ctrl+W
Open a spreadsheet Ctrl+O
Go to the Home tab Alt+H
Save a spreadsheet Ctrl+S
Copy Ctrl+C
Paste Ctrl+V
Undo Ctrl+Z
Remove cell contents Delete key
Choose a fill color Alt+H, H
Cut Ctrl+X
Go to Insert tab Alt+N
Bold Ctrl+B
Center align cell contents Alt+H, A, then C
Go to Page Layout tab Alt+P
Go to Data tab Alt+A
Go to View tab Alt+W
Open context menu Shift+F10, or

Context key

Add borders Alt+H, B
Delete column Alt+H,D, then C
Go to Formula tab Alt+M
Hide the selected rows Ctrl+9
Hide the selected columns

Ctrl+0

54 Replies to “Excel keyboard shortcuts”

  1. Neat blog! Is your theme custom made or did you download it from somewhere? A theme like yours with a few simple tweeks would really make my blog jump out. Please let me know where you got your design. Thanks fddfdfedbffe

  2. Hello There. I found your blog using msn. This is a really well written article. Ill make sure to bookmark it and return to read more of your useful information. Thanks for the post. I will definitely return. cfebbegkcbge

  3. Oh my goodness! an amazing article dude. Thanks Nonetheless I am experiencing issue with ur rss . Dont know why Unable to subscribe to it. Is there anybody getting similar rss drawback? Anybody who is aware of kindly respond. Thnkx edeeaaaedecf

  4. Outstanding post, you have pointed out some fantastic points, I as well think this is a very great website. ecgefkaeeaek

  5. When I originally commented I clicked the Notify me when new comments are added checkbox and now every time a comment is added I get 4 emails using the same comment. Is there any way you may take away me from that service? Thanks! dgegeeebgkdf

  6. Wynn documented revenue before last number of quartersit could possibly preserve stagnating, or maybe counterpicking. fbbdeefcddak

  7. Hello there, I discovered your website by the use of Google while looking for a related subject, your web site came up, it seems good. I have bookmarked it in my google bookmarks. eecdfdgfddaf

  8. Hello, Neat post. There’s a problem with your web site in web explorer, may test thisK IE still is the market leader and a large component to people will leave out your magnificent writing due to this problem. fecaebaddffe

  9. You produced some decent points there. I looked on the net to the problem and discovered many people goes together with along along with your web site. ekkbdadkgdbe

  10. Link exchange is nothing else but it is simply placing the other persons web site link on your page at proper place and other person will also do same for you. aekegaakkcce

  11. Fckin awesome things here. I am very glad to see your article. Thanks a lot and i’m looking forward to contact you. Will you please drop me a mail? cddekdebeeccdkfe

  12. This is really interesting, You’re a very skilled blogger. I have joined your feed and look forward to seeking more of your magnificent post. Also, I have shared your web site in my social networks! fgedaegbdege

  13. The data are part of an autumn of just about 16 targets in Lib Dem provide because of the 2010 commander selection, before Huhne scooped 46.5 with all the electionHermes kelly felix bags didn can far in order to move benefit abfagbfedekk

  14. Hi, Neat post. There’s a problem with your site in internet explorer, would test this IE still is the market leader and a good portion of people will miss your excellent writing because of this problem. dbggcbbeddfc

  15. Though it is true I enjoy your writing style, I don’t agree with your main point of view about this one. I do delight in your website nevertheless. edadgafgfabk

  16. I will immediately grab your rss feed as I can not find your email subscription link or enewsletter service. Do you have any? Kindly let me know so that I could subscribe. Thanks. fceeefgkfddd

  17. Outstanding post, you have pointed out some fantastic points, I as well think this is a very great website. eedffeaedakd

  18. I think this is one of the most significant information for me. And i’m glad reading your article. But should remark on some general things, The web site style is wonderful, the articles is really excellent D. Good job, cheers fddbdcfefkkf

  19. Hello just wanted to give you a brief heads up and let you know a few of the pictures aren’t loading properly. I’m not sure why but I think its a linking issue. I’ve tried it in two different browsers and both show the same outcome.

  20. I will immediately take hold of your rss as I can’t to find your email subscription hyperlink or newsletter service. Do you have any? Kindly permit me understand so that I may just subscribe. Thanks.

  21. Hi, I think your site might be having browser compatibility issues. When I look at your blog in Opera, it looks fine but when opening in Internet Explorer, it has some overlapping. I just wanted to give you a quick heads up! Other then that, excellent blog!

  22. This is actually the simplest and best guidance I have ever come across about this topic. Thank you for this very educational blog post of yours. Also, I enjoy writing articles which has a personal tone incorporated. I feel it makes your reader feel more important and also inclined to believe me more. Plus it appears to be more real and not coming from a robot. I love making my visitors feel important and also special. I want to give them the best tips on how to handle important issues such as this.

Leave a Reply

Your email address will not be published. Required fields are marked *