How to convert a table back to plain text?

JenniferMurphy

Well-known Member
Joined
Jul 23, 2011
Messages
2,687
Office Version
  1. 365
Platform
  1. Windows
Is there a way to convert a table back to plain text eliminating all the table formatting? That is, eliminate the fill colors, but preserve the number formatting.

I know I can convert it to a normal range by right-clicking in the table and then selecting Table and then Convert to Range, but that preserves all of the table formatting.

I also know that I can select the entire range and remove the fill, but that appears to make the headers disappear. They are actually there, but just coded as white. So I then have to select that row and change the character color to black.

Is there a way to do all that with one action?

Thanks
 

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off
I don't think it can be done in a single button press / format but How about
  1. Select any cell in the Excel table.
  2. Click the Design tab (this is a contextual tab and only appears when you click any cell in the table)
  3. In Table Styles, click on the More icon (the one at the bottom of the small scrollbar.
  4. Click on the Clear option.
 
Upvote 0
Solution
I don't think it can be done in a single button press / format but How about
  1. Select any cell in the Excel table.
  2. Click the Design tab (this is a contextual tab and only appears when you click any cell in the table)
  3. In Table Styles, click on the More icon (the one at the bottom of the small scrollbar.
  4. Click on the Clear option.
Excellent. I would add to your procedure to do that first and then convert the table.
  1. Select any cell in the table.
  2. Click the Table Design tab (this is a contextual tab and only appears when you click any cell in the table)
  3. In Table Styles, click on the More icon (the one at the bottom of the small scrollbar.
  4. Click on the Clear option.
  5. Right-click any cell in the table.
  6. Select Table and then Convert to Range.
Thank you very much!
 
Upvote 0

Forum statistics

Threads
1,224,266
Messages
6,177,541
Members
452,782
Latest member
ZCapitao

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top