[Guest Post] Some useful shortcuts for Excel

Some useful shortcuts for Excel. A guest post by my brother Jordi.
Català - Castellano - Deutsch
This 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”


Show me more...