Copy and paste tables from a sheet to another mantaining format, cells and formula the same.

Copper Contributor

Hello guys, as you see in the subject I am having problem copying and pasting tables from a sheet to another on Excel because it changes the formulas and the format of the tables. could someone help me please? Thank you so much guys!

1 Reply
Hi

When you pasting to another sheet, use (Keep Source Formatting(K)) whenever you paste.