Microsoft Office Tutorials and References
In Depth Information
click OK, your custom style appears at the top of the Format As Table gallery in the Custom
Removing the automatic table features
If you like the formatting you get from tables but don’t want or need the special features of
a table, click the Convert To Range button in the Tools group on the Table Tools Design tab.
When you do so, all the special features applied to the selected table are removed, leaving
most of the formatting intact. (Remember, you need to click a cell in the table to display
the Table Tools Design tab.) Figure 9-12 shows the message that appears when you click
Convert To Range.
Figure 9-12 The Convert To Range command removes the automatic table features but leaves
Convert To Range removes the Filter menus from the selected table, discontinues displaying
the Table Tools Design tab, turns off any additional table features (such as automatic cell
banding and totals), and relegates the range formerly known as Table to simple “formatted
cells” status. Any visible table formatting you applied remains (including the totals row), but
the automatic table functionality disappears. Even the banding formats remain, but they
are no longer dynamic or automatic. Converting your table in this way makes sense if you
don’t want to deal with the automatic accoutrements such as Filter menus. This technique
is a great way to take advantage of automatic table-formatting features for cell ranges that
you just want to format uniformly.