Copy data from a grid to Microsoft Excel

  • Article

Important

This content is archived and is not being updated. For the latest documentation, see Microsoft Dynamics 365 product documentation. For the latest release plans, see Dynamics 365 and Microsoft Power Platform release plans.

Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012

You can copy information from some grids in Microsoft Dynamics AX and paste that information into a Microsoft Excel worksheet.

  1. In the grid of the active form, select the rows to copy.

    To select several rows, hold down the CTRL key while clicking the individual rows to select. To select several consecutive rows, select the first row, hold down the SHIFT key, and then click the last row to select. To select all the rows in the grid, click File > Edit > Select all.

    Note

    In some grids, you cannot select multiple rows at the same time.

  2. Click File > Edit > Copy to copy the selected rows.

  3. Open a Microsoft Excel worksheet, select the cell where the information should start in the worksheet, and then press CTRL+V to paste the information from the grid in Microsoft Dynamics AX to the worksheet.