Editing and formatting a worksheet

Editing a Worksheet

Editing means changing the worksheet content or layout.

Common Editing Actions

1. insert rows or columns
2. delete rows or columns
3. copy and paste data
4. cut and move data
5. rename sheet tabs

Formatting a Worksheet

Formatting makes the worksheet easier to read and more attractive.

Common Formatting Actions

1. bold text
2. change font size
3. change text color
4. fill cell color
5. add borders
6. center align text
7. format numbers as currency, percentage, or date

Example of Good Formatting

For a sales table:

1. make headings bold
2. add borders to the table
3. highlight headings with color
4. format prices as currency
5. adjust column width

Exercise 5: Editing and Formatting

Use the table from previous Exercise

Task

1. Make the headings bold.
2. Change the heading row color.
3. Add borders to all cells.
4. Format the Price and Total columns as currency.
5. Center-align the headings.
6. Rename the sheet tab as Sales Data.