view · edit · history · print

excel navigation

  • [ctrl] + [home] / [end] = first (top-left) and last (bottom-right) data field
  • [ctrl] + [<arrows>]
  • [Control] + [PgDn[] / [PgUp] = next / previous sheet

excel shortcuts

  • [F9] = recalculate / refresh
  • [shift] + [enter] = bottom right of selection (after paste)
  • [alt] + [down] = open drop-down (combobox) for data validation fields
  • [Control] + [shift] + [1] = format cell
  • [Shift]/[ctrl] + [Space] = select or highlight row/column
  • [ctrl] + [g] > special... = goto special, select formulas
  • [Control] + [;] <space> [Control] + [:] = insert current date & time
  • [ctrl] + [-] = insert row, does not always work on international keyboards (azerty)
  • [alt] + [i] [r] = older compatibility shortcut to insert row
  • [alt] + [e] [d] = older compatibility shortcut to delete row (after selection)

More space to work

  • [Control] + [F1] = hide/unhide ribbon
  • [Control] + [Shift] + [U] = small/big formulla bar

formula edit

  • [F4] = Toggle absolute / relative reference
  • [alt] + [=] = auto sum

does not always work or dubious...

  • select + alt + ; = copy without hidden rows
  • [F9] (or formula ribbon audit "evaluate formula") = step-by-step evaluation
  • [Control] + [-] or [+] (when fully selected) = insert or delete row/col
  • use formula tips to select section = select formula sections
  • ctrl + [ = follow link?

Some laptops (Dell) without a Pause/Break key have a replacement for that: Fn + B, so:

  • Fn + B = Pause (pause execution);
  • Ctrl + Fn + B = Break (break execution);
admin · attr · attach · edit · history · print
Page last modified on August 13, 2020, at 08:31 AM