view · edit · history · print

excel shortcuts

  • [Control] + [;] <space> [Control] + [:] = insert current date & time
  • [Control] + [PgDn[] / [PgUp] = switch sheet
  • [shift] + [enter] = bottom right of selection (after paste)
  • [Control] + [shift] + [1] = format cell
  • [Shift]/[ctrl] + [Space] = select or highlight row/column
  • [Control] + [-] or [+] (when fully selected) = insert or delete row/col
  • [ctrl] + [g] > special... = goto special, select formulas

More space to work

  • [Control] + [F1] = hide/unhide ribbon
  • [Control] + [Shift] + [U] = small/big formulla bar
  • use formula tips to select section = select formula sections

formula edit

  • [F4] = Toggle absolute / relative reference
  • [F9] (or formula ribbon audit "evaluate formula") = step-by-step evaluation
  • [alt] + [=] = auto sum

unclear

  • select + alt + ; = copy without hidden rows
admin · attr · attach · edit · history · print
Page last modified on January 29, 2019, at 05:34 AM