Microsoft Office Tutorials and References
In Depth Information
Creating workbooks
You can also create custom properties by clicking the arrow located to the right of the
Document Properties label, and clicking Advanced Properties to open the Properties dialog
box. On the Custom page of the Properties dialog box, you can click one of the existing
custom categories or create your own by entering a new property name in the Name field,
clicking the Type arrow and selecting a data type (for example, Text, Date, Number, or Yes/
No), selecting or entering a value in the Value field, and then clicking Add. If you want to
delete an existing custom property, point to the Properties list, click the property you want
to get rid of, and click Delete. After you finish making your changes, click the OK button. To
hide the Document Properties panel, click the Close button in the upper-right corner of the
panel.
When you’re done modifying a workbook, you should save your changes and then, to close
the file, display the Backstage view and then click Close. You can also click the Close button
in the upper-right corner of the workbook window.
KEYBOARD SHORTCUT Press Ctrl+W to close a workbook.
In this exercise, you’ll close an open workbook, create a new workbook, save the workbook
with a new name, assign values to the workbook’s standard properties, and create a custom
property.
SET UP You need the ExceptionSummary workbook located in the Chapter01 practice
file folder to complete this exercise. Open the workbook, and then follow the steps.
1
Click the File tab to display the Backstage view, and then click Close to close the
ExceptionSummary workbook.
2
Display the Backstage view, and then click New to display the New page.
3
Click Blank workbook , and then click Create to open a new, blank workbook.
4
Display the Backstage view, click Save As , click Computer , and then click Browse to
open the Save As dialog box.
5
Use the navigation controls to display the Chapter01 folder. In the File name field,
enter Exceptions2013 .
Search JabSto ::




Custom Search