Copy and paste

You can cut, copy, and paste values between views in Planning Analytics Workspace. You can also paste values from other applications, such as Microsoft Excel.

You can use the following keyboard shortcuts to cut, copy, and paste in a view:

Action Windows Apple Mac
Cut CTRL+X CMD+X
Copy CTRL+C CMD+C
Paste CTRL+V CMD+V

You can also right-click a cell or a range of cells, and select cut or copy. Paste must be done by using the keyboard shortcut.

When you paste data into a single cell, the paste expands to other cells depending on the number of cells that you copied.

Note: Not all browsers support the right-click menu, but all browsers support the keyboard shortcuts.

Copy a single cell into multiple cells

You can copy a single cell and paste it into multiple cells.

  1. Copy the cell.
    Note: To select a range of cells, hold down Shift and select the range of cells.
  2. Click CTRL+V or CMD+V to paste.

Copy a range of cells and pasting it into a larger range of cells

You can paste a range of cells into a larger range of cells, repeating the source range where possible. If you copy a range of four cells, the target range must be a multiple of four to repeat the cells. If you copy four cells into a target of nine cells, only the first four cells are pasted into. If you copy four cells into eight writeable target cells, the cells are repeated.

  1. For a range of cells, hold down Shift and select the cells. Right-click the selection and select Copy.
  2. Hold down Shift and select the target cells, then click CTRL+V or CMD+V to paste.

Copy two rows and four columns into two rows and eight columns

This example shows the results of copying two rows and four columns into two rows and eight columns. The header row is not copied.

The source cells that are copied:
1 Quarter Jan Feb Mar
90 25 30 35
87 28 30 32
The result of pasting the source cells into two rows and eight columns:
1 Quarter Jan Feb Mar 2 Quarter Apr May Jun
90 25 30 35 90 25 30 35
87 28 30 32 87 28 30 32

Copy rows and columns

You can copy and paste whole rows or columns. You can select a single row or column, or a contiguous range of rows and columns.

  1. Select the row or column headers, then right-click the row or column headers, and select Copy.

    It can take a few seconds for data to be copied; a window appears that shows the progress.

  2. When the data has been successfully copied, click OK in the window, then click the cell where the paste is to start.
    Tip: You can paste the rows or columns into a larger selection, repeating the data, by holding Shift and selecting the target rows and columns, in multiples of the source selection.
  3. Click CTRL+V or CMD+V.

Copy and paste from nested hierarchies by selecting rows or columns from the outer axis

You can copy and paste from nested hierarchies by selecting rows or columns from the outer axis. For example, suppose that you have Car models in the rows and Regions and Months nested on the columns. Select Argentina, this selects all the months underneath, and then copy. You can then paste the data into another nested area, such as Belgium.

Right-click on the outer dimension of nested columns to copy, then paste by using CMD + V or CTRL+V.

Copy cells from a column and paste them into rows

In a view without nesting on the rows and columns, you can select a range of cells in a column and paste them into multiple rows. For example, select and copy the values in the Argentina column for the L Series 1.8 L Wagon, L Series 1.8 L Convertible, and L Series 1.8 L Sedan rows. Then, select the cells for Belgium, Brazil, and Chile in the L Series 1.8 L Wagon row, and paste the cells into the selected cells.
  Argentina Belgium Brazil Chile
L Series 1.8 L Wagon 76 0 0 0
L Series 1.8 L Convertible 97 0 0 0
L Series 1.8 L Sedan 56 0 0 0
The result is the selected values are copied into the corresponding cells for Belgium, Brazil, and Chile for the L Series 1.8 L Wagon, L Series 1.8 L Convertible, and L Series 1.8 L Sedan rows, as shown in this table:
  Argentina Belgium Brazil Chile
L Series 1.8 L Wagon 76 76 76 76
L Series 1.8 L Convertible 97 97 97 97
L Series 1.8 L Sedan 56 56 56 56

Copying data from Microsoft Excel

When you copy data from Microsoft Excel and paste it to Planning Analytics Workspace, you must use the same decimal locale separator in both applications. The locales in your browser and Windows must match.

Planning Analytics Workspace is a browser-based application and uses the browser locale setting. Microsoft Excel is a Microsoft Windows application, which uses the language setting in Windows and copies data to the clipboard by using the locale-specific decimal separator.

Copy/paste and clear limitations

There is a 65,536 cell limit for copying and pasting into a view. An error message appears if you try to paste more. The same limit applies to clearing cells in a view.

Copy and paste is not supported into or from Websheets in Planning Analytics Workspace.