Page Setup, Printing & PDF Export
A well-created Excel sheet must also print correctly. This chapter teaches print area, margins, page orientation, scaling, print preview, page breaks and PDF export for professional office submission.
Print Area
Select the exact data range to print.
Page Setup
Set margins, paper size and orientation.
Print Preview
Check layout before printing.
PDF Export
Save Excel reports as shareable PDF files.
After This Chapter, You Will Be Able To
This chapter helps you prepare Excel sheets for professional output.
Set Print Area
Print only the selected part of the worksheet.
Setup Page
Set paper size, margins and orientation.
Scale Sheet
Fit data properly on one or more pages.
Export PDF
Save Excel reports in PDF format for sharing.
Why Page Setup Matters in Excel
Excel sheets can be wide and large, so print settings are very important.
1 Easy Explanation
Page Setup controls how an Excel sheet appears on paper or PDF. It includes orientation, margins, scaling, page size, print area, page breaks, header, footer and print preview.
Fee Report
Important Page Setup Options
These options control how your Excel sheet appears when printed.
Paper Size
Use A4 size for most office and academic reports.
Orientation
Use Portrait for narrow sheets and Landscape for wide sheets.
Margins
Set normal, narrow or custom margins for clean spacing.
Scaling
Fit sheet to one page or adjust width and height.
Setting Print Area in Excel
Print Area allows you to print only a selected range of cells.
| Step | Action | Purpose |
|---|---|---|
| Step 1 | Select the required data range | Choose only the part to print |
| Step 2 | Go to Page Layout tab | Access page setup tools |
| Step 3 | Click Print Area | Open print area options |
| Step 4 | Select Set Print Area | Lock selected range for printing |
| Step 5 | Check Print Preview | Confirm layout before printing |
Checking Print Preview Before Printing
Print Preview shows exactly how the sheet will look on paper or PDF.
| Check Point | What to Check | Why Important |
|---|---|---|
| Page Fit | Data should fit properly on page | Avoid cut columns |
| Orientation | Portrait or Landscape | Choose suitable layout |
| Margins | Enough spacing around content | Professional appearance |
| Header/Footer | Report name and page number | Document identity |
| Gridlines | Print if needed | Useful for table readability |
| Page Breaks | Data should not split awkwardly | Clean report flow |
Saving Excel Sheet as PDF
PDF export helps share reports without changing layout.
2 Why Export to PDF?
PDF keeps your Excel report fixed and readable on different devices. It is useful for submitting reports, sharing fee records, sending statements and printing final documents.
3 PDF Export Steps
- Prepare and format the Excel sheet.
- Set print area and page setup.
- Open Print Preview and check layout.
- Go to File → Export or Save As.
- Choose PDF format.
- Save with a clear file name.
Example: Preparing Fee Report for PDF
Correct page setup makes Excel reports clean and shareable.
Without Page Setup
Sheet may print too small or too wide.
Report may not show title or page number.
Extra blank pages may print.
Result: Unprofessional output.
With Page Setup
The report is properly fitted and ready to print or export.
Choose the Right Print Setting
Click each setting to understand when it is used.
Print Setting Guide
Select any option above to understand its practical use in Excel.
Prepare an Excel Report for Printing and PDF
Complete these steps inside MS Excel.
Office Task: Print-Ready Fee Report
Mistakes Students Should Avoid
Printing mistakes can spoil a well-made Excel sheet.
Wrong Habits
- Printing without checking Print Preview.
- Not setting print area for required data.
- Using Portrait for very wide tables.
- Ignoring cut columns and extra blank pages.
- Exporting PDF before checking page setup.
- Forgetting header, footer and page numbers in formal reports.
Correct Habits
- Always check Print Preview first.
- Set print area for final report range.
- Use Landscape for wide tables.
- Use scaling to fit columns properly.
- Check layout before PDF export.
- Add report name and page number when needed.
Quick Quiz
Select the correct answers and check your score.
1. Page Setup is used to:
2. Print Area means:
3. Print Preview is used to:
4. Landscape orientation is useful for:
5. Scaling helps to:
6. PDF export is useful because:
7. A4 is a type of:
8. Which should be done before PDF export?
9. Which is a printing mistake?
10. Best Excel printing habit is:
Remember These Points
Revise these before moving to Chapter 21.
Page Setup
Controls page size, margins, orientation and scaling.
Print Area
Defines the selected cell range to be printed.
Print Preview
Shows final output before printing or PDF export.
Orientation
Portrait is vertical; Landscape is horizontal and useful for wide tables.
PDF Export
Saves Excel report in fixed, shareable PDF format.
Next Step
Now complete your MS Excel practical project.