Removing Tables
Typically, you’ll want to keep Tables in place in your workbooks, but sometimes you might change your mind. Or you might find that the Table feature conflicts with another feature, such as Custom Views (see Chapter 8, Custom Views). Removing a Table can be as simple as choosing Table Design | Convert to Range; if you do so prematurely, you might solve one problem and create new ones. Here’s what I recommend:
- Select any cell within a Table and then activate the Table Design tab of Excel’s Ribbon.
- Choose Clear at the bottom of the Table Styles gallery.
Nuance
It’s important to remove an existing Table Style before you convert a Table into a normal range of cells. Otherwise, you or another user might mistakenly rely on automation that isn’t available in a normal range of cells masquerading as a Table. See the Selecting a portion of a Table section for more details.
- Optionally, you can clear the Total Row...
