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.
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.