Microsoft Office Tutorials and References
In Depth Information
Excel converts your
data to a table.
6
7
The Table tools become
available.
l
Each column has a
drop-down arrow that
you can click to sort
and filter.
Note: Refer to the other
tasks in this chapter to
learn how to sort and
filter.
l
6
Click the Design tab.
7
Click Total Row
(
changes to
).
l Excel places a total at the end of your
table.
8
Click a field in the Total row.
A down arrow appears next to the field.
9
Click the down arrow and then select how
you want to total the column.
Excel totals your column.
9
8
9
Did You Know?
An Excel table is primitive when compared with
the data management capabilities of Access
or server-based databases. You can create
worksheets in Excel and then export them into
Access, where you can maintain and incorporate
the sheets into a set of data tables. For more
information, see Task #92.
Did You Know?
You can convert a table back to a regular range
of cells. Click anywhere in your table, click the
Design tab, and then click Convert to Range in
the Tools group. At the prompt, click Yes. Excel
converts the table to a normal range and
removes the drop-down arrows.
Chapter 4: Manipulate Records
105
 
Search JabSto ::




Custom Search