Copying A Spreadsheet

[Guest]

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!

 

[Dave O]

One quick workaround for this is to right-click the tabname at the
bottom of the screen, and select "Move or Copy". Select "Create Copy"
and highlight the relative tab location you prefer. This will make an
exact duplicate of a sprdsht, maintaining all formats, column widths,
headers, footers, etc. You'll need to delete data, tho. Hope this is
useful for you!

 

[Alan]

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.

 

[Guest]

Thank you!

 

[Guest]

Thank you!

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.