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

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