Ch 4: Configure to Print & Save in Excel

1. Setting a Print Area in Excel

Excel has several print options, including printing one worksheet or an entire workbook. This lesson will guide you through the steps to printing a selected area of a worksheet and explain how to clear your selected print area.

2. Saving an Excel Workbook: File Formats & Options

If you have ever created an Excel workbook, spent hours updating data and numbers, only to loose the file or updates because you forgot to save, you are not alone. This lesson will review the steps to saving your MS Excel workbook.

3. How to Print Individual Worksheets in Excel

Workbooks can have multiple worksheets. Do you find yourself in need of printing just one worksheet rather than the entire workbook? This lesson will guide you through the steps for printing one worksheet or multiple worksheets.

4. How to Set Print Scaling in Excel

You can use the scaling feature in Excel to limit the number of pages wide and/or tall when you go to print the spreadsheet. This lesson will discuss the different Scale to Fit options and explain how to apply scaling to documents you print from Excel.

5. Ensuring Your Excel Workbook is Backwards Compatible

Need to send an Excel file to someone with an older version of the application? Not sure if they will be able to open and view the file? This lesson will discuss the Check Compatibility feature in Excel.

6. Printing in Excel: How to Configure Workbooks to Print

Trying to print an Excel spreadsheet? Wondering what the difference is between a workbook and a worksheet? This lesson will explain the difference, guide you through printing a workbook and share a few tips when printing from MS Excel.

7. How to Modify Print Settings in Excel

Printing from Excel is not always as straight forward as it may seem. This lesson will review the different print settings available to help adjust the layout for printing.

8. How to Save Excel Workbook Files in Different Formats

Need a PDF version of your MS Excel workbook? Have a large spreadsheet that needs to be converted to a comma delimited file? This lesson will take you through the steps to converting your Excel spreadsheets to different file formats.

9. How to Share Your Excel Workbook

Whether you are using MS Excel to develop complex company financial spreadsheets or track personal expenses, you may find yourself in need of sharing the information. This lesson will explain different sharing options in Excel.