1.2 Some Worksheets Require Copying and/or Duplication

Because each Filr 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 Filr use case. You should copy the entire section as many times as needed to describe all of the use cases within your organization.

1.2.1 Adding Rows in Worksheet Sections

To add additional rows, do the following:

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

  2. Right-click a row number indicator and select Insert Rows Above.

    A new blank row is inserted above the row you selected—red highlight below.

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

  4. Save your worksheet.

1.2.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 Filr Planning Worksheets spreadsheet and click the applicable tab at the bottom.

  2. Make sure that the View > Column and Row Headers option 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 Rows Above.

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

  5. Right-click any row-number indicator within the selection and select Paste.

    A copy of the section appears in the newly inserted rows.

  6. Save your worksheet.