Excel remove table formatting Solved

Question

Hello,  In Excel, I would like to know how to remove the formatting from a table. I couldn't find the command.  Thank you  pépé

Raph · Accepted Answer

Hello,

Personally, I would suggest this:

Table tools -> Create -> -> Convert to range (in the tools section of the ribbon)
Excel will ask you to confirm the conversion to a "normal" range
click OK
and then you are once again in control of your table!

Mike-31 · Answer

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)

pépé35530 · Answer

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

pépé35530 · Answer

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

gbinforme · Answer

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

Mike-31 · Answer

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)

pépé35530 · Answer

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é

trinidad654 · Answer

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

Balthus51 · Answer

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.

Excel remove table formatting

9 answers

Many f a i offer a €2 subscription and the card €1"

My packard bell laptop screen is black at startup.

Lost session password

How to add a melody to a phone number

Searching for a french tv movie from the late 90s to early 2000s

Second screen resolution inaccessible

Android smartphone hacked

Ami, the app to centralize your administrative processes

Texture issues in enshrouded

Your smartphone, an overlooked universal remote