• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Part 11: Appendixes > Enter and Calculate Formulas

Enter and Calculate Formulas

PressTo
= (equal sign)Start a formula.
F2Move the insertion point into the formula bar when editing in a cell is turned off.
BackspaceIn the formula bar, delete one character to the left.
EnterComplete a cell entry from the cell or formula bar.
Ctrl+Shift+EnterEnter a formula as an array formula.
EscCancel an entry in the cell or formula bar.
Shift+F3In a formula, display the Insert Function dialog box.
Ctrl+AWhen the insertion point is to the right of a function name in a formula, display the Function Arguments dialog box.
Ctrl+Shift+AWhen the insertion point is to the right of a function name in a formula, insert the argument names and parentheses.
F3Paste a defined name into a formula.
Alt+= (equal sign)Insert an AutoSum formula with the SUM function.
Ctrl+Shift+"(quotation mark)Copy the value from the cell above the active cell into the cell or the formula bar.
Ctrl+' (apostrophe)Copy a formula from the cell above the active cell into the cell or the formula bar.
Ctrl+‘ (single left quotation mark)Alternate between displaying cell values and displaying formulas.
F9Calculate all worksheets in all open workbooks or, when a portion of a formula is selected, calculate the selected portion. Then press Enter or Ctrl+Shift+Enter (for array formulas) to replace the selected portion with the calculated value. Shift+F9 Calculate the active worksheet.
Ctrl+Alt+F9Calculate all worksheets in all open workbooks, regardless of whether they have changed since the last calculation.
Ctrl+Alt+Shift+F9Recheck dependent formulas and then calculate all cells in all open workbooks, including cells not marked as needing to be calculated.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint