holding worksheet formats when copying/pasting


G

Guest

When I copy a worksheet into a new worksheet, the columns, rows, fonts etc do
not remain the same as the original format which causes us to have to
manually resize the new worksheet to match the existing one. Does anyone have
a solution? thanks
 
Ad

Advertisements

G

Guest

This might not retain every thing you want moved over but you can 'copy' the
1st sheet and then 'paste special' ... 'column widths' to get the width info,
then copy your data over.
 
Ad

Advertisements

A

aquigley

Try copying and "Paste Special" (by right clicking on a cell in the new
worksheet and selecting 'paste special').
In the Paste Special window select "Format" and "OK" to apply it.
All your formats should be preserved.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top