Printable Spreadsheet TemplatesJul 12, 2021
Printable Spreadsheet Templates
Spreadsheets are an integral part of the modern workplace. A printable spreadsheet template can be used to organize your data, create charts and graphs, and help you make sense of complex calculations.
Common uses of printable spreadsheet templates are sharing reports with colleagues and manual data entry.
In this post we're going to explore all things printable spreadsheets, including five templates with a Print button directly on it.
It's worth noting that every spreadsheet template is printable. Here is how you can print your spreadsheet.
How do I Print an Excel Spreadsheet?
1) In Excel, click on "File" and then select "Print." You should see a print preview window.
2) Click the button that says "Selection," which will highlight cells in your spreadsheet for you to print.
3) You can delete what's highlighted by clicking it again or move it by dragging it with your mouse pointer.
4) Press OK when finished. A Microsoft print dialog box should pop up asking you where to print-to—make sure this is set correctly before continuing! Hit Print when ready to start printing at the specified location.
Depending on your spreadsheet, you may want to only print certain elements or cells. Let's walk through how you can limit it to a specific page.
How Can I limit My Excel Spreadsheet to Just the Printable Page?
In Microsoft Excel, printable areas are the cells that you can print. In order to print a spreadsheet so only your printables show up, follow these steps:
1) Click on the "Page Layout" tab
2) Under "Print what," select "Selection." This will highlight all of the printable cells in your spreadsheet. You can then delete or manipulate those highlighted cells as desired.
3) Double click outside of any cell and press OK when finished with the dialog box pop up asking where to print from (make sure this is set correctly before continuing). Hit Print when ready to start printing at the specified location.
Printable Spreadsheet Templates
1. Check Sheet
A Check Sheet is primarily used in relation to quality control. Also known as a Tally Sheet, you can simply add a 'tally' to mark a defect type.
This template comes blank and can either be filled out through Excel directly, or can easily be printed and shared with your team on the manufacturing floor who can record it by hand.
One of the benefits of using the Excel template is it automatically generates a Pareto graph so you can easily identify where the root of your quality issues originate. You can also fill it out manually and add your entries to Excel at the end of the week so it automatically generates your graphs and charts.
2. Customer Sales Transaction
Our Customer Sales Transaction Excel Template comes with a sheet to create invoices.
Whether your business is wedding photography, roofing or freelancing, your customer will likely want to view their invoice. You can click Print Invoice and and easily send it to them via mail or deliver it to them.
Easily track and print your working hours with this HR-friendly Excel template. Our Employee Timesheet allows you to record your regular hours, break hours and overtime hours for up to a month at a time.
Whether you are a contract worker or simply asked to provide hours to your boss, you can click the Print button and whoa-la, a perfectly formatted table with your hours.
Documenting processes is crucial for scaling efficiently, but in order to do that you must have transparency into what triggers certain actions.
Our Flow Chart Diagram contains a Print button so you can easily share your processes with your team and all related parties.
This template contains Print buttons on every sheet - Inventory, Supplier, Invoice, Order and Barcode. As many times you'll want to be free to explore your warehouse without needing your tablet or laptop in front of you, you can print off any number of those sheets to confirm any number of data points necessary to your warehouse management.
Perhaps you have your own spreadsheet at work you frequently print. Rather than go through the multiple steps needed to print a spreadsheet, you can add a macro that streamlines your workflow. Let's walk through how you can add a print button in your spreadsheet.
How Do I add a Print Button in My Excel Spreadsheet Using Macros?
1) Open the print dialog box (File > Print)
2) Choose “Selection” from the print area in top toolbar. This will print only what you have selected on your spreadsheet, not everything that has been shown in Excel.
3) Click on Properties (in the same menu as File and Edit). A small window pops up with various tabs to choose from at the bottom of it. Clicking Options will allow you to select how many copies are printed and where they should be sent.Click OK when finished making adjustments and close out of this pop up window to return back into Microsoft excel. - In cell B24 type a command =PRINT("filename") which is followed by the highlighted cells that you want to print.
4) Click on the arrow button from B24 and drag it over so it includes all of the cells in your spreadsheet, excluding column A (this is where we will add our printable file name).
5) Paste “filename” into cell A25. This should be followed by a comma after this text as its own separate entry in row 25 which may not have any data or formulas yet if they are blank for now. Copy these two characters separately with no spaces between them when pasting: ","(comma) "&" (ampersand), then paste again afterwards with another space separating each one of these symbols, just like this: ", &". - Press enter on your keyboard to insert the printable filename from cell A25 into row 26.
6) Double click on cell B26, then write: "Please enter a printable file name".
7) Press enter and double click again in column C, then write: "by filling out this form".
8) Continue following these steps until you've filled all of the cells with formulas that will print off when submitted - just make sure to leave some blank rows if you'll need space for more printables or additional information later.
81% of companies across the use Microsoft Excel.
Mastering Excel can increase your earnings up to 4x over the course of your career!
Bottom Line: It pays to master Excel. Take our world-class Excel University and take your spreadsheet skills to the next level.
Get 5 FREE Excel Templates and Trainings
What email do you want us to send your access to?
We hate SPAM. We will never sell your information, for any reason.