Ravindra BagaleCourses & study guides

14. Protection, Sharing and Printing

14.8 Exporting to PDF

By Last updated:

Steps in Excel

  1. Finish page setup first (14.4–14.7) – the PDF uses the same settings.
  2. File › Export › Create PDF/XPS Document › Create PDF/XPS, or File › Save As › Save as type: PDF.
  3. Click Options… › choose Active sheet(s), Entire workbook, Selection or a page range › OK.
  4. Optimize for: Standard (good print quality) or Minimum size (for e-mail).
  5. Name it clearly, for example Blinkit_Pune_Sales_31-03-2026.pdf › Publish.
  6. To export several sheets together, Ctrl-click their tabs first, then choose Active sheet(s).

Worked example. Select the Dashboard and City Summary tabs › File › Export › PDF › Options: Active sheet(s) › Publish. The two-page PDF is ready to send to all six city managers.

Ravindra Bagale's Tip

Khup students PDF banavtana fakt current sheet export kartat aani mag lakshat yeta ki dusri sheet rahili, kiwa page setup na kelyamule PDF 20 panancha zala. Aadhi page setup, mag Options madhe Active sheet(s) / Entire workbook nivda, aani PDF ughdun ekda nakki tapasa.

Practice task

Export your Dashboard and City Summary sheets together into one PDF named with today's date in dd-mm-yyyy format, and check the page count.