Thank you!

"Alan" wrote:

Yes you can.
Copy the entire worksheet by clicking the box in the top left corner above
row 1 and to the left of cloumn A.
Right click Copy, in the new worksheet click A1 and right click Paste.
This will give a carbon copy with the exception of 'Tools' 'Options' items
like 'Show Zero Values' and 'Show Gridlines' etc, and any 'Freeze Panes' you
may have selected,
Regards,
Alan.
"sparklydaisy" wrote in message
...
Is it possible to copy a spreadsheet and have the column width settings
stay
the same as set on the original spreadsheet?

What I am doing is inserting blank worksheets into a spreadsheet and then
copying the same form into the page. It is a bit of a pain to have to
manually set up all the column widths on each sheet.

If anyone has a solution it would be much appreciated. I am using the
2002
version.

Thank you!