Page 139 - Excel 2007 Bible
P. 139

10_044039 ch06.qxp  11/21/06  10:57 AM  Page 96
                                    Part I
                                              Getting Started with Excel
                                                       Excel 2003 introduced a rudimentary version of the table feature. In that version, tables were
                                          NOTE
                                           NOTE
                                                       known as lists. The implementation in Excel 2007 is much better.
                                             Figure 6.1 shows a range of data that has not yet been converted to a table. Notice that this range corre-
                                             sponds to the description I provide earlier: It’s a range of structured data with column headers. In this
                                             example, each row contains information about a single real estate listing. The range has 10 columns and
                                             125 rows of data (plus a descriptive header row).
                                        FIGURE 6.1
                                      This range of data is a good candidate for a table.
                                             Figure 6.2 shows the range after I converted it to a table by choosing Insert ➪ Tables ➪ Table.
                                        FIGURE 6.2
                                      An Excel table.


























                                      96
   134   135   136   137   138   139   140   141   142   143   144