User Guide

When you’ve created a visual eect that you want to reuse, you can copy and paste it;
select the table or cells whose eects you want to reuse, choose Format > Copy Style,
select the table or cells you want to format, and then choose Format > Paste Style. You
can also use table styles to replicate formatting you’ve applied to a table, as “Using
Table Styles” on page 111 describes.
Dening Reusable Tables
You can add your own tables to the menu of predened tables that appears when
you click Tables in the toolbar or choose Insert > Table. Reusable tables have the table
style and structure of your choice and can contain content (header text, formulas,
and so on).
To dene a reusable table:
1 Select a table.
2 Dene a table style for the table.
The table style determines the formatting of borders, background, and text in the
table’s cells.
One way to dene the table style is by following the instructions in “Modifying Table
Style Attributes” on page 11 2 and “Copying and Pasting Table Styles” on page 11 3 .
Alternatively, you can apply your customized table structure and content to the
reusable table, but give it the table’s original default style instead of your own.
Step 7 describes how to use this option.
3 Dene the table’s structure.
To resize the table, see “Resizing a Table” on page 48 and “Resizing Table Rows and
Columns” on page 62.
To dene columns and rows, see “Working with Rows and Columns in Tables” on
page 55.
To split or merge table cells, see “Splitting Table Cells” on page 84 or “Merging Table
Cells” on page 83.
4 Add and format any content you want to reuse. See “Putting Content into Table
Cells” on page 75 for instructions. Any formulas you add should refer only to cells in
the table you’re dening.
5 Choose Format > Advanced > Capture Table.
6 Type a name for the table.
7 Select “Use the default style from the document” if you want the table to be styled
using the default table style in eect when the table is added to the spreadsheet.
Otherwise the table style used is the one you dened in step 2.
8 Click OK.
50 Chapter 3 Using Tables