Microsoft Office Tutorials and References
In Depth Information
Formatting the Worksheet
Identify how to format various elements of the worksheet.
As you have learned, applying proper formatting to a worksheet improves its appeal and
readability. The following list includes additional worksheet formatting considerations.
Consider using cell borders and i ll colors for various portions of the worksheet.
borders, or box borders, draw a border around a cell or range of cells to set the cell or
range off from other portions of the worksheet. For example, worksheet titles often
include cell borders. Similarly, the use of a i ll color in a cell or range of cells sets off the
cell or range from other portions of the worksheet and provides visual impact to draw
the user’s eye toward the cell or range.
Use good judgment when centering values in columns.
If a cell entry is short, such as the
dependents in column C, centering the entries within their respective columns improves
the appearance of the worksheet.
Consider the use of a different theme.
A theme is a predei ned set of colors, fonts, chart
styles, cell styles, and i ll effects that can be applied to an entire workbook. Every new work-
book that you create is assigned a default theme named Ofi ce. Excel, however, includes a
variety of other themes that provide a range of visual effects for your workbooks.
Apply proper formatting for cells that include dates.
Excel provides a number of date
formats so that date values can be formatted to meet your needs. How you decide to
format a date depends on a number of factors. For example, dates that include years
both before and after the year 2000 should be formatted with a four-digit year. Your
organization or department may insist on the use of certain standard date formats.
Industry standards also may indicate how you should format date values.
The following outlines the formatting suggested in the sketch of the worksheet in
Figure 2 – 3 on page EX 70.
1. Workbook theme — Trek
2. Worksheet title and subtitle
a. Alignment — center across columns A through J
b. Cell style — Title
c. Font size — title 18; subtitle 16
d. Background color (range A1:J2) — Orange Accent 1, Lighter 60%
e. Border — thick box border around range A1:J2
3. Column titles
a. Cell style — Heading 3
b. Alignment — center
a. Dates in column B — mm/dd/yy format
b. Alignment — center data in range C4:C12
c. Numbers in column D — Comma style and two decimal places; if a cell in
range D4:D12 is greater than 70, then cell appears with background color of
orange and a font color of white
d. Numbers in top row (range E4:I4) — Accounting number format
e. Numbers below top row (range E5:I12) — Comma style and decimal places
5. Total line
a. Cell style — Total
b. Numbers — Accounting number format