250 Excel Keyboard Shortcuts

*M**icrosoft Excel having so many unbelievable capabilities that are not instantly perceived. Excel Shortcut keys are most useful and usable to save the time.*

*Shortcut keys help to provide an easier and usually quicker method of directing and finishing commands in Microsoft Excel. Mostly we prefer to use the shortcuts as it’s kind of amazing how much time we can save by not using the mouse clicks. Keyboard shortcuts in Excel are commonly accessed by using the ALT, Ctrl, Shift, Function key and Window key.*

*We really liked that windows gives us multiple ways to perform the task in Excel, let’s say we want to save a file, either we can press the key “Ctrl+S” or “Shift+F11”.*

Below are the amazing Shortcuts for Excel category wise, in which you will find the Excel formula shortcuts, Excel copy paste shortcuts, Excel keyboard shortcuts to insert row, Excel keyboard shortcuts to select row, Keyboard shortcuts for VBA and Excel hot keys (add more alt shortcuts to Excel).

*Keyboard shortcuts for Dialog Box:-*

*Entering Data shortcuts:-*

*File Commands:-*

*Keyboard shortcuts for Format:-*

*Formulas shortcuts:-*

*General keyboard shortcuts:-*

*Important Hot Keys:-*

*Shortcuts for Navigating:-*

*Keyboard shortcuts for selecting rows/column/cell:-*

*Window shortcut keys:-*

*Workbook shortcut keys:-*

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Awesome list; sad part is I’m on a Mac, if you have an updated version for MAC it would be awesome.

Don’t be sad, soon we are going to share MAC shortcut list.

Stay connected with us.

Thanks,

Site Admin

Please email me the 250 MS-Excel Keyboard Shortcuts in excel format

Thanks

Alan

Hello AlanF51MS,

Can you please send me the file in excel format? I would like it to be searchable.

Kind regards,

José

Another request for a Mac version please

Hi David,

Our team is working on this and soon we are going to share the MAC shortcuts here with you all.

Thanks

Team Excel Tip & Excel Forum

here is the mac version I found in same e-mail that got me here

http://www.exceltip.com/tips/150-mac-excel-keyboard-shortcuts.html

Would you please share this information in excel format. Thanks

that really amazing!!!!! thanks

I highly appreciated this type of keyboard shortcuts and this is very useful in our work. Thank you. Ekramul

It’s very useful. Could you also give tip to import MS word file to Excel with original, file format.

Can’t believe, its a PDF. Also, you can even search in the PDF. Absolute waste of time. I’ll rather google.

Hello Nitin,

We understand your concern however, if you want we can share the list of these shortcuts in excel / doc with you on your personal email. Also for more information please stay connected with us at Excel Forum where you can ask excel related query and get the answer from our Excel experts.

Thank you

Site Admin

I would also like the very helpful list in both Excel and Word format if possible. Many thanks,

Neil

Hi, I would like to get the list of these shortcuts in excel / doc version.

Thank you,

Jerry

gwiggers@pirnie.com

Please send the list to my email also!

I would like the list in excel or word format too please

Thanks for offering this list in excel format. Please forward a copy at your convenience.

Please provide searchable version. Thanks! -Kevin

Admin,

Please send me the .xls version of this list as well.

Thx!

kim

I would also like a copy in Excel and Word.

thanks for the shortcuts!

The PDF will be a great tool to print and keep handy but I agree that a search would be ideal. Thanks for the work that went into this guys!

Thanks Kelly!!!

It’s good to see that how important information this is for all of us. Yes, we understand that PDF will not be good in terms of searching for something. But, soon we are going to upload the XLS version for you all.

Please visit us @ Excel Forum, if you have any question / query related to Excel / VBA.

Also, please like us on FB.

Team Excel Forum & Excel Tip

Please send me list in excel format gomodyourself@gmail.com

Thank you

Please send me a copy of this information in Excel. Thank you for your kind offer.

Me too please.

Please e-mail me the excel version.

Thanks!

Josh

Can you please email me the 250 shortcuts in word and excel too please?

I would like a copy in excel format too please. Thanks

Can you please email me these shortcuts in excel format

Hi Asheesh,

XLS file is already there, you can download the same from end of the tip.

Thanks

Team Excel Tip & Excel Forum

This is an awesome compilation especially for free, not sure why all the whining about the format, though I see there is now an excel format link.

One note, i noticed that two of the shortcuts:

CRTL + 5

CRTL + SHIFT + _

seem to have been placed in the wrong group, being in navigation instead of formatting.

Dear Admin,

Could you please share me this in excel/word format to my email id

Regards

Hari

can I get excel file as well.

Thanks for your help.

TR

Please share Excel shortcuts in .xls and .doc format

Cool list. But a bit useless for everyday use if aren’t descriptions searchable

Hello Piero,

Thanks for considering it “Cool”. We understand your concern however, if you want we can share the list of these shortcuts in excel / doc with you on your personal email.

Please confirm.

Please provide me list of 250 excel short cuts in MS EXCEL FORMAT

Hello, could you please also send me an excel version of the shortcuts? Thank you!

I would also like a searchable copy. Thank you!

I will really appreciate that list on excel too.

Please send me an excel copy as well! Thanks!

I would like a copy in Excel/Word please. This is such a time saver! Thanks for this!

pleas also send me a list

thanks

great info

Bob Weight – Please send me a copy of the shortcuts in either doc or xcel format

This is great info. Will inform everybody at the office. Kindly send me copy of the shortcuts in excel and doc as well. Thanks!

Please share the ’250 MS-Excel Keyboard Shortcuts’ on my email: jkiran21@gmail.com

Hi Kiran,

XLS file is already there, you can download the same from end of the tip.

Thanks

Team Excel Tip & Excel Forum

Agree with previous poster–this is an awesome tool, but as a Mac user, would really appreciate similar list of Mac shortcuts.

Hi Claudia,

Thanks for bringing this in our knowledge. Our team is already working on this and soon we are going to share “MAC shortcuts” for all our members.

Also, if you have any question to ask, please reach us at Forum experts on Excel Forum. Our Forum experts will assist you.

Team Excel Forum & Excel Tip

Hi,

Awesome work guys.

I find these one new.

CTRL + 2 for BOLD

CTRL + 3 for ITALIC

CTRL + 4 for UNDERLINE

Keep sharing such wonderful knowledge.

John

thanks sir how about to resize the the font into large or big.. pls thanks again

If your comment about resizing font into large/big relates to the row and/or column identifiers, I would be very grateful to know about this also. I have some files in which I must have made some keystroke error and caused the font size of my row & column identifiers and can never find a way to change them back. I generally have to create a new file & import all data to remove the over-sized identifiers. Thanks in advance!

Highly appreciated effort. Thanks

Awesome! It’s funny how you use a few shortcuts but forget about all of the others. Thanks for a great reminder!

I didn’t see the CTRL/SHIFT/ARROW keys on your list. They are the biggest time saver of them all!

Ohh yeah…seems we also have missed it

But, it will be there on the XLS version.

CTRL+SHIFT+ARROW –> This key extend the selection of cells to the last non-blank cell in the selected range.

Please like us on Facebook.

Team Excel Forum & Excel Tip

Please email me the searchable Excel file.

Regards,

Tim

Please email me an excel format of the excel shortcuts. Thanks

Your site has been a true gem. I am working in an office and have taken on most of the duties of Accounting, Client management, Front office, what ever else the boss wants. I never would have been able to make the spreadsheets I have without your help and the info I have received in the forums. With your help I went from part time to a very needed piece of the office puzzle. Could you email me the excel and pdf version of your shortcut list. Also know that I am truly, truly thankful of all the work you have dedicated to this site.

Thanks for sharing the wonderful experience with us Dan!!!

The site is doing good just because of people like you who come here and get the required information which you look for.

Our team is trying best to bring something very unique every week which can be used in everyone’s daily life.

Yes, on a demand, we are going to upload XLS version of Keyboard shortcuts to make your life more easy.

Stay connected with us here.

Also, like our Facebook page.

Team Excel Forum & Excel Tip

I would appreciate a copy of the file in excel format. Thx.

Great! I have a question – difficult to describe: when you delete rows at the bottom of your data (or cells to the right), the deleted rows/cells are still active as part of the worksheet – if you press ctrl+end, it will move the cursor to the bottom right including the deleted cells. Is there a short-cut that takes you to the true bottom right cell of the worksheet?

PS please email me the list also. Tx

Great Article, Thanks for posting this.

Great list! Excel format would be helpful to make it more easily searchable, but the compilation is very handy thank you!

Thank you for this great help!!

Very nice tool. Please email me the searchable Excel file.

Could I also please got a copy in MS Excel format? Thanks!

That is awesome! I did not know there were so many keyboard shortcuts for EXCEL. Thanks a lot.

p.s. Is there a shortcut that will help me remember them all?

Thanks Tony.

Yes, the shortcut is to try 4-5 shortcuts everyday if you want to remember them all.

Please like us on our FB page.

Team Excel Forum & Excel Tip

Great list of excel shortcuts. I have developed a liking for them and this will definitely enhance that..

Thanks

Great to know Michael.

Stay connected with us for more updates.

Also, like us on FB.

Team Excel Forum & Excel Tip

Admin am new here, can i ask a favor if u hav time to send via mail those shorcut pdf files only.. i hav not micro excel yet.. thanks best regard your site

Sure Suki,

However, soon we will be uploading the excel file with all the shortcut here.

Team Excel Forum & Excel Tip

Thanks admin ..

Please share the excel and word document of the related information; thank you so much. amitmahesh99@gmail.com

Would you please email me the excel file of the shortcuts. This is a very useful list!! Thanks

Hi do I have permission to share this PDF at my job?

Hello Jason,

Yes, you can go ahead and spread this information with your friends, family, colleague etc. We would be interesting this wonderful and useful information.

Also, If you have any query related to MS-Excel or VBA, you can visit us at Excel Forum. Our Forum Gurus and Experts will assist you.

If you like the information, please like us on FB.

Thanks,

Team Excel Forum & Excel Tip

Please email me the searchable Excel file.

Regards,

Bob

If you could put these in Excel or Word format, it would be greatly appreciated.

Kindly provide me the excel sheet of the shortcuts. Thankyou

khuram.maqsood@gmail.com

I appreciate this list and would love to get the excel version to my personal email provided.

Hi Michael

Thanks and yes we are going to upload the Excel version on this page soon.

If you have any query related to Excel, you can ask our Excel experts at Excel Forum.

Also please like us on FB.

Thanks

Team Excel tip & Excel Forum

Great list. Just one thing:

Ctrl+” seems to be the transposing of contents from the above cell as opposed to ‘to fill down’.

Hi DK,

The Ctrl+” keyboard shortcut will allow you to fill down and quick edit mode. As Ctrl+D only allow you to fill down from the above cell. So we have found this keyboard very interesting, if someone wants to quickly edit by fill down the value from the above cell.

If you like our article, please visit us on FB and like our page.

Team Excel Forum & Excel Tip

Please send me the excel version. Thanks!

Good job

Kindly share me xls or doc file any one or both no prob.

Thanks and good work keep it up.

Good job

Kindly share me xls or doc file any one or both no prob.

Thanks and good work keep it up.

My Email id is : smirfanulla@gmail.com

Thanks for your kind words.

If you have any query related to Excel, you can ask our Excel experts at Excel Forum.

Also please like us FB Page.

Thanks

Team Excel tip & Excel Forum

Please email me the excel file of the shortcuts as well. This is a very useful list!! Thanks

Please provide the above in excel format.

Hello Everyone,

Glad to know that you all liked the information. As most of you have demanded the information in XLS version. Soon we are going to upload the same here on this page for you.

Keep learning and Stay Connected!!!

Also, we request you to visit our official FB page where we keep sharing the useful post and information with all our members.

Thanks

Excel tip & Excel forum

What a great list. I would appreciate the xls or doc file also. Thank you very much.

Awesome..

I would appreciate a copy of the file in excel format. Thx.

Great list, thanks for putting it together!

Thank you for the work you put in.

I, too, would appreciate an Excel file of the shortcuts.

Awesome work – is there anyway this could be made into a site PDF with render-able text (o it can be searched? Ctrf+F is much easier than visually scanning 250 shortcuts for the one you need!

Hi Guys,

Great tool, thankyou.

I would appreciate copy in word and excel please.

Keep up the great work.

Cheers,

Michael

Super duper. thanks for sharing such a wonderful guide.

Thanks this will be very useful.

Thanks for this..

Kindly send me a copy in Excel and/or Word format.

Thanks!

Wow, that is an awesome and very useful list. Thank you!!!

Can you please email me this in excel and word format?

Great stuff! Have always been a fan of shortcut keys, as they can save loads of time. I like the extras part on Windows shortcuts :). Keep up the good work!

Can you please email me this in excel and word format?

Hi Mike,

We have already uploaded the XLS version.You can download the same from there.

Thanks

Team Excel Tip & Excel Forum

Please email me the excel version

Hi hk,

Excel file is already there please find the below of the tip from there you can download the Excel file.

Thanks

Team Excel Tip & Excel Forum

I also would like this great info in an Excel file. Thank you in advance.

Keep up the good work.

Hi, where can I download the XLS version from?

Thanks.

Hi Renoix,

Scroll down till the end of the tip from there you can download the Excel file.

Also please like us Facebook page.

Thanks

Team Excel Tip & Excel Forum

Hello Everyone,

Please see below of the tip from there you can download the Excel and Pdf file.

Thanks

Team Excel Tip & Execel forum

Please provide the excel file of your Excel tips. And thank you for such a powerful tool!

Dear Admin, Please share the same for Mac as well!

Thanks in advance..:)

Awesome page.

I wanted to share with others, could not find the share link, post it with share link — I would love to share it.

Impressive!

Thx a lot for sharing

Wonderful Information , thanks a ton for the same.

Wonderful Information . Thanks a Ton.

pl mail me too that shortcut file in excel

Hi Satya,

Excel file is already here you can download it.

Thanks

Team Excel Tip & Excel Forum

,kindly send excel version of shortcuts pls. Thanks for your compilation

Would you mind including me? I’d also like to receive the excel version also for its search ability. Thanks so much for sharing this!

Oops, my error! Looks like you sent me both the PDF and Excel versions together. Thank you!

Guys you are doing an excellent stuff. thanks for the effort taken in preparing such a file. Its been a great help. U guys r really rockin….

keep up the great job..

Nice Work.

Please send me these shortcut file in excel format.

Hi All,You all can download the Excel file as well as PDF version at the end of the tip. To download ebook, scroll above if you are viewing this comment or scroll down if you are top on the page.

ThanksaSite Admin

Hello Everyone,We have released MAC keyboard shortcuts ebook too as per our users demand. Click on below link to download the e-book.

150+ MAC Excel Keyboard Shortcuts

ThanksTeam Excel Forum & Excel Tip

Excellent list! Thanks for sharing. I would also like to receive the Excel document in my email. Thank you!

Just an FYI: Page Right (Alt+Page Up) and Page Left (Alt+Page Down) are not in this wonderfully awesome list. Thank you so much, it is very helpful!

Btw, the description says Shift+F11 to save a file but the list seems to indicate it would be shift+F12. I’d also take a copy by e-mail. Can you pick it up from the e-mail that was required in order to leave a reply?

That’s saved a great deal of time – Thanks a lot. Please can you send it via Email

Great list! Please aldo email me the excel version

Great, thanks for this awesome work…

I am extremely grateful to you to have shared this excellent compilation of Excel Shortcuts in excel as well as pdf format. It will go a long way in saving time and effort while working on Excel spreadsheets.

Thank you for your time

Great job guys! Very useful. Excel is an amazing tool and your list increases productivity by several fold. Thank you very much for documenting and even more thanks for sharing.

Wow. So usefull ! Thanks for sharing.

Could you please send me Excel Shortcuts in excel and pdf format ?

You are missing the copy-down (CTRL+D)

Please email me the excel file of the MS shortcuts

Excellent! This is awesome! Thanks a million!

Please email excel shortcuts in excel format. Thanks!

Excellent notes.

Thanks a lot.

Thanks guys

This is amazing

Last line on the list – Workook???

Thank you so much for this awesome post!

Awesome … it would be more helpful if it is sent in excel format…

request for the same . please…

Hi Nadeem,

Already Excel file is there for downloading.

Thanks

Excel Tip team

Hi guys.

Thanks so much for taking the time to compile these – both in the printable, pretty PDF and searchable Excel formats.

However, noticed a problem with the PDF- some of the short cuts seem to be incorrect as the text has wrapped but 2nd line not visible, for example Ctrl+Alt+ for Paste Special box – which should read Ctrl+Alt+V (which is correct in Excel version).

Thought you might like to know so you can fix – but thanks again. Time to learn some new shortcuts

Thanx for sharing the information.

I know that this is not strictly-speaking a keyboard, but I was hoping that there was a way to scroll horizontally by using an auxiliary key with the scroll wheel. Perhaps this is not a feature, but it should be.

That should have said keyboard shortcut rather than keyboard.

Phenomenal list! Thank you for putting it together.

Would you please send me the Excel file of this list, please?

So glad I joined the forum

Hi Jordan,

Below to the tip you can download Excel file.

Thanks

Site Admin

thanks

Would you please send me the Excel file of the list, please?

Thanks,

Remarkable tool granted to the learners.

Please send the list as well – thanks.

Regarding navigating, keep in mind that several of the tips shown are for edit mode, including but not limited to CTRL+RIGHT, CTRL+LEFT, HOME & END.

Here are a few that I failed to notice in the list:

To jump to the cell before the 1st blank cell to the right: END followed by RIGHT

To jump to the cell before the 1st blank cell down: END followed by DOWN

To jump to the next sheet: CTRL+PGDN

To jump to the previous sheet: CTRL+PGUP

To jump one screen to the right: ALT+PGDN

To jump one screen to the left: ALT+PGUP

Regarding using ALT+TAB to go to a different application, hold down the ALT key while repeatedly pressing the TAB key until the application you want is highlighted, then let go of the ALT key. If you press TAB too many times and pass the application you want, without letting go of the ALT key press SHIFT+TAB to back up. This is not Excel-specific but a function of Windows.

Regarding the shortcuts for unhiding rows & columns, CTRL+SHIFT+( works for unhiding rows, but CTRL+SHIFT+) has never worked for unhiding columns (I have 2007). To unhide columns I need to type ALT H O U L instead. Remember 1st to select a range that includes the row(s) or column(s) you want to unhide.

Please send me the excel version.Thanks!

Hi Ron K,

In the end of tip you can download the Excel and PDF files.

Thanks

Site Admin

Thanks…For your effort to make easy our work..I shall much appreciate if you send me in excell format.

Thanking you

Jahir Hussain vena

Hi Ron K,

In the end of tip you can download the Excel and PDF files.

Thanks

Site Admin

Please send me the Excel Format for above Short cuts

Hi Buddhika,

Greeting from Excel Tip.

We have already given the downloadable option in both version, PDF & XLSs at the end of the tip. We request you to visit the page once again and download the file as per required format by your own.

Thanks

Team Excel Tip & Excel Forum

DeaR,

it superb information

Very Nice Information..

I may be missing it but I don’t see CTRL+* to select an entire table or range of data. Very helpful when selecting a table of data that you want to sort.