Excel is an essential tool in the finance industry nowadays and all our consultants use Excel on a daily basis on client site. We asked a selection of our consultants what they thought were their top ten useful keystrokes in Excel 2007. This is what they said:

  • Ctrl + C, Ctrl + X, Ctrl + V (Copy, Cut, Paste) Undoubtedly one of the most commonly used keystrokes in Windows is to copy, cut and paste. Be careful when you work with formulas – it might not work as you expected.
  • Ctrl + F (Find & Replace) A must-know keystroke to search for text on the sheet. You can also specify complex search/replace criterions using regular expressions.
  • Ctrl + Z, Ctrl + Y (Undo, Redo) Sometimes you might want to undo/redo an action you performed. Note that changes made by VBA code is not undo-able by simply pressing Ctrl + Z or Undo.
  • Ctrl + 2/3/4/5 (Bold, Italic, Underline, Strikethrough) A lot of the times I use font formatting on selected cells or range of cells. I tend to use the likes of Bold, Italic, Underline and Strikethrough to name but a few helps to give a worksheet a visual appeal.
  • Ctrl + S (Save a file) Working a on an important file, it is always good to save your file every few minutes. One to use ‘Ctrl + S’ to save files. To save as a different file, press F12.
  • Ctrl + Down/Right (Moves to the bottom/rightmost) This keystroke can be combined with ‘Shift’ key to select the whole data region. Note that it moves to the bottom/rightmost of the current data region, not the last data in the sheet. Make sure there is no blank cell in the first row or first column in the data region.
  • Ctrl + ;  (Insert Today’s Date) The cell with the inserted date will be formatted as a date format automatically (unless the format has been specified beforehand).
  • Ctrl + <Pg Up>/<Pg Dn>  (Select next/previous sheet) A handy way to navigate through sheets in a workbook. It also prevents clicking on the ‘Calculate’ button accidentally.
  • Alt->E->S->V->Enter (Paste Value) Often I have to copy and paste values from one worksheet to another. The quickest way to do it is to copy and paste values into the targeted cell(s). Variations include Alt->E->S->F (Paste Formula), Alt->E->S->T (Paste Format).
  • Alt + ;  (Select visible cell only) Very helpful if you want to copy/paste to filtered data on the selection.