Deleting and Copying Cell Formats


Objective: To delete a set of formats from a cell without deleting the cell contents and to copy a set of formatting enhancements from one set of cells to another.

Instructions: You will use the Copy, Paste Special and Clear commands from the Edit menu.

Comments: It is often more convenient to copy an existing set of formats from one cell to another than to reformat the new cell. It is also useful to be able to remove a cell's formatting without removing the entire cell.

Activity 10.1 Select the range F6:F10 again and select the Clear command from the Edit menu. A submenu of options appears. The options here are to delete everything in the cell, just the formatting, just the contents, or just the notes attached to the cell. We just want to delete the formatting, so click on the Formats option. All formatting should now be removed from the cells.

Activity 10.2 You may note that you have deleted the borders, alignment formats that were originally applied to cells F6 and F10. So you will have to put them back in. You can put these back manually but there is a slightly simpler way.

Select the range D6:D10. Now go up to the top toolbar and select the Paste Format button . An active dotted box appears around the selected range, and the cursor changes to a thick white crosshair with a paintbrush .

Now select the range F6:F10. When you release the mouse button the range F6:F10 will adopt the same formatting as the range D6:D10.



Oregon State University, College of Forestry, Forestry Community, Forestry Search, Network Support
OSU | CoF | Community | Search | Forestry Computing Helpdesk

You may direct comments to Websupport
Disclaimer
Last Updated Monday, 25-Aug-1997 13:03:52 PDT