Free help with homework

Why join Brainly?

  • ask questions about your assignment
  • get answers with explanations
  • find similar questions


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 selected worksheet data to other worksheets or workbooks, or you can drag data between worksheets in different workbooks.

What do you want to do?

Move or copy worksheets to another location in the same workbook

Move or copy worksheets to a different workbook

Move or copy data to another worksheet or workbook

Drag data between workbooks in Excel

Move or copy worksheets to another location in the same workbook

It's easy to move or copy a whole worksheet (or sheet) to another location in a workbook. However, be aware that calculations or charts that are based on worksheet data might become inaccurate if you move the worksheet. Similarly, if a moved or copied worksheet is inserted between sheets that are referred to by a 3-D formula reference, data on that worksheet might be unexpectedly included in the calculation.

Select the worksheets that you want to move or copy.

How to select worksheets

To select

Do this

A single sheet

Click the sheet tab.

If you don't see the tab that you want, click the tab scrolling buttons to display the tab, and then click the tab.

Two or more adjacent sheets

Click the tab for the first sheet. Then hold down Shift while you click the tab for the last sheet that you want to select.

Two or more nonadjacent sheets

Click the tab for the first sheet. Then hold down Ctrl while you click the tabs of the other sheets that you want to select.

All sheets in a workbook

Right-click a sheet tab, and then click Select All Sheets on the shortcut menu.

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

Keyboard shortcut To move to the next or previous sheet tab, you can also press Ctrl+Page Up or Ctrl+Page Down.

On the Home tab of the ribbon at the top of the workbook, in the Cells group, click Format, and then under Organize Sheets, click Move or Copy Sheet.

TIP: You can also right-click a selected sheet tab, and then click Move or Copy.

In the Move or Copy dialog box, in the Before sheet list, do one of the following:

Click the sheet before which you want to insert the moved or copied sheets.

Click move to end to insert the moved or copied sheets after the last sheet in the workbook and before the Insert Worksheet tab.

To copy the sheets instead of moving them, in the Move or Copy dialog box, select the Create a copy check box.

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


To move sheets in the current workbook, you can drag the selected sheets along the row of sheet tabs. To copy the sheets, hold down Ctrl, and then drag the sheets; release the mouse button before you release the Ctrl key.

To rename the moved or copied worksheet, right-click its sheet tab, click Rename, and then type the new name in the sheet tab. (Alternatively, you can double-click the sheet tab and then edit the name.)

To change the color of the sheet tab, right-click the sheet tab, click Tab Color, and then click the color that you want to use.

Top of Page

Move or copy worksheets to a different workbook

NOTE: Worksheets that you move or copy to another workbook will use the theme fonts, colors, and effects that are applied to the destination workbook.

To move or copy worksheets to another workbook, make sure that the target workbook is open in the same instance of Microsoft Excel.

NOTE: You cannot move or copy worksheets between workbooks that are
0 0 0
thanx but i want to move the all entire data to next selected sheet again n again like if have row that is age n next row that is name now what to move the data what i type in the row like name neeraj age 22 for example i type these two entry in the particular place now i want to move all the data selected sheet
with a button
The Brain
  • The Brain
  • Helper
Not sure about the answer?
Learn more with Brainly!
Having trouble with your homework?
Get free help!
  • 80% of questions are answered in under 10 minutes
  • Answers come with explanations, so that you can learn
  • Answer quality is ensured by our experts