Formatting Your Spreadsheet

There are many commands in Excel which improve the presentation of your spreadsheets.

The most commonly used of these commands have buttons on the Tool Bar that activate them.

The Formatting Tools.
spread6

You may have noticed that the headings on our spreadsheet don't line up with the numbers.

Excel, like most spreadsheets, left justifies text and right justifies numbers.

We will now right justify our headings so that they line up with the numbers.

Exercise

[] Select the range of cells that make up the headings of our spreadsheet, from JAN to TOTAL.

[] Click on the Right Justify button and the text will be moved.