Microsoft Office Tutorials and References
In Depth Information
Creating a table
h Tables support calculated columns. A single formula in a column is automatically
propagated to all cells in the column.
h Tables support structured references. Rather than use cell references, formulas can use
table names and column headers. (See Tip 160.)
h When you move your mouse pointer to the lower right corner of the lower right cell, you
can click and drag to extend the table’s size, either horizontally (add more columns) or
vertically (add more rows).
h Selecting rows and columns within the table is simplified.
Figure 158-1: When a table is selected, Excel displays a contextual tab named Table Tools.
Using a table has a few limitations:
h For some reason, when a workbook contains at least one table, Excel doesn’t allow you
to use the custom views feature (choose View Workbook Views Custom Views).
h You can’t insert automatic subtotals within a table (by choosing Data Outline
Subtotal).
Creating a table
Most of the time, you create a table from an existing range of data. Excel also allows you to
create a table from an empty range so that you can fill in the details later. The following instructions
assume that you already have a range of data that’s suitable for a table:
 
Search JabSto ::




Custom Search