excel automatic sum function 5 Cool Excel 2010 tips and tricks

Here are five cool tips, tricks and keystrokes to help your day go faster in Excel:

Display cell formulas and not results

If you want to see the cell in your worksheet display formulas rather than the results of those formulas then  you can do it one of two ways.

Use the keyboard shortcut Ctrl + ~ to toggle formula display on and off

You can also use Formulas > Show Formulas

excel formulas 5 Cool Excel 2010 tips and tricks

Start a new line

When you need to add a line break to a cell to start a new line of text press Alt + Enter in the cell. If you just want to wrap a long piece of text in a cell right click the cell and choose Format > Alignment tab > Wrap Text.

excel wrap 5 Cool Excel 2010 tips and tricks

Copy the contents of the cell above

To copy the contents of the cell above into the current cell press Control + ‘.

Moving around super fast and super smart

To move from one sheet in a workbook to the next (or in reverse), press Control + PgDn and Control + PgUp.  To move to the next open workbook press Control + Tab or Control + Shift + Tab.

Super quick mouse free SUM formula

Skip taking the mouse to your Ribbon to add a SUM function and do it with a simple keystroke instead. Type Alt + = and Excel adds the SUM function automatically to the current cell. Doesn’t get much easier than that!

Helen Bradley

Related posts:

  1. View formulas in Excel
  2. Multiple Paragraphs of text in an Excel cell
  3. Excel 2007- In Cell Dropdown List
  4. Go To a cell in a formula in Excel
  5. Excel – Sum a cell in all sheets but this one