O'Reilly logo

Microsoft® Office Excel® 2013: Part 1, 2nd Edition by Tim Barnosky

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

ACTIVITY 6-3: Managing Workbook Properties

Before You Begin

The my_sales_summary.xlsx workbook file is open.

The C drive on your computer has been indexed.

Scenario

It has dawned on you that you will be creating a large number of workbook files that will contain similar types of data and have similar file names. You decide to include key information in your workbook file, in the form of workbook properties, to make it easier for you to search through your workbook files. You also want to add a custom property so document recipients can easily tell if a workbook file is the approved, final copy.

  1. Select FILE→Info.
  2. Add workbook properties to the file.
    1. In the right pane, below the Properties drop-down menu, next to Title, select ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required