Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

In Excel 2007, if you highlight a block of cells and then "Format as Table", it doesn't just apply colors and formatting, it somehow marks those cells as being a table.

Now I want to get rid of the table, but keep all the cells (i.e. keep the data). So I tried clearing the table style and formatting, but Excel still recognizes those cells as being a table. I can tell because:

  • When I select a cell that was in the table, Excel still displays the "Table Tools / Design" tab
  • I cannot merge cells that were in the table <- this is what's annoying me

So, how do I un-table those cells? I want to keep all the cell data and formatting, but have Excel not recognize them as a table.

share|improve this question
up vote 1 down vote accepted
  • Select any cell in the table
  • Click the Design tab on the Ribbon
  • Select Convert to range

Your existing cell formatting will be retained.

share|improve this answer
Exactly what I wanted, thanks! – Joe Apr 22 '10 at 5:40

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.