Saving and Printing in Microsoft Excel
- Feb 20
- 3 min read
1. Introduction
Saving and printing correctly is essential in:
✔ Finance departments
✔ Bookkeeping roles
✔ Reporting
✔ Client presentations
✔ Audit preparation
Incorrect saving or printing can lead to:
❌ Lost work
❌ Incorrect report layouts
❌ Confidentiality issues
❌ Unprofessional presentation
This session ensures learners can confidently save and print workbooks in a professional setting.
2. Saving a Workbook for the First Time
When you create a new Excel file, it must be saved properly.
Step-by-Step: Save for the First Time
Step 1:
Click File (top left corner).
Step 2:
Click Save As.
Step 3:
Choose where to save:
This PC
OneDrive
USB Drive
Network Folder
Step 4:
Enter a professional file name.
Example:
Sales_Report_Jan_2026
ABC_Ltd_Purchase_Ledger
Bank_Reconciliation_Feb_2026
Step 5:
Click Save.
✔ Always use clear, professional naming.
3. Saving Changes
After the file is saved once:
Option 1:
Click the Save icon (top left).
Option 2:
Press Ctrl + S (Keyboard shortcut).
Best Practice: Save regularly to avoid losing work.
4. Understanding File Types
When saving, Excel allows different file types:
File Type | Purpose |
.xlsx | Standard Excel file |
.xlsm | Excel file with Macros |
.csv | Data export format |
Print-ready document |
Finance Tip: Use PDF when sending reports externally to prevent editing.
5. Using Save As
Use Save As when:
✔ Creating a new version
✔ Changing file name
✔ Saving in different format
✔ Creating monthly reports
Example:Sales_Report_Jan_2026Sales_Report_Feb_2026
This protects original data.
6. Preparing to Print
Before printing:
✔ Check layout
✔ Adjust margins
✔ Check page breaks
✔ Confirm correct sheet is selected
Never print without previewing first.
7. Print Preview
Step 1:
Click File.
Step 2:
Click Print.
You will see:
Preview of document
Page numbers
Print settings
Always check:
✔ Data fits on page
✔ No columns cut off
✔ Correct orientation
8. Adjusting Page Orientation
In Print settings:
Portrait (vertical)
Landscape (horizontal)
Use Landscape when printing wide tables like:
Sales Ledger
P&L Reports
Financial Statements
9. Adjusting Margins
In Print settings:
Click Margins → Choose:
Normal
Narrow
Wide
Or select Custom Margins for full control.
10. Scaling (Fit to Page)
If data does not fit properly:
In Print Settings:
Change:
No Scaling → Fit Sheet on One Page
Fit All Columns on One Page
Fit All Rows on One Page
Very useful in finance reporting.
11. Setting Print Area
Sometimes you only want to print part of a worksheet.
Step 1:
Highlight the area you want to print.
Step 2:
Go to Page Layout tab.
Step 3:
Click Print Area → Set Print Area.
Now only selected data will print.
12. Printing Gridlines
By default, gridlines may not print.
To enable:
Go to Page Layout.
Under Gridlines, tick Print.
Useful when printing raw data.
13. Adding Headers and Footers
For professional documents:
Step 1:
Go to Insert tab.
Step 2:
Click Header & Footer.
You can add:
Company name
Report title
Date
Page numbers
Example Footer: Page 1 of 3Prepared by Finance Department
Essential for professional reporting.
14. Printing the Workbook
In Print Settings:
Choose:
Print Active Sheets
Print Entire Workbook
Print Selection
Then: Click Print.
15. Saving as PDF
Best practice for sharing reports.
Steps:
Click File.
Click Save As.
Choose file type → PDF.
Click Save.
Benefits:
✔ Cannot be edited easily
✔ Professional presentation
✔ Easy to email
16. Example Business Scenario
You work in Accounts and must:
✔ Prepare monthly P&L
✔ Save it correctly
✔ Convert to PDF
✔ Email to management
If saved incorrectly:
Wrong version sent
Data cut off
Confidential information exposed
Saving and printing correctly protects professionalism.
17. Practice Exercise
Create a simple table:
Item | Amount |
Sales | 25,000 |
Expenses | 15,000 |
Profit | 10,000 |
Tasks:
Save file as "Monthly_Report".
Adjust column widths.
Set print area.
Change orientation to Landscape.
Preview print.
Save as PDF.
18. Common Mistakes to Avoid
❌ Printing without preview
❌ Saving files with unclear names
❌ Overwriting previous reports
❌ Not checking page breaks
❌ Printing entire workbook accidentally
19. Knowledge Check Questions
What is the shortcut for saving?
When should you use Save As?
Why is Print Preview important?
When should you save as PDF?
Why use Landscape orientation?
20. Key Takeaways
✔ Save regularly
✔ Use professional file names
✔ Always check Print Preview
✔ Adjust orientation and scaling
✔ Use PDF for external reporting
Comments