Microsoft Office Tutorials and References
In Depth Information
Printing a Worksheet
4. Type the desired text in the appropriate property text boxes.
What if the property I want to change is not displayed in the Document
Tap or click the Document Properties button in the Document Information Panel
and then tap or click Advanced Properties on the menu to display the Properties
dialog box. If necessary, tap or click the Summary tab (Properties dialog box) to
display the Summary sheet, fill in the appropriate text boxes, and then tap or click
the OK button.
5. Tap or click the ‘Close the Document Information Panel’ button at the right
edge of the Document Information Panel so that the panel no longer appears
in the Excel workbook window.
If you want to conserve ink
or toner, you can instruct
Excel to print draft quality
documents by tapping or
clicking FILE on the ribbon
to open the Backstage view,
tapping or clicking Options in
the Backstage view to display
the Excel Options dialog
box, tapping or clicking
Advanced in the left pane
(Excel Options dialog box),
sliding or scrolling to the
Print area in the right pane,
placing a check mark in the
‘Use draft quality’ check box,
and then tapping or clicking
the OK button. Then, use the
Backstage view to print the
document as usual.
To Save an Existing Workbook with the Same File Name
You have made several modications to the workbook since you last saved it.
Thus, you should save it again. The following step saves the workbook again. For
an example of the step listed below, refer to the office and Windows chapter at
the beginning of this topic.
Tap or click the Save button on the Quick Access Toolbar to overwrite the previously
Printing a Worksheet
After creating a worksheet, you may want to print it. Printing a worksheet enables you
to distribute the worksheet to others in a form that can be read or viewed but typically
not edited. It is a good practice to save a workbook before printing a worksheet, in the
event you experience difculties printing.
What is the best method for distributing a workbook?
The traditional method of distributing a workbook uses a printer to produce a hard copy. A hard copy or printout is
information that exists on a physical medium such as paper. Hard copies can be useful for the following reasons:
• Some people prefer proofreading a hard copy of a workbook rather than viewing it on the screen to check for errors and
• Hard copies can serve as a backup reference if your storage medium is lost or becomes corrupted and you need to recreate
Instead of distributing a hard copy of a workbook, users can distribute the workbook as an electronic image that mirrors
the original workbook’s appearance. The electronic image of the workbook can be sent as an email attachment, posted on a
website, or copied to a portable storage medium such as a USB ash drive. Two popular electronic image formats, sometimes
called xed formats, are PDF by Adobe Systems and XPS by Microsoft. In Excel, you can create electronic image les through
the Save As dialog box and the Export, Share, and Print tabs in the Backstage view. Electronic images of workbooks, such as
PDF and XPS, can be useful for the following reasons:
• Users can view electronic images of workbooks without the software that created the original workbook (e.g., Excel).
Specically, to view a PDF le, you use a program called Adobe Reader, which can be downloaded free from Adobe’s website.
Similarly, to view an XPS le, you use a program called XPS Viewer, which is included in the latest versions of Windows and
• Sending electronic workbooks saves paper and printer supplies. Society encourages users to contribute to green computing ,
which involves reducing the electricity consumed and environmental waste generated when using computers, mobile devices,
and related technologies.