Copy & Paste data & formatting

%3CLINGO-SUB%20id%3D%22lingo-sub-2059202%22%20slang%3D%22en-US%22%3ECopy%20%26amp%3B%20Paste%20data%20%26amp%3B%20formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2059202%22%20slang%3D%22en-US%22%3E%3CP%3ECould%20someone%20tell%20me%20how%20I%20can%20copy%20and%20paste%20both%20cell%20content%20and%20it's%20formatting%20from%20one%20worksheet%20to%20another%3F%26nbsp%3B%20It's%20simple%20to%20copy%20data%2C%20but%20it%20seems%20like%20the%20formatting%20(specifically%20merged%20cells%2C%20column%20widths%2C%20outlining)%20doesn't%20follow.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2059202%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2060318%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%20%26amp%3B%20Paste%20data%20%26amp%3B%20formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2060318%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F928446%22%20target%3D%22_blank%22%3E%40TimberTom%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20you%20click%20the%20lower%20half%20of%20the%20Paste%20button%2C%20you'll%20see%20several%20options%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22S0058.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F246362iCA281DA8D7EC9439%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22S0058.png%22%20alt%3D%22S0058.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20can%20see%20what%20each%20option%20does%20by%20hovering%20the%20mouse%20pointer%20over%20it.%3C%2FP%3E%0A%3CP%3EThere%20are%20options%20to%20paste%20Values%20and%20to%20paste%20Formatting.%3C%2FP%3E%0A%3CP%3EClicking%20Paste%20Special...%20offers%20even%20more%20options%2C%20including%20pasting%20Column%20Widths.%3C%2FP%3E%0A%3CP%3E%E2%80%83%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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.

1 Reply

@TimberTom 

If you click the lower half of the Paste button, you'll see several options:

 

S0058.png

 

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.