Importing Metadata into Copied Worksheets
Before you begin, be sure to review the content in About Importing Metadata in Smart View.
Note:
Once the metadata from a source sheet is imported in a destination sheet, this operation cannot be undone.
To import metadata to a copied worksheet:
- With the destination worksheet active, from the Smart View ribbon, select More and then Import Metadata to display a list of all open workbooks and their corresponding open worksheets.