Excel remove table formatting

Good evening,

I think I've found the solution:

click in the previously formatted table
Activate the tab: Table Tools
Click on Quick Style and at the very bottom click on Clear.

This last command does not appear when the initial table formatting command is activated.

See you later

grandpa

Hello,

With Excel 2010, you need to go to the Table (Design) tab, tools, 'Convert to Range'.
It removes the table formatting while keeping the data.

Source:
https://www.microsoft.com/fr-fr/microsoft-365/mac/microsoft-365-for-mac?rtc=1

Hi,

What conditional formatting, cell ... for which version of Excel

See you +
Mike-31

A problem without a solution is a poorly posed problem (Einstein)

Hello,

the gbinform solution doesn't seem to work because the "clear" box is not active in that case.
Going through "table tools" and "quick style" and "clear", no problem there.

Thanks to both of you.

pépé

Re..

I'm using Excel 2007 and I'm using the "Format as Table" option.
This procedure works well. But I can't remove it to go back to a table without formatting.

Grandpa

Hello

When you are with the selected formatting, just click on the arrow down "more" all the way to the right, and in the shape presentation, choose clear at the bottom.
--

Always zen

Hi,

You will find what you are looking for at this link, and certainly better explained than I would do.

http://office.microsoft.com/en-us/excel/HA100137691036.aspx?pid=CH100648351036

See you!
Mike-31

A problem without a solution is a poorly posed problem. (Einstein)

In Excel 2003, select the entire sheet or just the cells from which you want to remove the formatting. Then go to Edit, Clear, Formats.