Did you know that you can set up multiple Excel spreadsheets in one Workbook all at once? In this example, in one Workbook we want four exact Spreadsheets, one for each team member. Instead of creating them manually, we can create them all at once. We’ll also give you some additional Excel shortcuts along the way!

Set Up the Spreadsheet

  • With your Workbook open, add the number of new Sheets at the bottom by clicking the plus sign. In this example, we want 4 total.
  • Now, go back to the first sheet and click the Sheet tab, then hold down the Shift key and click the additional tabs that were created to highlight them all.

add sheets

  • Next, enter the content in the first spreadsheet and it will be duplicated in each additional one that you have highlighted.

Enter Repetitive Contents with Auto-Complete

If you want a list of repetitive items like A,B,C — 1,2,3 — January, February, March — for example, Excel is smart. You only need to enter the first item and then drag the fill handle up/down or left/right and it will fill in the rest.

For our example, we want the months of the year in the column headings.

  • In a cell type the first item (in this case, January).
  • Mouse over the lower right corner of the cell until your mouse turns into crosshairs and drag it to the right (or left, up, down) and Excel will auto-complete the remaining months of the year.

add months

We can use this with numbering as well.

  • In a cell type the first few numbers (in this case, 1, 2 and 3). TIP: If you just entered “1” and dragged the cell, it would repeat with 1, 1, 1, etc.
  • Highlight the cells with 1, 2 and 3 and mouse over the lower right corner of the bottom cell until your mouse turns into crosshairs. Drag it down (or to the left/right or up) and Excel will auto-complete consecutive numbers in the cells until you release the mouse.

Autofill also works with:

  • Month abbreviations: Jan, Feb, Mar…
  • Days of the week: Sunday, Monday, Tuesday…
  • Days of the week abbreviations: Sun, Mon, Tue…

Once your duplicate sheets are created, you can re-name the tabs to differentiate them.