Excel Shortcut keys

From Edgar BV Wiki
Jump to navigation Jump to search
  • Select an entire row with shift+space, a column with ctrl+space.
  • Insert the current date with ctrl+; and the current time with ctrl+shift+;.
  • Get the sum of a group of cells by selecting all the cells, then hitting alt and +.
  • Hide the row you currently have highlighted with ctrl+9, and the current column with ctrl+0. (That’s a zero.)
  • To make a line break within one cell, hit alt+enter.
  • To see all the formulae in your spreadsheet, inside their cells, hit ctrl+`. (That’s the accent grave key, aka the tilde key, in the top left.)