Book Image

101 Excel 2013 Tips, Tricks and Timesavers

By : John Walkenbach
Book Image

101 Excel 2013 Tips, Tricks and Timesavers

By: John Walkenbach

Overview of this book

Excel is a popular program. Millions of people throughout the world use it on a regular basis. But it’s a safe bet that the vast majority of users have yet to discover some of the amazing things this product can do. 101 Excel 2013 Tips, Tricks, & Timesavers?is packed with information that you need to know in order to confidently and seamlessly master the challenges that come with using Excel! Excel 2013 is excellent, but there's lots to learn to truly excel at Excel! In this latest addition to his popular Mr. Spreadsheet's Bookshelf series, John Walkenbach, aka "Mr. Spreadsheet," shares new and exciting ways to accomplish and master all of your spreadsheet tasks. From taming the Ribbon bar to testing and tables, creating custom functions, and overcoming "impossible" charts, mixing nesting limits, and more,?101 Excel 2013 Tips, Tricks, & Timesavers?will save you time and help you avoid common spreadsheet stumbling blocks.
Table of Contents (10 chapters)
Free Chapter
1
Cover
2
Table of Contents
3
Title Page
4
Introduction

Tip 7: Saving to a Read-Only Format

If you need to share information in a workbook with someone — and be assured that the information remains intact and isn’t altered — you have several choices.

Send a printed copy

Printing a workbook on paper is the low-tech approach. If the recipient is not nearby, this option may also require some type of delivery service.

Send an electronic copy in the form of a PDF file

PDF files (for Portable Document Format) is a common file format, and just about everyone has software installed that displays PDF files.

To save a workbook as a PDF file, choose File⇒Export⇒Create PDF/XPS Document and click the Create PDF/XPS button to display the Publish as PDF or XPS dialog box. Click the Options button for additional options:

→ Choose the pages

→ Specify what to save (the current range selection, the selected sheet(s), or the entire workbook

→ Save document properties and...