Microsoft Office Tutorials and References
In Depth Information
Chapter 19: Communicating Data Visually
if each row contains information about an employee, the columns can contain data such as
name, employee number, hire date, salary, department, and so on. Tables typically have a
header row at the top that describes the information contained in each column.
You must tell Excel to convert a range of data into an “ofﬁ cial” table. You do this by
selecting any cell within the range and then choosing Insert
Table. When you
explicitly identify a range as a table, Excel can respond more intelligently to the actions
you perform with that range. For example, if you create a chart from a table, the chart will
expand automatically as you add new rows to the table. And if you enter a formula into a
cell, Excel will propagate the formula to other rows in the table. Figure 19.1 shows a range
converted to a table by choosing Insert ➪ Tables ➪ Table. Notice the drop-down list arrows
at the top.
An Excel table
What’s the difference between a standard range and a table? With a table:
Activating any cell in the table gives you access to the Table Tools ➪ Design
contextual tab on the Ribbon (see Figure 19.2).