Template Setup & Excel Help
Find records faster, use filters safely, print clean worksheets, and export PDF copies for sharing or archiving.
Best for: customers who need to find records, filter rows, or print/export clean copies of template worksheets.
Important: Printing and filtering steps may vary by Excel version, printer, and workbook layout.
Finding information quickly
- Use Excel search to find names, amounts, confirmation numbers, or keywords.
- Use filters to narrow by status, month, category, or person responsible.
- Clear filters before saving a final review copy unless you intentionally want only filtered rows visible.
- Use notes fields consistently so search terms are easy to find later.
Filtering safely
Filters are helpful, but they can confuse users if a worksheet is saved while rows are hidden. Before sending a workbook to someone else, clear filters or include a note explaining that the sheet is filtered.
Printing or exporting
- Open the tab you want to share. Use the dashboard, summary, or final checklist tab if the recipient does not need raw data.
- Preview before printing. Check page breaks, orientation, and whether columns fit.
- Adjust scaling carefully. Fit-to-page can make text too small. Use landscape orientation when a worksheet is wide.
- Export to PDF. PDF copies are useful for final records because they preserve the view at the time of export.
- Keep the editable workbook. Do not replace your Excel file with only a PDF. Keep both if you may need to update the data later.
What to print
Print the dashboard, summary, and open questions.
Export the completed checklist and confirmation logs.
Send summary pages plus source documents they request.
Send screenshots or PDF views of the tab with the issue.
FAQ
Why does my printout cut off columns?
The worksheet may be wider than the page. Try landscape orientation, narrower margins, or export only the summary tab.
Why are some rows missing?
A filter may be active or rows may be hidden. Clear filters and check hidden rows before printing.
Can I send only a PDF?
For final review, yes. For editing or corrections, send the workbook too if the recipient needs it.
How do I print just one section?
Select the section and use the print selection option, then preview before exporting.
Should I print sensitive information?
Only print what is needed and store paper copies securely.
Was this tutorial helpful?
Your feedback helps improve the KanderBooks tutorial library.