Excel Shortcut keys

From Edgar BV Wiki
Revision as of 18:53, 17 November 2019 by Red (talk | contribs) (Created page with "* 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 ce...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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.)
Retrieved from "http://wiki.edgarbv.com/index.php?title=Excel_Shortcut_keys&oldid=37135"