Worksheet databases

Generally, a rectangular range of data that contains column headers can be considered a worksheet database.

NEW Excel 2007 enables you to specifically designate a range as a table. Select any cell in your rectangular range of data and choose Insert Tables Table. Using a table offers many advantages: an automatic summary row at the bottom, easy filtering and sorting, auto-fill formulas in columns, and simplified formatting. In addition, if you create a chart from a table, the chart expands automatically as you add rows to the table.

Particularly useful is working with columns of data in a table. Each column header is actually a drop-down list that contains easy access for filtering or sorting (see Figure 2-24). Table rows that don't meet the filter criteria are temporarily hidden.

■ U.S. npicullyrBl jipprtir Friiim-twH w]in. by rrnimnri.ly grnnji ■nH Ihaha, FY JWE-fCOS

■ U.S. npicullyrBl jipprtir Friiim-twH w]in. by rrnimnri.ly grnnji ■nH Ihaha, FY JWE-fCOS

Figure 2-24: Excel's new table feature makes it easy to sort and filter rows.
0 0

Post a comment