Move or copy worksheets or worksheet data | MS Excel 2016 or old version | Forum

Log In

Please consider registering

— Forum Scope —

— Match —

— Forum Options —

Min search length: 3 characters / Max search length: 84 characters

Register Lost password?
Move or copy worksheets or worksheet data
14 Posts
November 1, 2016 - 3:38 pm

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).

Forum Timezone: UTC 8
All RSS Show Stats

Top Posters:

Ramil Castaneda: 2

Forum Stats:

Groups: 3

Forums: 17

Topics: 16

Posts: 25


Member Stats:

Guest Posters: 9

Members: 2183

Moderators: 0

Admins: 3

Most Users Ever Online: 25

Currently Online:
7 Guest(s)

Currently Browsing this Page:
1 Guest(s)