Effacer un format (document en anglais)

Clearing a Format

Cell formats can sometimes cause confusion to the new Excel user. As an example:

1. Move to cell A7 and type in 25/12 then press <Enter>

Because you forgot the equals sign denoting a calculation, Excel interprets this as a date.

2. Move back to A7 and correct your mistake (type =25/12 and press <Enter>)

You will find that the result is still translated into a date (Excel has assigned a date format to the cell). To

display the information as a number you have to clear the format. To do this:

3. Click once on the [Format Painter] to pick up the format of cell A8

4. Now click on cell A7 (the format clears and the number should be properly displayed)

Note that if you click on the [Format Painter] once, you can copy the format to a single cell or range and then

the painter is automatically turned off. You can also clear a format via the [Clear] button in the Editing group

on the right of the Home tab of the Ribbon.

5. Finally, press <Delete> to empty the cell - the data isn't needed

Inserting Blank Rows and Columns

Next add a title to your work. Unfortunately, there is insufficient room at the top of the sheet for this so you

will first have to insert some blank lines.

1. Right click inside cell A1 and choose Insert… from the menu which appears

2. Select Entire Row then press <Enter> for [OK]

3. Repeat steps 1 and 2 for a second blank row

Note that you can also insert columns (to the left of the active cell) using this method. Another command

lets you delete a row or column. Try this next:

4. Repeat steps 1 and 2 but this time select Entire Column - a blank column A will be added

5. Right click inside cell A1 and choose Delete… from the popup menu

6. Select Entire Column then press <Enter> for [OK]

Inserting rows and columns may seem trivial, but Excel has to adjust any formulae to take account of the

changes. For example, the Profit Before Tax formula in B5 now says =B3-B4 instead of =B1-B2. Had it not

been changed it would of course be invalid, as B1 and B2 are now empty cells. Note also that though the

taxrate has moved (to A12), it is still held in a cell named taxrate. This is one good reason for naming certain

cells - you do not have to keep a list (that has to be updated each time you insert a row or column) of which

values are held in which cells.

7.

...