Excel 2019 Bible

(singke) #1

Part I: Getting Started with Excel



  1. Provide a descriptive name. You can also specify what to include in the view by
    using the two check boxes. For example, if you don’t want the view to include print
    settings, remove the check mark from Print Settings.

  2. Click OK to save the named view.


Then when you’re ready to print, open the Custom Views dialog box to see all named views.
To select a particular view, just select it from the list and click the Show button. To delete
a named view from the list, click the Delete button.

Creating PDF files
The PDF file format is widely used as a way to present information in a read-only manner,
with precise control over the layout. If you need to share your work with someone who
doesn’t have Excel, creating a PDF is often a good solution. Free software to display PDFs is
available from a number of sources.

Excel can create PDFs, but it can’t open them. Word 2019 can create and open PDFs.

XPS is another “electronic paper” format, developed by Microsoft as an alternative to the
PDF format. At this time, there is little third-party support for the XPS format.

To save a worksheet in PDF or XPS format, choose File ➪ Export ➪ Create PDF/XPS
Document ➪ Create a PDF/XPS. Excel displays its Publish as PDF or XPS dialog box, in which
you can specify a filename and location and set some other options.
Free download pdf