Microsoft Office Tutorials and References
In Depth Information
old MOD function approach, these table-banding options are smart enough to survive just
about any kind of editing, including inserting and deleting rows and columns.
For more information, see “Formatting conditionally” and “Creating conditional formatting
rules” later in this chapter.
You can insert and delete rows in a table, even at the edges, and the table automatically
does the right thing with formats and formulas. Another great feature of tables is that you
can make them bigger just by dragging. As Figure 9-8 shows, the cell in the lower-right
corner of the table contains a small triangular indicator (similar to a cell comment indicator)
that you can drag horizontally or vertically to increase (or decrease) the size of the table.
Figure 9-8 Drag the lower-right corner of a table to make it bigger.
Here’s another handy feature of tables that makes formatting easier, but also makes it
easier to modify the structure of the table, as well. In Figure 9-8, you’ll notice that the
formatting of the last column moved from column G to column J after dragging the table. Last
Column is one of the options on the Table Tools Design tab. When you select this option, it
doesn’t matter where the last column happens to be located; even if you keep adding and
subtracting columns, the last column table format is always applied to the last column in
the table. You can turn off the last column format using the eponymous check box on the
Table Tools Design tab.
You’ll also notice in Figure 9-8 that the Total By Month formulas in column G are now
rather ill-placed in the table. Tables help make this an easy ix as well. Simply select cells
G4:G16, click the selection border, and drag them to the right. Normally, when moving cells
to a new location on a worksheet, you hold down the Shift key while dragging so that they
are inserted in the new location rather than pasted over existing data. But when dragging
cells around inside a table, you don’t need to hold the Shift key, just drag; the selected cells
become a large I-beam insertion point, as shown in Figure 9-9. When the insertion point is
where you want it, release the mouse button. (You might need to adjust the formulas,
however. For more information, see Chapter 12, “Building formulas.”)