Hide columns in the External Data window and in linked shapes

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

Hiding a column in the External Data window also hides the data in the linked shapes. For example, if you hide a Salary column, all mentions of Salary in shapes that are linked to the data are also hidden.

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

  2. In the Column Settings dialog box, clear the check box of the column that you want to hide.

To show the column in the External Data window and in the linked shapes again, select the check box.

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

Expand your skills
Explore training
Get new features first
Join Office Insiders

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.

×