up vote 4 down vote favorite
share [g+] share [fb]

I've used the new Table Formatting option in Excel 2007. Now I can't remove it. I've dragged the little blue square up to the last cell on the top left, but it just won't go any further. In fact it just won't go at all.

Clear all doesn't remove it. What does? I want my table back! I'm not a beginner with Excel, but this little annoyance has made me feel like on.

Surely there must be some way to remove table format without deleting something or clearing all!

Thanks Mike

link|improve this question
89% accept rate
feedback

3 Answers

up vote 3 down vote accepted

"Convert to Range" should convert it to normal ranges. Right click on a cell in table and select Table -> Convert to Range. You would need to remove the formatting manually.

link|improve this answer
Finally got around to trying this and it works. Many thanks for your insight. – Mike May 10 '10 at 11:15
feedback
up vote 2 down vote

Try selecting the entire sheet (click box with the arrow in to the left of "A", and above "1") and then try clear all again.

link|improve this answer
But I don't want to lose my data! If I clear all I imagine that's what's going to happen. – Mike Apr 29 '10 at 14:21
No no, I mean the clear all formatting :). Make a copy of the file first if you think we might be talking about two different options though! – user35557 Apr 29 '10 at 14:31
1  
Alternativley hit Ctrl+A, Ctrl+C, open a new worksheet, right click cell A1, click paste special, click "Values" and click ok. Should give you all your data with no formatting. – user35557 Apr 29 '10 at 14:34
feedback
up vote 2 down vote

I was able to pull this off by highlighting the entire table and then right click and choose Format Cells. Then go through and remove colors and borders and any filling and you will effectively remove the table and keep all data intact.

link|improve this answer
But you've only removed the look of the table. The actual table is still there. – Mike May 7 '10 at 7:50
Did you try Right click on the table, click Table > Convert to Range as Shaji recommends? – nicorellius May 7 '10 at 14:46
feedback

Your Answer

 
or
required, but never shown
discard

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