Changing a table to a range

You may occasionally choose to take a data table…and return it to the range that it was.…The primary reason you might do this is that you want…to use a command like subtotals that's not available in the table.…If I go to the data tab, and I wanted to subtotal That's not available.…It's turned off.…And the reason is, it's not compatible with formatted tables.…So if…that were the case, I can say okay, here's what I'm going to do.…I'm going to right-click on the table.…

I'm going to go to Table and choose Convert To Range.…Now when I do this, what it's going to do is change it to a range.…But it didn't say unformat the table.…All of my formatting still here, and now I could…go back to the home tab and manually change it.…But there's an easier way. Let's undo this and…start again.…It's once again a table, I'm going to go to the Table Tools Design tab…and I'm going to get rid of my total row because I really don't want it afterwards.…

And I'm not going to say OK. Let's choose a table style…that's simple, that has no style at all. Now I could have also chosen this one.…