Changing the appearance of worksheets

<< Click to Display Table of Contents >>

Changing the appearance of worksheets

Let's go back to our first sample worksheet. Although the worksheet is very useful for performing calculations, it is not very appealing in terms of its design. At the same time, PlanMaker has extremely powerful options for preparing worksheets in visual terms.

Let's try some of them out:

Adding a heading

What our worksheet definitely lacks is a heading. Thus, let's simply enter a relevant text in a cell above the numbers and increase its font size.

To do so, click on cell B1 to make it the active cell. Then enter the following text:

My first worksheet

Changing character formatting

Let's now choose a different font for the heading and make it a lot bigger.

For this purpose, move the cell frame back to cell B1 with the heading. Then expand the font list on the ribbon tab Home | group Character by clicking on the small arrow to the right of the font name.

fonts_detailed

PlanMaker now displays a list of all fonts installed on your computer. Select the Tahoma font, for example.

Then open the font size list font_size_input to the right of (or below) the font list, and select the 24 point size.

You can also set the font color text_color_icon if you want, and this command group also contains three buttons labeled B, I and U for enabling/disabling bold, italics and underlining.

Changing number formatting

PlanMaker provides extensive options for formatting numbers. It not only enables you to change the character format of cell content (font, font size, etc.), but you can also modify their number format.

Let's try this out: To display the values in cells B2 to B5 with a currency symbol, proceed as follows:

First, select cells B2 to B5. To do so, click on cell B2 and then – with the mouse button still held down – move the mouse cursor to cell B5.

Android/iOS: If you are using these versions, please note that selecting cells works slightly differently there. For more information, see Selecting cells and cell content.

When the desired cells are selected, choose the ribbon tab Home and then go to the command group Number and click on the group arrowgroup_arrow in the bottom right corner. The program opens a dialog box with numerous settings options. We are only interested in the Number format tab: On this tab, select the entry "Currency" in the list and confirm with OK.

Result: PlanMaker now adds a currency symbol to the numbers in the selected cells and displays them with two decimal places, as is usual with monetary amounts.

There are many other number format options that you can use to change the appearance of numbers. For example, the number of displayed decimal places can be set, numbers can be displayed as percentages, etc. Important: Applying a different number format to a value only changes how it is displayed and does not change the value itself.

You have now become familiar with a small part of PlanMaker's options for improving the visual display of worksheets. As you can imagine, there are many other options for visually enhancing worksheets and making them clearer. For more information, see Formatting worksheets.