Jan 13 2021 06:20 PM
Could someone tell me how I can copy and paste both cell content and it's formatting from one worksheet to another? It's simple to copy data, but it seems like the formatting (specifically merged cells, column widths, outlining) doesn't follow.
Jan 14 2021 03:15 AM
If you click the lower half of the Paste button, you'll see several options:
You can see what each option does by hovering the mouse pointer over it.
There are options to paste Values and to paste Formatting.
Clicking Paste Special... offers even more options, including pasting Column Widths.