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.

Connect with an expert
Contact us
Expand your skills
Explore training

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×