• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Part 2. Managing and Viewing Workbooks > Moving or Copying Worksheets

Moving or Copying Worksheets

Right-click the worksheet tab that you want to move or copy, and select Move or Copy from the shortcut menu. The Move or Copy dialog box opens.

Click the down arrow next to the To book field and choose from the open work book to which you want to move or copy the selected worksheet.

In the Before sheet list, click the name of the worksheet in front of which you want the selected sheet to be placed, or choose (move to end).

INTRODUCTION

When Excel inserts a new worksheet, it always places it in front of the currently selected worksheet. If you aren't in the correct worksheet tab before you insert the worksheet, however, you can simply move it. In addition, Excel understands that many times data in one worksheet can be used as a starting point in new worksheets and even other workbooks (or perhaps you need multiple sets of data), so you can copy a worksheet.


TIP

Drag move

You can also click on a worksheet tab and drag it in front of or after another worksheet tab to change its location. This is a lot faster if all you want to do is move around your worksheets.


Click the Create a copy check box if you want to copy the worksheet (as shown here); if your intent is to move the worksheet, simply leave it unchecked.

Click OK.

The worksheet is copied to the new location.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint