Using the Formatting Toolbar

Instructions: You will use the buttons on the second toolbar at the top of your screen.

Comments: Toolbars are often much quicker and easier to use than menu commands, and the formatting toolbar is especially useful if you are doing a lot of formatting on your spreadsheet all at once.

Activity 11.1 At the top of the screen you will see two toolbars. The top one is known as the Standard Toolbar. The second one is called the Formatting toolbar. It should appear as shown.

Activity 11.2 Select the range A6:A10 with the row labels in, and click on the Italics button . The contents of the selected cells all become italicised.

Activity 11.3 Select the column marked "Target" and click on the Cell Shading button. A palette of colours appears underneath the button. Choose the light grey colour (second row, second from the right). The range of cells becomes shaded with a light grey background.

Activity 11.4 Select the data in the two columns Actual Sales and Target, range F7:G12. Click on the Currency tool . The selected cells take on a currency format with two decimal places.

Activity 11.5 Select the original data in the range B7:E10. Click on the Decimal increase button twice to put two decimal places onto the figures so that all the numbers are formatted identically.

OSU | CoF | Community | Search | Forestry Computing Helpdesk