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

Chapter 3. Build the Budget Worksheet > Enter Values pp. 31–32

Enter Values pp. 3132

  • You can enter any values you like in this step. But if you enter the same values I do, you can later compare the results of your formulas to mine to make sure the formulas you enter in the next step are correct.

  • Do not include currency symbols or commas when entering values. Doing so will apply number formatting. I explain how to format cell contents, including values, in Chapter 6.

  • If you use the arrow keys to move from one cell to the next, the selection area disappears. Although you can enter values without a selection area, using a selection area makes it easier to move from one cell to another.

  • If, after entering values, you discover that one of the values is incorrect, activate the cell with the incorrect value, enter the correct value, and press Return or Enter to save it.

  • A dialog like the one shown below may appear when entering values in a worksheet. Clicking Yes in this dialog converts the worksheet into an Excel list. Click No to dismiss the dialog without making the conversion.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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