You can use the Move or Copy Sheet command to move or copy entire worksheets (also known as sheets), to other locations in the same or a different workbook. You can use the Cut and Copy commands to move or copy a portion of the data to other worksheets or workbooks.
What do you what to do?
Move or copy worksheets to another location in the same workbook
1. Select the worksheets that you want to move or copy. If you want to move or copy more than one, press and hold the Ctrl key, and then click the tabs of the sheets you want to copy.
Note When multiple worksheets are selected, [Group] appears in the title bar at the top of the worksheet. To cancel a selection of multiple worksheets in a workbook, click any unselected worksheet. If no unselected sheet is visible, right-click the tab of a selected sheet, and then click Ungroup Sheets on the shortcut menu.
2. Select Home > Format > Move or Copy Sheet. Or, you can also right-click a selected sheet tab, and then click Move or Copy.
3. In the Move or Copy dialog box, click the sheet that should be after the moved or copied sheet.
4. To copy the sheets instead of moving them, in the Move or Copy dialog box, select the Create a copy check box.
When you create a copy of the worksheet, the worksheet is duplicated in the workbook, and the sheet name indicates that it is a copy — for example, the first copy that you make of Sheet1 is named Sheet1 (2).
Guest Posters: 9
Most Users Ever Online: 25
Currently Browsing this Page: