Microsoft Office Tutorials and References
In Depth Information
To Remove Automatic Subtotals from a Table
The following steps show how to remove the subtotals and convert the range back to a table.
• Click Subtotal on the Ribbon to
display the Subtotal dialog box
• Click the Remove All button.
• Select the range A8:J21 and then
click the Home tab on the Ribbon.
• Click the Format as Table button
on the Ribbon and then click the
Custom quick style in the Format
as Table gallery.
• When Excel displays the Format
As Table dialog box, click the OK
1. Press ALT + A , B , ALT + R
To Sort a Table Using a Column Heading List
The following steps sort the Silver Photography Accessories Sales Rep table into
its previous sort order, sorted in ascending sequence by hire date.
specialists use the ﬁ ll
handle to create a series
in an additional ﬁ eld in
the list that is used only
to reorder the records
into their original
1 Select cell A9 (or any cell in the table) to make the table active.
2 Click the Hire Date arrow and then click Sort Oldest to Newest in the Hire Date AutoFilter
menu to sort the table in ascending sequence by hire date.