Changing the Column Widths

Exercise -

Re-format the columns that need widening by double clicking between the column headings.

If you had to re-format the column that has the title starting in it, column C, you may have notice the column is now too wide.

The column has been adjusted to fit the widest item in it.

In this column the widest item is the heading!

You will have to adjust the width of this column by dragging the right hand side of the heading until the desired width is obtained.

Your spreadsheet will, or should, look like the following:

spread7

As an exercise calculate the profit as a % of the total sales.


Try this exercise on formating the alignment of text in cells.

Create a spreadsheet that is identical to this in terms of colour, alignment and underlining

formtext (hint: use the Menu Format Cells options)