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

Chapter 7. Creating a Worksheet with Excel > Moving and Copying a Worksheet

Moving and Copying a Worksheet

After adding several sheets to a workbook, you might want to reorganize them. You can arrange sheets in chronological order or in order of their importance. You can easily move or copy a sheet within a workbook or to a different open workbook. Copying a worksheet is easier and often more convenient than reentering similar information on a new sheet. If you are moving or copying a worksheet a short distance, you should use the mouse. For longer distances, you should use the Move Or Copy Sheet command on the Edit menu.

Move a Worksheet Within a Workbook

Click the sheet tab of the worksheet you want to move, and then hold down the mouse button.

When the mouse pointer changes to a sheet of paper, drag it to the right of the sheet tab where you want to move the worksheet.

Release the mouse button.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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