1. Working with Planning
  2. Working with Supporting Detail
  3. Pasting Multiple Cells into the Supporting Detail Window

Pasting Multiple Cells into the Supporting Detail Window

You can copy Supporting Detail from multiple cells in Microsoft Excel or another product and paste it into the Supporting Detail window.

Note:

This functionality is available on desktops only, not on mobile devices.

For example, you can 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. Any excess values on the clipboard are ignored when you paste the contents of the clipboard.

  • You can copy only the data (not the row descriptions or labels) in a range of cells from Microsoft Excel into a range of cells in Supporting Detail.

  • The pasted data does not retain the original formatting.

To copy Supporting Detail from a Microsoft Excel worksheet:

  1. In Planning, select a cell or range of cells that you want to view or create Supporting Detail for, then click Property Panel icon, then Data property tab, and then click Supporting Detail.
  2. In Supporting Detail, note the range of cells with Supporting Detail, or add cells with Supporting Detail, and then click OK.
  3. In Excel, select the range of cells containing Supporting Detail, and then press Ctrl+C to copy the data.
  4. In Planning, open the form to which to add Supporting Detail.
  5. Select the cell or cells with the details to modify, and then click Supporting Detail.
  6. In Supporting Detail, click in the gray frame of the range's upper-left cell that you want to paste Supporting Detail to screenshot of the gray frame around a Supporting Detail cell, and then press Ctrl+V.
    In your browser, pressing Ctrl+V displays the clipboard. Press Ctrl+V again to paste the copied data.
  7. Click Save.