14. Protection, Sharing and Printing
14.8 Exporting to PDF
Steps in Excel
- Finish page setup first (14.4–14.7) – the PDF uses the same settings.
- File › Export › Create PDF/XPS Document › Create PDF/XPS, or File › Save As › Save as type: PDF.
- Click Options… › choose Active sheet(s), Entire workbook, Selection or a page range › OK.
- Optimize for: Standard (good print quality) or Minimum size (for e-mail).
- Name it clearly, for example
Blinkit_Pune_Sales_31-03-2026.pdf› Publish. - 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
When creating a PDF, many students export only the current sheet and then realise another sheet was left out, or the PDF became 20 pages because the page setup wasn't done. Do the page setup first, then choose Active sheet(s) / Entire workbook in Options, and always open the PDF once to check it.
Ravindra Bagale's Tip – मराठी
PDF बनवताना बरेच students फक्त current sheet export करतात आणि मग लक्षात येतं की दुसरी sheet राहिली, किंवा page setup न केल्यामुळे PDF 20 पानांचा झाला. आधी page setup, मग Options मध्ये Active sheet(s) / Entire workbook निवडा, आणि PDF उघडून एकदा नक्की तपासा.
Ravindra Bagale's Tip – हिंदी
PDF बनाते समय बहुत से students सिर्फ़ current sheet export करते हैं और फिर पता चलता है कि दूसरी sheet छूट गई, या page setup न करने से PDF 20 पन्नों का हो गया. पहले page setup, फिर Options में Active sheet(s) / Entire workbook चुनो, और PDF खोलकर एक बार ज़रूर देखो.
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.