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 ...

Get Creating Spreadsheets and Charts in Excel: Visual QuickProject Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.