docs / articles / How to Create a Print Template in Excel

How to Create a Print Template in Excel

Sara Jul 09, 2026 2026-07-09 04:40:45

Creating print-ready templates in Excel can save you time and ensure consistency in your documents. Whether you're designing invoices, reports, or labels, mastering Excel's print settings and features will help you create professional-looking outputs. Let's dive into the step-by-step process of creating a print template in Excel.

Print Sheets in Excel
Print Sheets in Excel

Before we begin, ensure you have the latest version of Excel installed on your computer. This guide uses Microsoft Excel 2019 as a reference, but the steps are similar in other versions. Now, let's get started!

How to Print in Excel - Step-by-Step Guide?
How to Print in Excel - Step-by-Step Guide?

Setting Up Your Excel Workbook

First, open a new or existing workbook in Excel. For this example, let's assume you're creating an invoice template. Start by deleting any unnecessary sheets and renaming the remaining ones to reflect their purpose, such as "Invoice," "Payment Terms," or "Customer Information."

How to make printables in Microsoft Excel (step by step tutorials) - All About Planners
How to make printables in Microsoft Excel (step by step tutorials) - All About Planners

Next, organize your data and formatting. Use tables for structured data, and apply consistent fonts, colors, and styles throughout your workbook. This will make your template easy to read and maintain.

Defining Print Areas

Print Sheets in Excel
Print Sheets in Excel

Excel allows you to set specific areas within a worksheet to print. This is particularly useful when you want to exclude certain data or elements from the printed output. To define a print area, select the cells you want to print and click on the "Page Layout" tab in the Excel ribbon. Then, click on "Print Area" and select "Set Print Area."

To remove a print area, follow the same steps and choose "Clear Print Area" instead. You can also adjust print areas for individual sheets or the entire workbook using the "Print" dialog box (File > Print > Print dialog box).

Formatting for Print

an image of how to create an editable ppd in photoshopped text
an image of how to create an editable ppd in photoshopped text

Ensure your template looks good on paper by adjusting the page orientation, margins, and scaling. To change the page orientation, select the "Page Layout" tab, click on "Orientation," and choose "Portrait" or "Landscape."

To adjust margins, click on "Margins" in the "Page Layout" tab and select a predefined setting or customize them manually. You can also change the scaling factor to fit your content better on the page. To do this, go to the "Scale to Fit" option in the "Page Layout" tab and choose "Fit to" or "Fit to width/height."

Adding Print-specific Elements

How To Create A Printable Daily Planner In Excel
How To Create A Printable Daily Planner In Excel

Now that you've set up the basic structure of your template, it's time to add elements that will only appear when printed. These can include headers, footers, page numbers, and watermarks.

To add headers and footers, click on the "Insert" tab in the Excel ribbon, then click on "Header" or "Footer" in the "Text" group. Choose a predefined design or create your own using the "Edit Header" or "Edit Footer" dialog boxes. You can include page numbers, dates, file names, or custom text in your headers and footers.

[FREE] 141 Free Excel Templates and Spreadsheets
[FREE] 141 Free Excel Templates and Spreadsheets
Free Monthly Budget Excel Spreadsheet
Free Monthly Budget Excel Spreadsheet
a computer screen with the words how to make planner inserts in microsoft excel on it
a computer screen with the words how to make planner inserts in microsoft excel on it
How To  Print Large Excel Sheet | One Page Print Setup (Excel Tips & Tricks)
How To Print Large Excel Sheet | One Page Print Setup (Excel Tips & Tricks)
Printing Excel Spreadsheet: Everything You Need to Know
Printing Excel Spreadsheet: Everything You Need to Know
101 Ready Made Excel Templates!
101 Ready Made Excel Templates!
How To Create an Invoice in Excel + Free Invoice Template Download
How To Create an Invoice in Excel + Free Invoice Template Download
7 Excel Printing Tips: How to Print Your Spreadsheet Step-by-Step
7 Excel Printing Tips: How to Print Your Spreadsheet Step-by-Step
How to Add a Printable Background in Excel (+ video tutorial)
How to Add a Printable Background in Excel (+ video tutorial)
how to print large excel sheet in one page
how to print large excel sheet in one page
How to Quickly Create a Custom Excel Template to Save Time
How to Quickly Create a Custom Excel Template to Save Time
Create a Project Tracker Template in Excel for Efficient Project Management
Create a Project Tracker Template in Excel for Efficient Project Management
The 10 best free templates you should get for Excel
The 10 best free templates you should get for Excel
How to Create Invoice Bill in Excel & Numbers on Mac & PC
How to Create Invoice Bill in Excel & Numbers on Mac & PC
Printing Excel Spreadsheet: Everything You Need to Know
Printing Excel Spreadsheet: Everything You Need to Know
Pieter (haasbroekpieter) - Profile | Pinterest
Pieter (haasbroekpieter) - Profile | Pinterest
How to Set the Print Area in Excel (with pictures)
How to Set the Print Area in Excel (with pictures)
#projectmanagement #projectmanagementtools #management #projectmanagers #managers #engineers #project #construction #civilengineering #civil #dashboard #data #datamanagement #excel #exceltemplates | Tariq Noor
#projectmanagement #projectmanagementtools #management #projectmanagers #managers #engineers #project #construction #civilengineering #civil #dashboard #data #datamanagement #excel #exceltemplates | Tariq Noor
Excel Formula Cheat Sheet Printable - Excel Functions Guide PDF - Excel Reference Sheet Digital Download
Excel Formula Cheat Sheet Printable - Excel Functions Guide PDF - Excel Reference Sheet Digital Download

Watermarks

Watermarks are semi-transparent images or text that appear behind your content. To add a watermark, click on the "Page Layout" tab, then click on "Watermark" in the "Page Background" group. Choose an option from the list or click on "Custom Watermark" to add your own text or image.

Watermarks are a great way to add branding or disclaimers to your printed documents. However, keep in mind that they might not be visible in all printers or copiers, and some may print the watermark as a solid image instead of a semi-transparent one.

Page Breaks

Page breaks help control how your content flows onto multiple pages. To insert a manual page break, select the cell where you want the page to break and click on "Breaks" in the "Page Layout" tab. Then, choose "Insert Page Break." You can also remove page breaks using the same method.

Excel automatically adds page breaks based on the print area you've defined. However, you can manually adjust them to better control the layout of your printed document.

Protecting Your Template

Once you've created your print template, it's essential to protect it from accidental changes. To do this, select the cells you want to protect and click on the "Home" tab in the Excel ribbon. Then, click on "Format" and choose "Lock Cell" or "Lock Cells."

You can also protect entire sheets or the entire workbook using the "Review" tab in the Excel ribbon. Click on "Protect Sheet" or "Protect Workbook" and set a password to prevent unauthorized changes.

Congratulations! You've now created a professional print template in Excel. By following these steps and customizing your template to fit your specific needs, you'll save time and ensure consistency in your printed documents. Happy printing!