Excel to PDF

Excel to PDF: since a PDF file is easily accessible to everyone, having an Exile file in a PDF format is the best.

When you have a well formatted worksheet and you want it to print properly, everything to do with page size, orientation and page breaks, you can find it under the Page Layout tab.

Page Layout tab

In the Page Setup group under Page Layout tab you have all sort of different options.

This article will teach you how to set print area, to apply page breaks, to covert Excel to PDF and to add headers and footers to your Excel worksheet.

HOW TO SET PRINT AREA IN EXCEL.

  1. Hover your mouse on the worksheet to select the area you want to print.
  2. Under Page Layout, click on Print Area then Set Print Area.

Set Print Area

The selected area will only be printed as your end result. Here is print preview of the selected area below:

Print Preview in Excel

HOW TO ADD HEADERS AND FOOTERS IN EXCEL.

Easiest way to add headers and footers to your Excel worksheet is through the Page Layout View.

Page Layout view

When you click the Page Layout view, it leads you to where you can Add Headers and Footers.

inserting headers and footers in Excel

Adding page numbers to your Excel worksheet is quite easy:

Page Number: Click the Page Number and Excel adds numbers to your pages.

File Name and Sheet Name refers to the name you used to Save your file and the Sheet name of the file.

Don’t forget to watch the video below to know how to add picture to the Footers of your Excel worksheet.

HOW TO CONVERT EXCEL TO PDF.

There is quite a bit of different ways to convert your Excel worksheet to PDF, I’ll recommend:

  • Control (Ctrl) + P: Print

Export as PDF

Then click on Export, next Create PDF/XPS Document.

Convert Excel to PDF

After you click, Create PDF/XPS Document, a Publish as PDF or XPS dialogue box pops up. Click on Publish. Don’t forget to check the Open file after publishing check box.

So, when you have a well formatted worksheet that needs to be printed from Excel to PDF format, don’t forget this technique works faster.

Excel file:Excel to PDF

Thanks, sharing is caring.