✦Template Printable Ideas Insights

Mastering Excel: Create Your Own Check Template in 5 Steps

By

Creating a check template in Excel can save you time and ensure consistency when writing checks for various purposes. In this guide, we'll walk you through a straightforward process of making a check template in Excel, step by step. Let's dive in!

Before we start, ensure you have Microsoft Excel installed on your computer. This guide uses Excel 2016, but the process is similar in other versions. Now, let's create a simple, customizable check template.

Setting Up the Check Template

We'll begin by setting up the basic structure of the check. Open your Excel workbook, select a sheet, and ensure your cursor is on cell A1. This will be the top-left corner of your check template.

Microsoft Excel Check Register Template
Microsoft Excel Check Register Template
How to Insert a Checkbox in Excel (In 5 Easy Steps)
How to Insert a Checkbox in Excel (In 5 Easy Steps)
Free Check Register Excel Template
Free Check Register Excel Template

First, adjust the page layout and orientation. Go to the 'Page Layout' tab, click on 'Orientation,' and choose 'Landscape.' This will ensure your checks fit the standard check size when printed.

Defining the Check's Dimensions

Check dimensions typically follow the standard checks measure: 6.375 x 3.125 inches (roughly 162 x 79 mm). In the 'Home' tab, click on 'Chart Tools' in the 'Styles' group, then select 'Format Selection.' In the 'Format Selection' panel, click on 'Size,' then set the width to 6.125 inches (156 mm) and height to 3.125 inches (79 mm). Click 'OK.'

How to Insert a Checkbox in Excel (In 5 Easy Steps)
How to Insert a Checkbox in Excel (In 5 Easy Steps)
insert checkbox
insert checkbox
Checkboxes in Excel‼️ #excel
Checkboxes in Excel‼️ #excel

To add a border, select the range A1:K9, go to the 'Home' tab, click on 'Borders,' and choose 'All Borders.' This will add borders around your template.

Adding Check Elements

Now, let's add essential elements to your check template: the check number, date, pay to the order of, amount, and memo fields. In cell A2, type "Check Number," and format it as text. In cell B2, type "Date," and format it as a date. Fill in the other cells with appropriate labels and formats:

Cell Label Format
C2 Pay to the Order of Text
D2 Amount Currency
F2 Memo Text

Center the text in these cells for better appearance. You can do this by selecting the cells, right-clicking, and choosing 'Format Cells.' Go to the 'Alignment' tab and click on 'Merge & Center.'

Insert a Checkbox in a Cell in Excel
Insert a Checkbox in a Cell in Excel
The simple way to add check marks in Excel!
The simple way to add check marks in Excel!
7 Easy Ways to Insert Check Mark (Tick ✓) Symbol in Excel
7 Easy Ways to Insert Check Mark (Tick ✓) Symbol in Excel
Paycheck Template Microsoft Excel Cheque Payroll PNG
Paycheck Template Microsoft Excel Cheque Payroll PNG
A Better Excel Checkbook Register Spreadsheet - Part 1
A Better Excel Checkbook Register Spreadsheet - Part 1
How to Insert a Checkbox in Excel In 3 Simple Steps
How to Insert a Checkbox in Excel In 3 Simple Steps

Making the Check Template Interactive

To make your check template more dynamic, you can add formulas to auto-calculate the amount in words and check total. This helps ensure accuracy and saves you time.

In cell D3, type "=PROPER(APPOINTMENT!A2&A1)&" and press 'Enter.' This will convert the text in cells A2 and A1 to proper case and display the full name of the recipient. In cell E3, type "=CURRENCY(D2,"]")&" and press 'Enter.' This will display the amount in words.

Adding a Check Total Formula

In cell D4, type "=SUM(D2, D5, D7, D9)" and press 'Enter.' This formula will automatically calculate and display the total amount for all checks selected (assuming you're including this formula in each check row).

an excel spreadsheet with the vacation checklist option highlighted in red and green
an excel spreadsheet with the vacation checklist option highlighted in red and green
How to create an excel checkbook register
How to create an excel checkbook register
Check Request Form | Template Business
Check Request Form | Template Business

To make the check template even more user-friendly, you can add data validation to restrict input types. For example, you can prevent users from entering non-numeric values in the 'Amount' field. Select cell D2, click on the drop-down arrow in the 'Data' tab, then 'Data Validation.' In the 'Settings' tab, choose 'Whole Number,' and click 'OK.' Repeat this process for the other 'Amount' fields (D5, D7, D9).

Customizing the Check Template

You can further customize your check template by adding your logo, business name, and contact information. To add a logo, click 'Insert' in the 'Home' tab, then 'Picture.' Select your logo from your computer and adjust its size. Add your business name and contact information in the desired cells.

Finally, save your check template by clicking on 'File,' then 'Save As.' Choose a folder, name your template, select 'Excel Macro-Enabled Template (*.xlsm)' in the 'File Format' drop-down, and click 'Save.' Now, you can reuse this template to create checks quickly and efficiently!

Whenever you need to create a new check, simply open your check template, fill in the necessary information, and print. By following this guide, you've created a customizable, interactive check template in Excel that will save you time and ensure consistency. Happy checking!