Chapter 8. Formatting Spreadsheets with Calc


IN THIS CHAPTER:

58 Freeze Row and Column Headers

59 AutoFormat a Spreadsheet

60 Format Cells

61 Center a Heading over Multiple Columns

62 Set Up Calc Page Formatting

63 Attach a Note to a Cell

64 Conditionally Format Data

65 About Calc Styles and Templates

66 Create a Calc Style

67 Create a Calc Template

Calc makes it easy to make even simple spreadsheets look professional. AutoFormat quickly formats your sheets within the boundaries you select. If you want to format your spreadsheet by hand, the formatting commands you learn in this chapter will enable you to pinpoint important data and highlight that data. Others can then look at your spreadsheets and easily find your highlighted information.

KEY TERM

AutoFormat The process that Calc uses to format spreadsheets from a collection of predetermined styles.


During this chapter, you'll learn how to change the appearance of your spreadsheets so they look as good as possible. First you'll learn how to freeze row and column headers to improve a large spreadsheet's readability. Then you'll move on to learn how to select from a list of AutoFormats styles, how to format selected cells and ranges, and how to leverage your spreadsheet designs so you can reuse them again with little trouble.



OpenOffice.org 2, Firefox, and Thunderbird for Windows All in One
Sams Teach Yourself OpenOffice.org 2, Firefox and Thunderbird for Windows All in One
ISBN: 0672328089
EAN: 2147483647
Year: 2005
Pages: 232
Authors: Greg Perry

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net