- Creating "Natural-Language" Formulas
- Using the "Intelligent Sum" Button
- Working with Stylist and Autoformat in Calc
- Letting Scenario Manager Help with What-If Projections
- Using and Creating Spreadsheet Themes
- Using DataPilot to Import and Manipulate Information from Databases Created with Other Software
- Mail Merging with OOo Writer Documents and Calc Data
- Summing Up
This chapter is from the book
This chapter is from the book
This chapter is from the book
Working with Stylist and Autoformat in Calc
Next you will work with styles and formatting using the Autoformat function in OOo Calc. In other words, you will design (style) your table to make it more presentable. There are two ways to do this.
One way is to put in styles manually. Highlight the cell range you want to format, and then select Format > Styles and Formatting or press F11.
)
Figure 9.5 Choosing a range to format.
)
Figure 9.6 The Styles and Formatting option.
You see the Styles and Formatting box. Click Heading. All the headings in your table automatically change.
)
Figure 9.7 The Styles and Formatting box.
)
Figure 9.8 Styles output.
Another way to format styles is by using the AutoFormat button. Unlike Styles and Formatting, AutoFormat has its own templates for the whole worksheet. Let’s see how it works.
Highlight the main worksheet. In this case, this is all the cells from A3 to F15.
)
Figure 9.9 The highlighted worksheet.
Select Format > AutoFormat or click the AutoFormat button.
)
Figure 9.10 The AutoFormat menu option and button.
This displays the AutoFormat box. Here you can choose from several formats. It has a preview feature so that you can easily visualize the output. You can also add custom formats and formatting options, such as the Number Format, Borders, Font, Pattern, Alignment, and AutoFit Width and Height. Choose the Default format and uncheck the AutoFit Width and Height, because you want to retain the original dimensions. Click OK.
)
Figure 9.11 The AutoFormat box.
The spreadsheet now has a new look.
)
Figure 9.12 AutoFormat output.