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

Copy the Sheet

Excel offers several ways to copy a worksheet. The quickest and easiest way is to drag the sheet tab.

Click the tab for the sheet you want to duplicate—in this case, the one we named January— to activate it.

Position the mouse pointer on the sheet tab.

Hold down the Ctrl (Windows) or Option (Mac OS) key and drag the sheet tab to the right.

When the triangle appears between the sheets named January and Sheet2, release the mouse button.

Repeat steps 1–4 to duplicate the worksheet again, placing the copy between January (2) and Sheet2. The new copy is named January (3).

Follow the instructions on page 24 to rename January (2) to February and January (3) to March.

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