Formatting Worksheets

About formatting worksheets

You can use a variety of formatting tools to make a worksheet attractive and easy to read.

Options for formatting worksheet elements

The following table describes tasks and related Help topics for using Worksheet Options to change the appearance of a worksheet.

Task Description	Related Help Topics
Specify the precedence order in which column, row, and page formatting changes will take effect	Specifying a Precedence Order for Formatting in Worksheets
Add a title, subtitle, or footnote	Including Titles in Worksheets Including Subtitles in Worksheets Including Footnotes in Worksheets
Edit the row, column, and page control labels that are automatically generated when you create new worksheets	Editing Dimension Value Labels
Change the horizontal and vertical alignment of titles, labels, footnotes, and values in data cells	Aligning Text or Numbers in Worksheets
Place borders around titles or dimension labels	Placing Borders Around Text in Worksheets
Automatically indent row labels to make the structure of hierarchies evident	Indenting Row Titles by Level in Worksheets Specifying the Amount of Indentation for Row Titles in Worksheets

Changing the look of rows and columns

The following table describes tasks and related Help topics for changing the look of rows and columns in a worksheet.

Task Description	Related Help Topics
Insert blank rows to improve readability	Inserting Rows or Columns
Insert blank columns to improve readability	Inserting Rows or Columns
Adjust the height of individual rows	Adjusting Row Height in Worksheets
Adjust the width of individual columns	Adjusting Column Width in Worksheets

Other formatting tasks

The following table describes other formatting tasks.

Task Description	Related Help Topics
Control the way numbers are represented	Choosing a Format for Numbers in Worksheets
Choose fonts, font styles, and point sizes for titles, labels, footnotes, and values in data cells	Choosing Fonts for Text or Numbers in Worksheets
Choose colors for text (such as titles, labels, and footnotes) and for values in data cells	Choosing Colors for Text or Numbers in Worksheets
Choose background colors for text or data cells, and for the worksheet window	Choosing Background Colors in Worksheets
Specify a style, width, and color for borders	Placing Borders Around Text in Worksheets
Insert page breaks	Inserting Page Breaks In Reports And Worksheets
Delete page breaks	Deleting Page Breaks from Reports and Worksheets

Specifying dimension value labels

As an alternative to manually editing labels for a series of dimension values, you can choose from a set of labels that are already defined for those values. To do this, choose Dimension Labels from the Worksheet menu, then select a label type.

Using the Highlight Special feature

You can use the Highlight Special feature to apply formatting characteristics to all dimension values associated with a dimension in a worksheet. Formatting characteristics applied using Highlight Special:

• Are applied to values on other pages as well as the currently displayed page

• Are applied to dimension values added to a worksheet after the initial formatting occurs

• Can be applied to dimension value labels, data cells, or both

Related information

For more information, search for the following topics in the Financial Analyzer Help system:

"Displaying Dimension Labels in Worksheets"

"Using the Highlight Special Feature in Worksheets"