Effacer un format (document en anglais)
Analyse sectorielle : Effacer un format (document en anglais). Recherche parmi 301 000+ dissertationsPar jhon • 23 Novembre 2014 • Analyse sectorielle • 499 Mots (2 Pages) • 745 Vues
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.
...