Back to: Computer Science JSS 3
Welcome to class!
In today’s class, we shall be talking about the printing of excel worksheets. Please enjoy the class!
Printing of Excel Worksheet
Printing can be a crucial step in sharing your Excel data with others or simply creating a hard copy for your own reference. This guide will equip you with the knowledge and skills to master Excel worksheet printing, ensuring clean, professional, and error-free results.
1. Selecting What to Print:
Entire Worksheet: Click the File tab, then Print. This will print the entire active worksheet.
Specific Range: Select the desired cell range before opening the Print menu. This allows you to print only the relevant data.
Multiple Sheets: Hold Ctrl while clicking the tabs of the worksheets you want to print. Then, open the Print menu and choose Print Selection.
2. Print Settings:
The Print menu offers various options to customize your printout and these includes:
Printer: Choose your preferred printer.
Copies: Specify the number of copies you need.
Settings: This section allows you to fine-tune your printing:
Print Active Sheets: Choose to print the entire workbook, current sheet only, or a selection.
Page Layout: Select portrait or landscape orientation, paper size, and margins.
Scaling: Adjust the data size to fit the chosen paper size.
Headers and Footers: Add custom text or information to appear at the top and bottom of each page.
Gridlines and Row/Column Headings: Choose whether to print these elements for clarity.
3. Page Breaks and Preview:
Page Break Preview: Click the Page Break Preview button in the bottom right corner of the Excel window. This shows how your data will be divided across pages.
Manual Page Breaks: Insert page breaks by right-clicking between rows and choosing Insert Page Break.
4. Advanced Printing Tips:
Print Titles: Freeze rows or columns to keep them visible on every page.
Fit to One Page: Adjust scaling or margins to shrink the data and fit it onto a single page.
Use Print Areas: Define specific areas within the worksheet to print instead of the entire sheet.
Export as PDF: Consider exporting your Excel data as a PDF for a more shareable and stable format.
5. Troubleshooting Common Issues:
Cut-off Data: Check page breaks and adjust margins or scaling if necessary.
Formatting Discrepancies: Ensure your desired formatting is applied before printing.
Printer Issues: Consult your printer’s manual for troubleshooting specific error messages.
By understanding these steps and settings, you can confidently print your Excel worksheets with accuracy and efficiency. Remember to practice and experiment to find the printing configurations that best suit your needs!
We have come to the end of today’s class. I hope you enjoyed the class!
In the next class, we shall be discussing how to create and edit worksheet graphs.
In case you require further assistance or have any questions, feel free to ask in the comment section below, and trust us to respond as soon as possible. Cheers!
Question Time:
Short Answer (2-3 marks each):
- a) Explain two ways to select a specific range of cells for printing in Excel.
- b) What is the function of the “Page Break Preview” button in Excel?
- c) Briefly describe the difference between printing the “Entire Workbook” and the “Current Sheet Only” in Excel.
- d) How can you ensure important column titles appear on every page when printing an Excel worksheet?
Get more class notes, videos, homework help, exam practice on iPhone [DOWNLOAD]