Pasting Multiple Cells into the Supporting Detail Window

You can copy supporting detail from multiple cells in Microsoft Excel or another application and paste it into the Supporting Detail window. For example, you can export data forms to Excel spreadsheets, work on supporting detail in spreadsheets, and copy it back to Planning.

About copying and pasting supporting detail:

The cell range of the data that you paste must exist in the Supporting Detail window.
You can copy and paste cell labels and cell data.
The pasted data does not retain the original formatting.

To copy supporting detail from Microsoft Excel spreadsheets:

Open a Planning data form.
In Planning, select a cell or range of cells, and click Supporting Detail.
In Supporting Detail, note the range of cells with supporting detail, or add cells with supporting detail, and click OK.
Select Tools, then Export as Spreadsheet.
A browser instance of Microsoft Excel is displayed with the exported information, and you can modify the supporting detail.
In Excel, select the range of cells containing supporting detail, and press Ctrl+C to copy the data.
In Planning, open the data form to which to add supporting detail.
Select the cell with the details to modify, and click Supporting Detail.
In Supporting Detail, click in the range's upper-left cell for which to paste supporting detail, and press Ctrl+V.
Click Save.