Forum Discussion
Solved
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 and rows it's easier to do when it's not in a table function. When I tried copying and pasting numbers from an existing table, it also copied the color scheme and overlayed that on my new table which was impossible for me to correct. I'm a basic user, so please be patient with me. :)
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...
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...
Thank you! So easy, why wouldn't that be in Help - maybe I didn't ask the question correctly...
