Removing table design

I would like to remove a table design so that it's just numbers in columns and rows, but can't find any function to clear the design. I find that in order to copy and paste many numbers in columns an...

excel

SergeiBaklan
Feb 13, 2017
Hi Claudia,

Here are two questions.
1) To clean table formatting (or any range selected) select entire table (Ctrl-A) and in Ribbon click Clear Format from Clear drop-down menu (Editing group, near Auto Sum).
2) To copy/paste without formatting use Paste Special from Ribbon, or Ctrl-Alt-V, or right mouse click, or simple paste and drop-down menu after the pressing Ctrl button (same result, just different ways to initiate the paste menu).

If i understood your questions correctly...

SergeiBaklan

Diamond Contributor

Feb 13, 2017

Hi Claudia,

Here are two questions.

1) To clean table formatting (or any range selected) select entire table (Ctrl-A) and in Ribbon click Clear Format from Clear drop-down menu (Editing group, near Auto Sum).

2) To copy/paste without formatting use Paste Special from Ribbon, or Ctrl-Alt-V, or right mouse click, or simple paste and drop-down menu after the pressing Ctrl button (same result, just different ways to initiate the paste menu).

If i understood your questions correctly...

Claudia Schloss
Copper Contributor
Feb 13, 2017
Thank you! So easy, why wouldn't that be in Help - maybe I didn't ask the question correctly...

Forum Discussion

Removing table design

Resources