Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Right click on the destination and select Paste Special..., then make sure Formats is not selected.

Right click on the destination and select Paste Special..., then make sure Formats is not selected.

Edit: If you are copying from something that is not a spreadsheet, first add a blank sheet to your spreadsheet document, paste the copied data into that sheet. Copy the cells in that spreadsheet and then paste special to your template. Then you can remove the extra sheet that was added.

It might be possible to write a macro to make this easier. First let me know if this works for you.