Formatting the Worksheet

You can use the Format tab to place a title on the worksheet and define how you want it to look. You can select standard Excel worksheet formats from the Table Format list. To preview the format, select one from the list and click View Format. Format examples display in a pop-up window.

Note: The sample format popup window is view-only. To apply a format to the worksheet, you must select it in the Table Formats list.

To use certain elements of a standard format but not others, apply only those you want. For example, if you select Classic 3 but do not want to use the patterns, clear the Patterns checkbox in the Formats to Apply list.

You can also select what date format should be followed on the date fields of the Format Date fields.