Pace and Cap - Sartin Methodology & The Match Up - View Single Post

Ted Craven · 07-31-2009, 10:35 AM

John, thanks for the heads up re the slightly different Paste Special settings in OpenOffice (which is an open-source/free workalike to MS Excel)!

If you don't have a 'create duplicate' menu item in OO, you can just highlight the entire worksheet with Ctrl-A, copy it with Ctrl-C, switch to your newly created worksheet, then Paste with Ctrl-V. All Headers and formulas should copy fine. Rename worksheet Tabs, repeat as needed...

For Excel users, Barb's advice using the built-in Excel duplicate tools works great!

Cheers,

Ted

07-31-2009, 10:35 AM	#3
Ted Craven Grade 1 Join Date: Jun 2005 Location: Nanaimo, British Columbia, Canada Posts: 9,256	John, thanks for the heads up re the slightly different Paste Special settings in OpenOffice (which is an open-source/free workalike to MS Excel)! If you don't have a 'create duplicate' menu item in OO, you can just highlight the entire worksheet with Ctrl-A, copy it with Ctrl-C, switch to your newly created worksheet, then Paste with Ctrl-V. All Headers and formulas should copy fine. Rename worksheet Tabs, repeat as needed... For Excel users, Barb's advice using the built-in Excel duplicate tools works great! Cheers, Ted __________________ RDSS - Racing Decision Support System™