Rename or reorder the columns in the External Data window

The External Data window appears when you use the Link Data to Shapes command on the Data menu to import data into your drawing.

You can't drag or otherwise edit the data within the External Data window, but you can use the Column Settings dialog box to rename or reorder the columns.

Rename the columns

  1. Right-click any column heading in the External Data window, and then click Column Settings.

  2. In the Column Settings dialog box, select the check box next to the column that you want to rename. This makes the column name in the list editable.

  3. Type a new name in place of the original name.

    Tip:  You can't use a name that is already being used.

Click Reset Name to change the name back to what it is called in the original data source.

Reorder the columns

  1. Right-click any column heading in the External Data window, and then click Column Settings.

  2. In the Column Settings dialog box, click the column that you want to move.

    Tip: Select the check box for the column that you want to move if it isn't already selected. Only columns with selected check boxes appear in the External Data window.

  3. Click Move Up or Move Down.

For more information about working with imported data, see Import data from Excel, SQL Server, SharePoint sites, and other external sources.

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×