Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Copying A Spreadsheet
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! |
#2
|
|||
|
|||
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! |
#3
|
|||
|
|||
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! |
#4
|
|||
|
|||
Thank you!
"Dave O" wrote: 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! |
#5
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Spreadsheet Dilemma | Excel Discussion (Misc queries) | |||
Copying a spreadsheet with macros | Excel Worksheet Functions | |||
copying data from Excel spreadsheet to another | Excel Discussion (Misc queries) | |||
Copying spreadsheet with fonts and patterns | Excel Discussion (Misc queries) | |||
Copying an Excel spreadsheet to a Word document | Excel Discussion (Misc queries) |