Page 18 of 22PREVNEXT

Audio course: Get to know Excel: Create your first workbook

Cell formatting not affected by deleting data in cell; Clear Formats command on Edit menu

Fig. 1  Formatting stays with the cell. You can't delete formatting by deleting or editing data.
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!
Fig. 2  To delete cell formatting, point to Clear on the Edit menu, and then click Formats. Or click 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, select the cell and point to Clear on the Edit menu. The Formats command removes the format from the cell. Or you can click All to remove both the data and the formatting at the same time.

Page 18 of 22PREVNEXT