view · edit · history · print

excel shortcuts

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

formula edit

  • select formula sections = use formula tips to select section
  • Toggle absolute / relative reference = F4
  • step-by-step evaluation = F9 (or formula ribbon audit "evaluate formula")
  • auto sum = alt + =
admin · attr · attach · edit · history · print
Page last modified on January 03, 2019, at 04:31 PM