Table Formatting in Excel 2007: How do I remove it?
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!
Solution 1:
"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.
Solution 2:
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.