Microsoft Office Tutorials and References
In Depth Information
Using template files to store formatting
Formulas adjust automatically. A formula that refers to a subsidiary cell in a merged
range changes to refer to the address of the new big cell. If a merged range of cells
contains a formula, relative references adjust. For more about references, see “Using
cell references in formulas” in Chapter 12.
You can copy, delete, cut and paste, or click and drag big cells as you would any
other cell. When you copy or move a big cell, it replaces the same number of cells at
the destination. The original location of a cut or deleted big cell returns to individual
cells.
You can drag the ill handle of a big cell as you can drag the ill handle of regular
cells. When you do so, the big cell is replicated, in both size and content, replacing all
regular cells in its path. For more about using the ill handle, see “Filling and creating
data series” in Chapter 8.
If you merge cells containing border formatting other than along any outer edge of
the selected range, border formats are erased.
Using template files to store formatting
A template is a model that can serve as the basis for new worksheets. A template can
include both data and formatting information. Template files are great timesavers. They’re
also an ideal way to ensure a consistent look among reports, invoices, and other documents
you tend to create repeatedly. Figure 9-64 shows an example of a template for an expense
report. This worksheet would make a good template because expense reports are used
repeatedly, but each time you want to start with a fresh, clean copy.
Figure 9-64 This template file serves as the basis for creating new expense reports.
Search JabSto ::




Custom Search