Archive of Mr Excel Message Board

Back to General Excel archive index
Back to archive home

how do i copy sheets?

Posted by Stan Murgolo on September 05, 2001 10:49 AM

how do i copy sheets...lets say there is sheet 1,2,3 and i want to add sheet four how do i do that? I want to copy sheet 3 i guess and just make the changes but i can t seem to copy sheet 3 and make it into sheet 4 ...how is this done? Thanks

Re: how do i copy sheets?

Posted by Keith on September 05, 2001 11:16 AM

Hey Stan,

You can go to "Insert" on the menu bar and select "Worksheet." Then, go to the sheet you want to copy, click the uppermost, leftmost square. This will select the whole sheet. Then, right click over the sheet and select "Copy" from the right click menu. Then, select the tab of the new sheet and right click in cell A1. Select "Paste" from the right click menu and the sheet will be pasted exactly as you copied it.

Hope this helps...
~Keith

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.