Audience: Planners who enter data in sheets.
In modeled sheets, you add new rows to add new records. You can also split rows in modeled sheets. For example, in a personnel sheet, an employee may split their time between departments. Split the employee record, to allocate the resource by department.
In standard sheets, add splits to add rows. Splits break down data in further categories. For example, you have contributing factors for the Travel Expense data, including trade shows, seminars, speaking opportunities, and training expenses. Create splits to add as many lines as necessary to accommodate the travel expense. These splits roll up to the total travel expense account.
In cube sheets, add rows to expose otherwise suppressed rows. For example, if you have suppressed all rows with zeros and blanks, and you need to add data to one of those rows, adding a row reveals only the specified row, keeping the rest suppressed.
Before You Begin
How You Get There
Add Rows in Modeled Sheets
- Click Add Row from the toolbar.
- Right-click anywhere on the sheet and click Add Row.
- Right-click on any row and click Copy Row. The data of the whole row copies into a new row at the bottom of the sheet.
- Highlight multiple cells across rows, right-click and select Add x Rows or Copy x Rows (x being the number of rows selected). The same number of blank new rows, or copied rows, appear at the bottom of the sheet.
Update the data for each editable cell in the new row and save the sheet. New rows appear as the last visible row in the sheet. After you save, you may not see new rows if your filters hide them.
Add Splits in Modeled Sheets
Available if your admin enabled this setting.
To add splits, right-click on any cell of the row or its existing splits. Then, click Split Row. A new split appears below the parent row, or below the last split. Some cells are editable and some are read-only copies of the parent row.
Delete Rows or Splits
In plan versions:
- Click on a row or multiple rows and click Delete Row from the toolbar.
- Right-click on a row or multiple rows and click Delete Row or Delete x Rows.
If you delete a row with splits, you delete all its splits too.
In actuals versions: you can delete splits only by erasing actuals. See Erase Actuals.
Add Splits in Standard Sheets
- Click in any cell in the same row, or any cell in the original row's splits.
- Right-click > Add Split, or from the toolbar, click Add Split .
- Enter the split name or leave blank and click OK.
- Save your sheet.
Notice how the original row is now a read-only total. To edit the total, expand the row and edit the splits.
Add Multiple Splits
- Once you have more than one split in a row, highlight a range of cells that are splits.
- Right-click and select Add Splits or click Add Split from the toolbar. The same number of new splits that you highlighted appears.
- (Optional) right-click each new split and choose Edit/Rename Split to label the split.
- Save the sheet.
Add Splits in Standard Sheets with Dimensions
See the section, "Choose Dimensions in Standard Sheets" in Edit Switches, Checkboxes, and Drop-Downs.
Rename or Delete Splits
- Click in any cell in the split's row.
- From the toolbar, click Rename Split and enter a new name, or click Delete Split .
- Click OK.
Add Rows in Cube Sheets
Watch the video (1m 4s):
Use Add Row in cube sheets to reveal suppressed rows or to find specific rows that are already revealed.
- Activate the button:
- Click Display Options and click Suppress rows if all zeros or blank.
- For each dimension filter, select a dimension that you can't expand. Dimension filters have the dimension icon:
- If Add Row remains deactivated, save the sheet.
- Click Add Row .
- Choose one value from each drop-down. The dimension drop-downs are the dimensions currently in the rows.
- Click OK. The sheet reveals the row and scrolls you to its location on the sheet. Your cursor moves to the first cell of the row.
- Enter data and save.