Forums Home > Shortcuts Comments > Excel Comments

Excel Comments

Please post comments, feedback, or questions for Excel Shortcuts (English). For all other feedback, please post in the General Shortcuts and Site Feedback Section

Comment #177: by imann08 on 2/16/2017:

Under section 19 Auto Tables, the shortcuts for select column and select row are incorrect. It should be Shift+Spacebar for selecting rows and Ctrl+Spacebar for selecting columns [Reply]

Reply by bernd on 2/17/2017:

fixed. thanks!

Comment #175: by anshurock680@gmail.com on 8/17/2016:

thanks [Reply]

Comment #174: by Terr on 4/28/2016:

Small fix: In Excel 2013 Shortcuts, Section 8 (Applying Borders), the second to last shortcut (Outside Borders) has an 'A' where it should have an 'S'. The note to the right explaining the shortcut correctly highlights the 'S'. [Reply]

Comment #173: by Manu on 4/19/2016:

Thanks a lot,,,,,,its really worth for learners Regards, Manu [Reply]

Comment #172: by mahasenadhipathi on 4/13/2016:

Thanks a lot for providing this information.It will be good if focus is made on excel formulae little more. [Reply]

Comment #171: by RUPALI PILANE on 3/11/2016:

Thanks, Its very useful site. [Reply]

Comment #170: by JCHY on 2/7/2016:

The below keyboard shortcut for switching among non-adjacent selections: 'Ctrl+Alt+Arrow Right/Ctrl+Alt+Arrow Left' - Move to the right / to the left between non-adjacent selections (with multiple ranges selected) It works great in my Excel 2010; while it is no longer available in my Excel 2013. May ask is there any fix on it or has it been removed from Excel 2013 (which I found is very useful) Thanks a lot! [Reply]

Comment #169: by Elby on 2/4/2016:

You are missing insert symbol: Alt+I then S [Reply]

Comment #168: by shiva kumar on 1/8/2016:

how to shift the entire row to the left [Reply]

Comment #167: by SHurley on 1/6/2016:

The insert row command is priceless - 'ctrl shift =' I have been working with excel for thirty years and always forget how to do this. This is much easier to remember. [Reply]

Reply by bernd on 1/6/2016:

I know; it is too much fun; While updating the list to Excel 2016, I expanded my own use to consequently select a line before [Shift]+[Space] in combination with other line(s) in the clipboard and use it as 'Paste Insert'. Also i try to remember it as [Ctrl]+[Shift]+[+], to match it with the [-] for the delete line. Thanks for the feedback!

Comment #165: by susmita on 1/2/2016:

Very helpful page for all.. [Reply]

Comment #164: by Eddie K on 12/17/2015:

Hi - Great site, I have found many uses for it! thanks Small spelling mistake in the Excel 2010 shortkeys, section 6.0 "Multipe" 6. Manage Multipe Worksheets [Reply]

Reply by bernd on 3/1/2017:

fixed 'spacial' to 'special'. did escape the spell check. thx!

Reply by Chris Nelson on 3/1/2017:

Also, in the context of "small spelling mistakes" the word "spacial" should probably be "special". (Item #7 at the top of the main Excel page.)

Reply by bernd on 12/26/2015:

fixed; thanks.

Comment #160: by Christoff on 12/16/2015:

This shortcut seems to be missing from Excel, Data Selection: Control + . (Full stop) Move anchor cell to next corner of selected range [Reply]

Reply by bernd on 12/26/2015:

Thanks for checking on this; this is already included in (3) Navigate Inside Selected Text Blocks on the Excel 2013 section; i made sure it got into the 2016 version as well

Comment #158: by ganesh870 on 11/27/2015:

how to connect one excel data link to another excel data. [Reply]

Comment #157: by anurag2806 on 10/17/2015:

Comment #159: by anurag2806 on 10/16/2015: please tell in excel sheet if I cut a row and want to insert this cut row any where in the sheet then how to do [Reply] Reply by shilpy on 10/16/2015: FIRST OF ALL U SELECT THE ROW THEN CTRL X AND PATSE THIS ROW WHERE YOU NEED.. remarks by anurag saxena Hellow By doing this action a blank row is being created where I do ctrl+x you have answered how to cut and paste the row but I want to know after cut( ctrl+x) , I want to insert this cut cell to a place where I need once again I am projecting my query I want to cut a row and then I want to insert this cut row(not a paste row) this action I performing till now by the right click of mouse then inserting the cut row but I request that how to do this by short cut command [Reply]

Reply by sreedath on 11/25/2015:

Hi, There is an easy way of doing it. After you cut the desired row using CTRL+X, go to the row where you want to insert it. And then follow the sequence "Shift +space" (to select the row and then "CTRL+Shift+=" (CTRL++). This will insert the row.

Reply by Hocky on 11/5/2015:

Hi Anurag, In my case, I would do the following" After - select row & Ctrl +x, put your active cell in the column A - on the row you want to paste. Press the key that represent right click on the keyboard (normally it is located on the right side just next to the 'Alt' key) then press "e" and than "Enter"

Reply by Hocky on 11/5/2015:

Hi Anurag, In my case, I would do the following" After - select row & Ctrl +x, put your active cell in the column A - on the row you want to paste. Press the key that represent right click on the keyboard (normally it is located on the right side just next to the 'Alt' key) then press "e" and than "Enter"

Reply by shilpy on 10/17/2015:

shortcut of insert a row is ctrl+

Comment #152: by shilpy on 10/16/2015:

HOW TO PLAY A GAME IN EXCEL BY KEYBOARD'S KEY.. [Reply]

Reply by John on 11/23/2015:

no jokes

Comment #150: by anurag2806 on 10/16/2015:

please tell in excel sheet if I cut a row and want to insert this cut row any where in the sheet then how to do [Reply]

Reply by sreedath on 11/25/2015:

Hi, There is an easy way of doing it. After you cut the desired row using CTRL+X, go to the row where you want to insert it. And then follow the sequence "Shift +space" (to select the row and then "CTRL+Shift+=" (CTRL++). This will insert the row.

Reply by shilpy on 10/16/2015:

FIRST OF ALL U SELECT THE ROW THEN CTRL X AND PATSE THIS ROW WHERE YOU NEED..

Comment #147: by shilpy on 10/15/2015:

SHORTCUT CTRL+; DATE CTRL+SHIFT+; TIME ALT+D+E TEXT TO COLUMN ALT+O+C+A ADJUST DATA CTRL+1 FORMET CELL ALT= SUM CTRL+2 BOLD ALT+W+F FREEZE ALT+A+M REMOVE DUBLICATE CRTL+SPACE SELECT coloumn CRTL- Remove select coloumn ALT+W+Q ZOOM SHIFT+CTRL+# DATE FORMET LEN(_) VALE COUNT add 2 column = C1 &" "&C2 Ctrl+Shift+# Applies the Date format Ctrl+Shift+: Enters the current time Ctrl+L or t Displays the Create Table dialog box Ctrl+R Uses the Fill Right command to copy Ctrl+Y Repeats the last command F12 Save AS formula as it is ctrl+~ VALUE PASTE ALT+CTRL+V PivotTable or PivotChart ALT, D, P Display Windows Help Win+F1 mouse right click Shift+F10 Opens Windows Task Manager Ctrl+Shift+Esc rename sheet alt,o,h,r [Reply]

Comment #146: by mohd mujtaba sharif fahad on 10/11/2015:

Thanks a lot i have improved my knowledge more and its help full for me [Reply]

Comment #145: by Yaakub on 9/29/2015:

Thanks for the summary of it. [Reply]

Comment #144: by manipmk on 9/18/2015:

Thanks for your service. very usefull for my work [Reply]

Comment #143: by Avinandan on 9/2/2015:

thnk you very much [Reply]

Comment #142: by GAYATHRI on 8/24/2015:

Thankyou!!! Its very helpful, Excel made easy!! [Reply]

Comment #141: by RAFIK on 8/20/2015:

THIS IS VERY HELP FULL Thanks [Reply]

Comment #140: by anandan on 7/4/2015:

MS Office Xl Short cut its very useful to me thank you to the creator [Reply]

Comment #139: by Ramareddy on 7/3/2015:

Very heplful service. Thanks a looot. [Reply]

Reply by John on 11/23/2015:

What is Looot?

Comment #137: by Amit on 6/24/2015:

Very helpful , thanks you admin [Reply]

Comment #136: by xtine on 6/18/2015:

As old as the post is i love it...old is gold anyway... would someone kindly get me a way of changing case in excel...this is really hectic....think think think.... [Reply]

Comment #135: by rakeshg on 6/4/2015:

thank you very much,for providing very useful information [Reply]

Comment #134: by MD RAFI on 6/4/2015:

excellent work done by your team, this material is very much useful for each and every body thank you sooooo much [Reply]

Comment #133: by MGWT on 5/23/2015:

Hi all, I know that using the arrow keys within a worksheet helps you move from one cell to another with ease. From some reason, I'm not able to do that anymore :-/ pressing on the arrow keys leave the same cell marked and the entire worksheet move up-down and sideways. Have you encountered this before? How can I gain control again? Thanks in advance, Meital [Reply]

Reply by bernd on 5/23/2015:

on your keyboard, you probably activated the 'scroll lock' key. press that one and it should work. There are also a couple of others like my laptop has a key to disable the function keys....

Comment #131: by B.SREENIVASULU SHETTY on 4/21/2015:

I want to learn excel programming. Please let me know how to write a programme and how to check the result of that programme. [Reply]

Comment #130: by Charles Tate on 4/17/2015:

Mac: [Command][Arrow] moves to bottom, right, left, or top of data. [Reply]

Comment #129: by Pat on 4/14/2015:

I'm using Excel 2007 and accidentally overwrote the Undo (ctl + z) shortcut when writing a macro. How do I get it back? [Reply]

Comment #128: by SATISH on 4/2/2015:

I want to made a calender and show the today date (with high light). I am not able to do it. I am trying again and again but I am helpless. Can you help me? [Reply]

Comment #127: by peter schofield on 3/20/2015:

excel 2010 with windows 8.1 - alt-f-a (file save-as) no longer works - it crashes excel [Reply]

Comment #126: by CAREE on 3/11/2015:

Is there a keyboard shortcut to rename a worksheet? [Reply]

Reply by fringebenny on 4/5/2015:

Alt+o then h r Rename current worksheet (format, sheet, rename)

Comment #124: by neeru on 1/5/2015:

how to remove formula base cell without any distrub my result by formula [Reply]

Comment #123: by aishaok on 12/22/2014:

Sir, How to increase & decrease space in a single cell in between or among the multiple lines? Please help [Reply]

Comment #122: by naveed on 11/24/2014:

How to download this page? [Reply]

Reply by ajbroadnax on 1/8/2015:

I recommend saving the shortcut list in .pdf format. To do this: a) Right click the ".pdf" in the upper right hand corner b) Select "Save Target as..." from the menu c) Before hitting save as, change the name for the file from "doc" to something meaningful. d) print from Adobe Acrobat or your preferred pdf reader.

Comment #120: by siddaguru on 10/21/2014:

it is really useful for me tnx [Reply]

Comment #119: by sekhar on 10/18/2014:

i'm using excel, its really help full me [Reply]

Comment #118: by vikas tiwari on 9/16/2014:

really help me a lot [Reply]

Comment #117: by Zandre (SA - Nelspruit) on 9/10/2014:

Great site for Excel shortcuts...You have made my life so much easier, very helpful to assist client to overcome problems with normal "clicking" not functioning... [Reply]

Comment #116: by Yogi on 9/9/2014:

It is very helpful. Thank you for consolidating the details.
Obvious shortcuts like Arrow Keys, Page Up and Page down, etc could have been avoided as I'm sure 99% of the people who could navigate to this page would already know these.
Nevertheless. [Reply]

Comment #115: by vinodhkumar on 8/23/2014:

Its helping me so much.Thankyou guys. [Reply]

Comment #114: by Eric Richards on 8/14/2014:

It could be a mistake for "Work with data selection"
to "select entire column" it works in OpenOffice 4.1 you need "Ctrl" + space + "Shift" I have not tried it in excel yet as I can no longer buy the excel CD. [Reply]

Comment #113: by AMIT KUMAR on 5/28/2014:

VERY THANK U [Reply]

Comment #112: by spring82 on 5/20/2014:

Hey guys! There is a shortcut I can not find anywhere! if you press Ctrl + [ on a cell it directly takes you to the liked cell where the original information is. For example, if in Sheet1 I have a call which is taking the data from the sheet2, when doing this it directly takes you to the data source cell! Fine, the question now is....how to do this on the spanish keyboard? I've been searching for this shortcut on the internet but it surprises me there is no information about it! can anyone help! Great web by the way! [Reply]

Reply by Shakir on 8/6/2014:

Ctrl+[ and if you want to come back to cell again then F5+Entr

Comment #110: by Ajay Pande on 5/15/2014:

Excel 2010 Shortcut keys are not up to date. [Reply]

Comment #109: by R. MURALI on 5/5/2014:

when I am using the excel the excel shortcut is very necessary. it is very useful to work quickly. [Reply]

Comment #108: by Mubarak on 4/19/2014:

Very helpful and comprehensive set of shortcut for the excel. Hats off Sir ! [Reply]

Comment #107: by Les on 3/31/2014:

I have a question. In my spreadsheet I have a formula to calculate average and more data is added to the column referred to. On selecting the formula cell I get an option to Update Formula to Include Cells. This is good and what I want to do. Is there a keyboard short key that I can use to Update Formula to Include Cells as I want to put it in a macro?

Any assistance wold be most grateful. [Reply]

Comment #106: by DDL on 3/29/2014:

Anybody know shortcut for inserting an entire row with Excel for Mac 2011? [Reply]

Comment #105: by Bhaskar Redy on 2/24/2014:

Shorts cuts are very helpful to do office works.Thanks a lot [Reply]

Comment #104: by basant on 1/14/2014:

Very heplful service, for every one for professional using [Reply]

Comment #103: by NITIN on 1/12/2014:

This Shortcut Keys are Very Helpful to us Who Is always working in excel sheet and woooooooooooooooooooooooow [Reply]

Reply by ranjith on 5/7/2015:

wat wooow shutup bloody

Reply by CHIRANJEEV KUMAR on 1/17/2015:

This shortcut key are very helpful and data manage alway working in worksheet and replyy........

Comment #100: by Shaik on 11/19/2013:

Thanks a lot...these r very helpful.... [Reply]

Comment #99: by Hussain on 10/31/2013:

You people have really done a Great Job to help others and make their work easier,
Could you please let me if there is any shortcut key for FORMAT PAINTER option in excel 2010. [Reply]

Comment #98: by Sukumar Barua on 10/10/2013:

Thanks a lot for your research and share it with us. [Reply]

Comment #97: by aanilyyadav on 9/30/2013:

thanx your shortcut
is very use full
anil yadav Tulsipur [Reply]

Comment #96: by HarryM on 9/16/2013:

Thanks for this great resource: it is truly a boon!
Please can you help me? To edit a cell comment (without having already clicked into the cell) you say use SHIFT + F2, but on my macbook pro this only brightens the display (doesn't enter the cell). I would like to have a shortcut to edit a cell comment without clicking into the cell first.
I'm using Excel for Mac 2011 on Mac OS 10.7.5
Thanks! [Reply]

Comment #95: by selva on 9/16/2013:

Great....... [Reply]

Comment #94: by Arthur on 9/10/2013:

Makes one even faster,thanks a gazillion [Reply]

Comment #93: by VijayDeepak on 9/5/2013:

Great job. Really help in day to day life. [Reply]

Reply by Vijay Kumar Tiwari on 3/17/2015:

Please send Updated Excel Shortcuts

Comment #91: by Kura on 8/27/2013:

Excellence insight for everyone - thankz a million! [Reply]

Comment #90: by Amol G. on 8/22/2013:

Really it is very usefull................. [Reply]

Comment #89: by Prabodh on 8/19/2013:

Good Compilation. Very helpful. Thanks [Reply]

Comment #88: by talat on 8/16/2013:

dear,all team
it was really helpful
thank you very much for imp information which is very useful. [Reply]

Comment #87: by pritesh on 8/9/2013:

Helped me too alot on working on excel
thks a ton.. [Reply]

Comment #86: by Rajalakshmi on 8/2/2013:

Its very helpful site for everyone to know the all shortcuts and help for improver themselves [Reply]

Comment #85: by MIT123 on 7/28/2013:

really help me a lot [Reply]

Comment #84: by subhash yelgalwar on 7/27/2013:

i want feet to colmn width short cut key [Reply]

Comment #83: by Ramzaan on 7/9/2013:

It is realy a wonderful site to work with easiness+quicky+correctly.thx [Reply]

Comment #82: by thala on 6/12/2013:

dear all, i want a excel shortcutkeys for upper and lowercase letter, any one can help on this [Reply]

Comment #81: by pampapathi on 6/6/2013:

dear team , thanks v much [Reply]

Reply by Sanjeev on 8/18/2014:

Please try this
=upper (), = Lower() , = Proper ()

Comment #79: by Vinayak R. K. on 5/17/2013:

Thanks to all team of u, [Reply]

Comment #78: by Dave on 4/18/2013:

Great List! I spend a few weeks this year putting together a side-by-side list of Excel Windows and Mac shortcuts: http://exceljet.net/keyboard-shortcuts

Interested in feedback and suggestions for improvements. [Reply]

Comment #77: by AjitKumar on 4/13/2013:

Thanks Team,
my work in a very easy & fast & sort time in complete work [Reply]

Comment #76: by makansnegi on 3/11/2013:

Thanks for sharing the kind information, it's really g8 helpful for me or many new Users. [Reply]

Comment #75: by Sandeep Ramisetty on 3/6/2013:

It is very helpful to me,to work in a easier way thanks a lot...........! [Reply]

Comment #74: by bhavika on 3/4/2013:

it is very useful site . thanks [Reply]

Comment #73: by shruthi on 2/28/2013:

thank you. it was quite helpful:) [Reply]

Comment #72: by pk8696265589 on 2/22/2013:

Dear Sir
ms excel formula sheet provide [Reply]

Comment #71: by israel on 2/17/2013:

it is really useful site [Reply]

Comment #70: by PRAKASH on 2/12/2013:

THIS IS A QUESTION THAT ALWAYS PLAY WITH ME THAT IN EXCEL IF WE WANT TO FILL SERIES THEN WE NEED TO JUST USE SELECT THE SERIES OR ANY THING AND THEN USE DROP DOWN KEY AND ALL THE SERIES WILL BE FILLED AUTO .
NOW MY QUESTION IS THAT IF I WANT TO DO SAME THING BY KEYBOARD THEN WHAT I NEED TO DO. [Reply]

Reply by Wesley Steinbrink on 5/29/2014:

Combining with the reply by parthi gives:
1) Use Shift-DownArrow to highlight where you want the series to go - must include the filled in cell that you want to key off of. 2) Alt - E I S 3) Shift-Tab F 4) Enter
H FI S = Home Fill Series
E I S = Shorter Legacy Version?

Reply by Wesley Steinbrink on 5/29/2014:

1) Use Shift-DownArrow to highlight where you want the series to go - must include the filled in cell that you want to key off of. 2) Alt - H F I S 3) Shift-Tab F 4) Enter

Reply by parthi on 4/20/2013:

first enter the number 1 in cell and select up-to you want then select using ctrl+shift+ up-arrow, then enter alt+e+i+s

Comment #66: by Robin on 1/13/2013:

Thanks so much for your website!! I was trying to solve an issue with Excel (turns out what I wanted to do doesn't exist), BUT, thanks to your web site, I managed to easily resolve the problem. Microsoft could take a lesson from you. I'll give them a big K.I.S.S. (keep it simple stupid)...... [Reply]

Comment #65: by Phaneendar on 1/10/2013:

Thank you very much for this post. All the shortcuts are excellent [Reply]

Comment #64: by ziauddin zia on 1/5/2013:

thanx dear for u
that u provice nice shortcutkey for us
hope u will provide new progrmaes and new shortcuts key
once again thanx for u and ur friends those whoses help u in this programes [Reply]

Comment #63: by Josephine on 1/1/2013:

This is so cool.....good reference list, thanks for the effort [Reply]

Comment #62: by prathibha on 12/27/2012:

This is very nice and easy to find out, excellent...
Thank u........ [Reply]

Comment #61: by Sharad Gunjal on 12/5/2012:

Excellent! [Reply]

Comment #60: by chrissietan on 11/5/2012:

Hi, how do I select from data filters on excel 2007 onwards? [Reply]

Reply by bernd on 11/5/2012:

will [alt]+[arrow down] on the filter cell get you to what you need?

Comment #58: by Dan on 10/31/2012:

How do I select non-adjacent cells? [Reply]

Reply by bernd on 11/1/2012:

Press and hold [Ctrl] and select with mouse; could not find way to select with keys only.

Comment #56: by Rebecca on 10/29/2012:

Your site is very useful and thanks so much for posting it. I'm amazed with all the short-cuts, and love the short-cut keyof selecting many columns via CTRL + Shift + down arrow key. However, after the selection is made, is there a short-cut key that can bring the cursor back to home or the top of the page, instead of using the scroll bar? [Reply]

Comment #55: by Aditya on 10/29/2012:

This Shortcut Keys are Very Helpful to us Who Is always working in excel sheet and new technic for the intresting shortcuts.................................. [Reply]

Comment #54: by sasi on 10/26/2012:

Nice and very useful [Reply]

Comment #53: by Andrew on 10/1/2012:

This keyboard cover for Macs has Excel shortcuts printed on it. It's much easier than memorizing all the shortcuts. Check it out: www.excelskin.com [Reply]

Comment #52: by Kevin on 8/31/2012:

Thank you so much for this list, its really helpful. [Reply]

Comment #51: by jagdish on 8/28/2012:

Very good shortcuts.rnRemembering all these shortcuts are even impossible, so some helpful topics should be posted in your friendly site so we could benifit them [Reply]

Comment #50: by santosh on 8/22/2012:

a comprehensive Ms exile formula [Reply]

Comment #49: by John on 8/7/2012:

Your website so helpful for me Thanks....Please help me in excel,I need "format painter" short key please advise [Reply]

Comment #48: by Prakash Shrikhande on 8/6/2012:

Its the best approach for the starters who r having less knowledge to know how to run exel effectively. [Reply]

Comment #47: by John on 7/27/2012:

Awesome resource - thanks for putting it together. Small issue I found - you have a duplicate entry on http://www.shortcutworld.com/en/win/Excel_2010.html > 5. Formulas and Names for Ctrl+Shift+Enter. Just listed twice is all.

Again, great job. [Reply]

Reply by bernd on 8/12/2012:

fixed. did not see that. thx!

Comment #45: by R. Daly on 7/23/2012:

Do you have insert a row/column and delete a row/column here? [Reply]

Comment #44: by Murukesh on 7/21/2012:

Very helpfull, thank you very much [Reply]

Comment #43: by Fiona on 6/27/2012:

Thanks so much for the most fantastic website, his making my life so much easier in the transition from XP / Office 2003.

Just found the following to solve missing Excel unhide columns Ctrl Shift 0 http://superuser.com/questions/183197/whats-the-keyboard-shortcut-to-unhide-a-column-in-excel-2010 [Reply]

Comment #42: by rishiraj on 5/12/2012:

Hi you have provide good concept for shortcut keys which help any one to do his work easily I want some more tips for it
write now I just want to what is short cut to apply filter and remove filter on excel. [Reply]

Comment #41: by Basavaraja B on 5/5/2012:

Thanks a lot for your good work for others use. [Reply]

Comment #40: by Prasanth Reddy G V on 4/3/2012:

thank u very much this is very useful to me......excellent work [Reply]

Comment #39: by Mizanur Rahman on 3/28/2012:

it is very very excellent and nice [Reply]

Comment #38: by Mike Benstead on 3/27/2012:

One more that I find extremely useful,,,Alt+Enter adds a row within a cell [Reply]

Comment #37: by SARLA SINGH on 3/20/2012:

ITS FANTASTIC TO HAVE GET THESE SHORTCUT KEYS AT ONE PLACE [Reply]

Comment #36: by pradhiuday on 3/18/2012:

Hi you have provide good concept for shortcut keys which help any one to do his work easily I want some more tips for it
write now I just want to what is short cut to apply filter and remove filter on excel. [Reply]

Reply by Canarvan on 12/16/2012:

Toggle between apply and remove filter: Alt+D+F+F.

Comment #34: by pskm512 on 3/8/2012:

There no word's to appreciate on this work, because is useful for lot of people and i want give you one suggestion, please include about Macro-excel. [Reply]

Comment #33: by Arul.g on 3/5/2012:

good work.. thanks. [Reply]

Comment #32: by Pete on 2/10/2012:

Command+Ctrl+C is incorrect for Pasting Special.

The correct keystroke is:

Command+Ctrl+V

Just in case there were any first time excel users. [Reply]

Reply by SHAIKH JEESHAN on 2/25/2012:

plz send me more short cut on this ID

pla i need you hepl

Reply by bernd on 2/10/2012:

corrected on page. thanks!

Comment #29: by Govardhana Chary on 1/17/2012:

I saw a excel sheet, in that whatever we typed in a cell in the format numbers, then it converts that number into text. I don't know that,,,, please try it and send me the details....thanks.. [Reply]

Comment #28: by serto on 1/11/2012:

CTRL+SHIFT+: - Enter the actual system time [Reply]

Comment #27: by castrillo on 1/3/2012:

I was trying to add an Excel for Mac sheet, but I received an error message telling me the page already existed although I can't see in on the menu. Would it be possible for you to add it and I'll start populating? [Reply]

Reply by bernd on 1/4/2012:

Hi Castrillo, just created it for you => http://www.shortcutworld.com/en/mac/Excel_2011.html

Comment #25: by Capricorn on 12/6/2011:

F11 - Create chart from selected data [Reply]

Reply by SUDHAN on 8/29/2012:

SUDHAN1905@GMAIL.COM

Comment #23: by Capricorn on 12/6/2011:

F4 - Switch between relative, absolute, and mixed references [Reply]

Comment #22: by rohit sharma on 12/6/2011:

good work ... really helpful [Reply]

Comment #21: by Nilkamal on 11/8/2011:

The key board short cut to unhide the column "Cltr + Shift + )" is not working in Excel 2010. There is something wrong and it seems lost from previous version of the excel. Your comment? [Reply]

Reply by bernd on 11/8/2011:

Same problem here. Ctrl+9 / Ctrl+Shift+9 hides/unhides rows. Ctrl+0 hides columns, but Ctrl+Shift+0 does not do anything. Put a note in the page.

Comment #19: by santosh on 10/14/2011:

Thanx a ton for this!!! This is really helpful. [Reply]

Comment #18: by Marlena on 9/26/2011:

I teach advanced Excel 2010 and have a student who is blind in my class that depends on keyboard shortcuts. He knows a lot of shortcuts already; however, managing multiple worksheets, selecting multiple worksheets, etc. were all new. Thanks so much for making this available. This will not only benefit him, but many more students in the future as well as enhance the lecture portion of my class for all students. [Reply]

Comment #17: by Eshwar Prajapat on 9/16/2011:

This is Real Gift of God to All of us.... Thank`s a Lot to Gurumaharaj Sohani ji [Reply]

Comment #16: by nazim_khan on 7/14/2011:

its very very helpful , Im not good in excel but with this database its easy to follow thanks again [Reply]

Comment #15: by Muhammad iqbal on 5/4/2011:

Thanks to you people for creating the database thats so easy to use and find. You guys are making peoples life easier. [Reply]

Comment #14: by Amol on 4/23/2011:

Very good. But I requirement of cell protect not fulfilled [Reply]

Comment #13: by Amol on 4/23/2011:

Wonderful, but my requirement is cell locked option. [Reply]

Reply by Lalji on 8/30/2012:

I will support to you

Reply by yoyoyoyoyoyo on 1/26/2012:

stop crying and be a man punk

Comment #10: by Guest on 3/23/2011:

Excellent! Very exhaustive - found the shortcut for the task I wanted to perform. [Reply]

Comment #9: by Achut Patil on 3/19/2011:

Really It is very helpful. [Reply]

Comment #8: by Samiullah Weesa on 3/17/2011:

Very good shortcuts.rnRemembering all these shortcuts are even impossible, so some helpful topics should be posted in your friendly site so we could benifit them.rnRegards [Reply]

Comment #7: by Pushkar on 3/3/2011:

these are good formula, can you please send some example how to use if function and get pivot formula. [Reply]

Comment #6: by janice on 2/15/2011:

its very helpful , Im not good in excel but with this database its easy to follow thanks again [Reply]

Reply by venkatreddy on 12/6/2012:

excel database helpful easy follow useful,ple

Reply by Suraj on 6/30/2012:

its very helpful , Im not good in excel but with this database its easy to follow thanks again

Comment #3: by CatZilla on 1/5/2011:

This is the most complete, helpful, easy to use database I have found! And trust me, I have been scouring!!! :) Thank you so much for putting all this together! Greatly appreciated! [Reply]

Reply by Muhammad Kashif on 9/12/2012:

All the tricks are useful but can you tell shortcut how to copy only comments in excel and paste.

Reply by Kevin on 1/19/2012:

This is a great resource. I've also found http://datamules.com/course/shortcuts to be pretty helpful as well.

[+] show older comments  [+] show all comments

post comment