Moving or copying worksheets in Microsoft Excel 2019

There are a few ways to arrange worksheets in a workbook. Often wheninserting worksheets, they land up in the wrong position (order), andyou need to move them to another location in the workbook.

  1. Click on the Sheet tab of theworksheet you wish to move.
  1. Hold down the left mouse button on the Sheet tab and drag it to another location. Apage icon will appear above the mouse pointer, and, as you drag, alittle black pointed-down arrow will guide you as you move along thesheets. Let go of the mouse at the location you would like toplace the worksheet, as illustrated in the followingscreenshot:
ms office 629
  1. Click on the Sheet tab of theworksheet you wish to move.
  2. Click on the Format drop-down listfrom the Cells group of the Home tab.
  3. Choose Move or Copy Sheet… .
  4. Click on a worksheet name to place your sheet before it.
  5. Click on OK to confirm. The sheetmoves to the new location.

Or

  1. Right-click on the Sheet tab ofthe worksheet you would like to move.
  2. Click on Move or Copy fromthe shortcut menu. Click on a sheet name to place your sheet beforeit.
  3. Click on OK to confirm. The sheetmoves to the new location.

To copy worksheets, follow these steps:

  1. Click on the Sheet tab of theworksheet you wish to copy and move to another location within theworksheet.
  2. Hold down the Ctrl key on your keyboard.
  3. Click on the Sheet tab and, whilekeeping the left mouse button depressed, drag the sheet to anotherlocation.
  4. A page icon will appear above the mouse pointer with a + sign whileyou are dragging—this indicates that you are copying the sheet.
  5. As you drag, a little black pointed-down arrow will guide you as youmove along the sheets, as illustrated in the followingscreenshot:
ms office 829
  1. Let go of the mouse at the location you would like to place theworksheet.
  2. You will notice that the worksheet name is the same as the sheet youhave copied, except that it has a bracket enclosing the number 2,indicating that it is the worksheet copy.

To move or copy a worksheet to another workbook, follow thesesteps:

  1. To move or copy a sheet from an existing workbook to adifferent workbook, right-click on the Sheet tab and select Move or Copy.
  2. The Move or Copy dialog boxopens.
  3. At the top of the dialog box, choose (new book)from the drop-down list.
  4. Click to select Create a Copy atthe bottom of the dialog box, should you wish to send a copy to the newworkbook, or leave this unchecked to move the worksheet from the currentworkbook to a new workbook.
  5. Click on OK to confirm. The sheetremains in the current workbook and is also copied to the location youselected.

Leave a Comment