How to Copy a Tab on a Spreadsheet

Spreadsheet programs are an easy way to keep track of and change important data. Many comprehensive versions of spreadsheet software allow users to create numerous tabs within spreadsheet workbooks. These tabs can be populated with data and charts that are independent of the other tabs in the workbook. By following a few simple steps, you can easily copy the tabs in a spreadsheet.

Step

Open the spreadsheet that contains the tab you want to copy. In this example, a spreadsheet created in Microsoft Excel is used.

...
...

Step

Right click once on the tab that you want to copy and select the "Move or Copy" option. This action will generate a pop up box that will allow you to choose where you want to place the copied tab.

...

Step

Place a checkmark in the "Create a copy" box by clicking once in it.

...

Step

Use the "To book" drop down menu to select the workbook to which you want to copy the tab. The default listing will be the current spreadsheet, but you can choose from other open spreadsheets.

...

Step

Choose an option from the "Before sheet" section to designate where in the workbook you want to insert the copied tab. In this example, the copied tab will be placed at the end of the current workbook. Click once on the "OK" button.

...

Step

View the copied tab, which will appear in the area designated in steps 4 and 5. Please note that the copied tab is named the same as the original with a number "2" in parentheses. To rename the copied tab, or any other, double click in the tab and type over the highlighted text.

Step

Open the iWork Numbers spreadsheet that contains the sheet you want to copy.

Step

Click once on the sheet that you want to copy from the "Sheets" section to the left of the screen.

Step

Click once on "Edit" and select the "Copy" option.

Step

Click once on the sheet that precedes the location of where you want the copied sheet to be placed.

Step

Click once on "Edit" and select the "Paste" option. Numbers will provide the copied spreadsheet with an individual default name. You can change the name of the sheet by double clicking on the sheet in the "Sheets" section and typing over the highlighted text.