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 खोलकर एक बार ज़रूर देखो.
Worked example — exporting to pdf
Why
Priya Deshmukh in Pune and Emma Clarke abroad both need a clear, repeatable way to use exporting to pdf on a CityBasket Retail sheet without breaking totals.
What
Exporting To Pdf is the Excel idea this page teaches. We will walk one tiny example end to end.
How
- Open a blank sheet. In A1 type a short label for exporting to pdf.
- Enter a small made-up value for Priya Deshmukh using £ where money appears.
- Add a second value for Emma Clarke using ₹ so you see mixed currencies stay numeric.
- Apply the method from this lesson step by step (menu or formula as shown above).
- Check the result still works inside SUM or a simple check cell.
Formula / action
Follow the formula or ribbon steps shown in this lesson (keep values numeric).Meaning: Once exporting to pdf is correct on one row, copy the same pattern down the column.
Practice tasks (10+)
Try these on a blank sheet. Open a hint only if you are stuck. No quiz — just practice.
1. Rebuild the smallest example of exporting to pdf on a blank sheet for GreenField Dairy.
Hint: Use only the steps on this page. Keep numbers numeric.
2. Change one input for Neha Shah and confirm the result updates.
Hint: If the result is stuck, check absolute vs relative references.
3. Repeat the same steps with a £ or € value for Anna Kowalski.
Hint: Formatting must not break SUM.
4. Write the result meaning in one plain sentence next to the cell.
Hint: Imagine explaining it to a new joiners.
5. Add a second row and fill the method down.
Hint: Double-click the fill handle if the pattern is consistent.
6. Break the example on purpose, then fix it using this lesson.
Hint: Common break: text instead of a number.
7. Apply exporting to pdf to a 5-row made-up GreenField Dairy table.
Hint: Keep column headers clear.
8. Check your answer with a simple total or COUNT.
Hint: A wrong total usually means a format or key mismatch.
9. Swap ₹ and $ on one column and re-check totals.
Hint: Stored values stay the same; only the display changes.
10. List two mistakes beginners make with exporting to pdf.
Hint: Look back at the tip box on this page.
11. Teach the steps out loud in under one minute.
Hint: Why → What → How.
12. Save the sheet as GreenFieldD_practice.xlsx.
Hint: Use a clear file name for class.
Loading practice tasks...
- Input cells to unlock (Easy): How many cells are in the Monthly target column?
- Total target (Easy): Add up the Monthly target column.
- Total actual (Easy): Add up the Actual column.
- Highest target (Easy): What is the largest value in the Monthly target column?
- Overall achievement (Medium): Divide the total Actual by the total Monthly target. Round to 3 decimals.
- Cities below target (Medium): How many cities have a Gap below 0?
- Manager for a city (Medium): Find the Manager for City "Berlin".
- Pages to print (Medium): If one page holds 4 data rows, how many pages do the rows need?
- Gap for the first city (Medium): For the first row, find Actual minus Monthly target.
- Best performer (Hard): Which City has the largest Actual?
- Status for the first city (Hard): For the first row, return "Hit" if Actual is at least Monthly target, else "Miss".
- Total shortfall (Hard): Add up the Gap column only where it is below 0, and show it as a positive number.
Quick revision cards
Three standalone cards. Each one explains the idea with its own example. Scan the QR to open this lesson.
