Page 19 of 23PREVNEXT

Get to know Excel 2007: Create your first workbook

Formatting stays with cell; you can't delete formatting by deleting data in cell

Callout 1 The original number is formatted bold and red.
Callout 2 Delete the number.
Callout 3 Enter a new number. Bold and red again!
Formatting stays with the cell. You can't delete formatting by deleting or editing data. To delete cell formatting, on the Home tab, in the Editing group, click the arrow on Clear, and then click Clear Formats. Or click Clear All to delete data and formatting both at once.

Surprise! Someone else has used your worksheet, filled in some data, and made the number in cell C6 bold and red to highlight the fact that Peacock made the highest sale.

But that customer changed her mind, so the final sale was much smaller. You delete the original figure and type in the new number.

But the new number is still a bold red number. What gives here?

What's going on is that it's the cell that is formatted, not the data in the cell. So when you delete data that has special formatting, you also need to delete the formatting from the cell. Until you do, any data you enter in that cell will have the special formatting.

To remove formatting, click in the cell and then, on the Home tab, in the Editing group, click the arrow on Clear Button image. Then click Clear Formats, which removes the format from the cell. Or you can click Clear All to remove both the data and the formatting at the same time.

Page 19 of 23PREVNEXT