Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .