Microsoft Office Tutorials and References
In Depth Information
Creating Custom Cell Formats
colors from the current theme (the best choice, as we explain later in this section), and the
Line Style menu gives you a dozen border styles, including dots, dashes, thin lines, and thick
lines. The More Borders option at the bottom of the menu opens the Border tab in the
Format Cells dialog box, which adds one extra line weight and the option to add diagonal lines
through a cell.
The Alignment group on the Home tab contains another, equally well-hidden button that
contains the orientation options shown here.
That last option leads to the Alignment tab of the Format Cells dialog box, which offers
iner-grain control at angles besides 45 and 90 degrees.
Creating Custom Cell Formats
In our earlier discussion of the built-in categories on the Number tab of the Format Cells
dialog box, we left out the very last one: Custom. If none of the ready-made date, decimal,
or number formats are exactly what you need for a particular range, you can create a
custom format here. You can specify how positive and negative numbers are formatted, create
your own date and time formats, and control the number of decimal places and significant
digits that appear for each value.
INSIDE OUT Reuse custom number formats
Excel saves custom number formats on a per-workbook basis, which allows you to use
them on any worksheet in that workbook. To copy a custom number format to another
workbook by using the Clipboard, first select a cell containing the custom format in
the current worksheet and copy it to the Clipboard; then, in the new workbook, click
Paste, Paste Special on the Home tab (or press Ctrl+Alt+V) and choose Formats. To
make a custom number format available for all workbooks you create, add it to the
default workbook template. (See “Changing Default Formatting for a New Workbook”
on page 478.)
Search JabSto ::




Custom Search