##MSExcel hotkeys #jumpBack

  • Ctrl/minus does deleteCurrentSelection. Selection can be entire row
  • Ctrl/Shift/plus inserts …
  • .. it can insert a blank row above your current position, iFF the implicit “copy/past board” is empty
  • ctrl/leftBracket … to highlight the range referenced by current formula cell. Supposing E1 is a formula cell, and you need to highlight all cells which was referenced by E1. Please select the formula cell E1, then press Ctrl/[ (the open-square-bracket) keys simultaneously.
  • .. F5 then Enter .. to jump back to E1.

My most frequent operation is insert_Copied_Row.

  1. Ctrl-C to copy a row
  2. optionally move to a place
  3. ctrl-shift-plus to insert Above it
  4. Before inserting again, you need to copy again.