1.3 Some Worksheets Require Copying and/or Duplication

Because each TeamWorks deployment is unique, the instructions in this guide tell you to copy rows and worksheet sections to match your planning needs.

For example, within the Use Case Scenarios sheet the Use Case section is for one TeamWorks use case. You should copy the entire section as many times as needed to describe all of the use cases within your organization.

1.3.1 Adding Rows in Worksheet Sections

To add additional rows, do the following:

  1. Open the TeamWorks Planning Worksheets spreadsheet and click to the applicable tab at the bottom.

  2. Make sure that View > Headings is selected.

  3. Right-click the row number indicator of the row or rows you want to copy and select Copy.

  4. Right-click the selection and select Insert Copied Cells.

    A new row is inserted above the row you selected.

  5. Repeat the process until you have as many rows as needed.

  6. Save your worksheet.

1.3.2 Making a Copy of a Worksheet Section

IMPORTANT:Although it is possible to copy sections using various methods, this is the simplest way that we’ve found.

Make sure you always do the following:

  • Right-click the row-number indicators in the following procedure, not individual cells.

  • Copy all of the rows in a section. Otherwise, formulas used for estimating disk space and so on might become invalid.

  1. Open the TeamWorks Planning Worksheets spreadsheet and click the applicable tab at the bottom.

  2. Make sure that View > Headings is selected.

  3. Do the following:

    1. Click the row-number indicator for the first row of the section.

    2. Press and hold the Shift key.

    3. Click the row-number indicator of the blank row following the last row.

    4. Right-click any row-number indicator within the selection.

    5. Select Copy.

  4. Right-click any row-number indicator and select Insert Copied Cells.

    The appropriate number of rows is inserted above what you had previously selected.

  5. Save your worksheet.