Friday, 28 September 2007

Keyboard shortcut of the week: Excel

Following on from the megapost of word-processing keyboard shortcuts from earlier this month, here is a selection of keyboard shortcuts for Microsoft Excel.

  • You can navigate around the grid of cells by using the cursor keys.
  • Hold down Ctrl and press Home to jump to the top right cell (A1).
  • Hold down Ctrl and End to jump to the last cell on the spreadsheet with any information in
  • If you wish to edit the contents of a cell press F2

As with word processing, you can hold down the Shift key to select: if you hold down Shift and press the right cursor key then you will select the current cell and the one to the right of it. If you continue to hold down the Shift key and press the down cursor key you will also select the two cells below the ones you already had selected. You can thus hold down the Shift key and press different cursor keys to select different rectangles of cells.

Many of the keyboard shortcuts that work for word processing also work in Excel: holding down Ctrl and pressing B selects bold text; Ctrl and C will copy text, etc.