Skip to main content

logoCorrectSize.png

Adaptive Insights LLC.

Change and Move Elements on a Report

Explains how to move or change elements in an OfficeConnect report, such as cut, copy, paste, replace, and delete.

Cut or Copy and Paste Elements

You have several options available to cut, copy, and paste elements:

  1. Select the cells, the entire row, or the entire column of the element to move.
  2. Use your preferred method to cut or copy:
  • OfficeConnect Ribbon Tab 


    Cut, Copy, Paste options on OfficeConnect tab
    Use the functions in the OfficeConnect tab, not the Home tab. 

  • Right-click Menu

    Right click the cell, row, or column and select OfficeConnect > Cut Elements or Copy Elements and then Paste Elements.

  • Keyboard Shortcuts 

    • Cut: Shift + Ctrl + Alt + x
    • Copy: Shift + Ctrl + Alt + c
    • Paste: Shift + Ctrl + Alt + v
  1. Highlight the entire destination cell, row, or column for the element.
  2. Use your preferred method to paste.

Where to Copy or Cut and Paste

The table shows from where you can cut or copy elements and where you can paste them:

Cut or Copy: Paste Into:
Cells Cells, rows, or columns
Rows Rows or columns
Columns Rows or columns

Append or Replace an Element

When you drag and drop an element into one or more cells, rows, or columns that already have elements, you can:

  • Append the element: add the new element to the existing ones. For example, add a Payroll Expenses account to a row that already has the Benefit Expenses account.  The report shows the sum of the two accounts in the corresponding cells.
  • Replace the element: remove the existing elements and replace it with the new one. For example, replace the Benefit Expenses with the Payroll Expenses account and the report shows only the Benefit Expenses.  

Unless you have already added a label to the header row or column, the header doesn't change when you append an element even though the data changes.  You can add the label and it will reflect both elements. 

To append or replace an element:

  1. Select the row, column, or cell that contains the element to which you want to append another element.
  2. In the Reporting pane, select the Element tab .
  3. Drag the element into the worksheet.
  4. In the pop-up window, select Append or Replace
  5. Refresh the report to see your changes.

Delete an Element

You have several options available to delete elements. 

  1. Always select the cells, the entire row, or the entire column.
  • For a row or column, you must select the entire row or column to delete the element.  
  • For a cell, only elements applied to that particular cell are deleted. The row and column elements remain.
  • For a cell, if you delete the row and column elements, elements applied solely to the cell remain. 
  1. Use your preferred method for deletion:
  • Excel Functions

    Use the Delete function available from the Home tab in the ribbon. You can also use the Delete option available from the right-click context menu. To display the context-menu, right-click a cell, row, or column in the grid.

  • Review Tab

    In the Reporting Pane, Review tab, right-click the element to delete and select Delete. You must also select the element in the grid. For example, to delete a row element, select the row in the grid.

    Delete elements via the report pane

  • Right-click Menu

    Right-click the selection, and select OfficeConnect > Clear Design Elements.

    This method is useful when you want to delete all metadata applied to multiple rows, columns, or cells in a single operation. Refresh the report. 

    Example of Clearing Elements from an OfficeConnect Report

  1. If your report headers did not have labels, delete default headers to remove them from the report.
  2. Refresh the report.

Overwrite Element Data

If you want to overwrite the data displayed in a cell without removing the element in the corresponding row or column, enter an Excel formula directly into the cell. When you refresh, the report retains your formula and does not reconfigure the value based on the Adaptive Insights data. 

Update Design Elements in OfficeConnect

Update the elements in your report to reflect the latest structure for the rows and columns.

  1. From the Elements group, select Update Elements.
  2. In the Reporting pane, select the Review tab. Review the items available for any new elements. 
  • Was this article helpful?