Some useful shortcuts for Excel. A guest post by my brother Jordi.Català - Castellano - DeutschThis is a guest post by my brother Jordi. A list of useful shortcuts for MS Excel that will make your workflow much faster. Here they come:
- Ctrl+”+”: Add a new column or row. Click on the column/row where you want to add and press “Ctrl” and at the same time the “+”.
- Ctrl+”-“: Delete a new column or row. Select the column/row want to delete and press “Ctrl” and at the same time the “-”.
- F2: Modify a cell. When you are in a cell, press F2 and you will be able to modify directly the cell without the need to double-click it.
- F4: Repeat an action: When you want to repeat and action you just performed, press F4 and the last action you made will be repeated.
- F9: recalculate the values. Sometimes the excel sheet are put into manual calculation, if you want the sheet to calculate and show you the values, pres F9
- Ctrl + “up arrow”/“down arrow”: Move to the first/last line with values: Press Ctrl + “up arrow”/“down arrow”
Tweet
Thanks for sharing i use all your shortcut and it make my work flow 10 time faster.Thanks for sharing useful information.
ReplyDeleteerror
134
thanks.
Hi
ReplyDeleteI am Shivane Kay, member of a Microsoft Excel Training . I had landed on your website “http://www.cad-addict.com" and found the articles really worth reading. The quality of your content is so good, that it made me request you something. I love to write Microsoft Excel Training articles and would like to contribute something for your website. I can give you an original guest post and if you want, you can suggest me the topic also and I will write accordingly. Not only that, I will also give you all the rights to edit the article and modify it as per your need.
In response I expect you to give a link back to one of my endorser who helps me to continue my passion and serve individual sites and blogs like yours.
Please let me know your thoughts. Waiting for your positive.
Thanks
Shivane Kay