software






 

Question by  Ellen48 (40)

How do you duplicate a sheet in excel?

I would like all information transferred to a new sheet or workbook in excel.

 
+7

Answer by  knightmare (1231)

There are a few ways. If you right-click the sheet name there should be a move or copy option that pops up. Select this and you'll get a dialog box. At the bottom should be a check box with "Create a Copy" on it. Select that and press OK. You can also select all cells, copy/paste into a new sheet.

 
+6

Answer by  dantec (14)

At the bottom left corner of Excel, where the sheet numbers are, right-click on the sheet you want to copy from and select "Move or Copy... ". In the dialog box, select the sheet you want to copy to. Check the check box that says "Create a Copy". Then click OK.

 
+6

Answer by  Raghu33 (6)

By holding down the CTRL key while dragging the sheet tab of the original. As you drag, you will notice a small sheet icon with a plus sign (indicating copying) and a small black arrow (indicating where the duplicated sheet will be inserted). Let up on the mouse button and CTRL key and you will have an identical copy.

 
+6

Answer by  wwsensei (12)

At the bottom of the workbook you will see a set of worksheet tabs. Right click on the worksheet tab to copy and select the Move or Copy option. Select the default copy location when prompted. If your worksheet was named "Results" the copied worksheet would be titled "Results (2)".

 
You have 50 words left!