How to Make a Label Template in Excel

Trying to print a batch of address labels doesn't need to involve paid software or complicated design tools. You can actually build a flexible, reusable label template right inside Microsoft Excel, the spreadsheet tool you already know. This guide will show you exactly how to set up your sheet, create a template from scratch tailored to your specific labels, and even pull in data for a mail merge.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

First Things First: Gather Your Measurements

Before you even open Excel, grab the package of label paper you'll be using (like Avery, Uline, or any other brand). To build an accurate template, you need exact measurements from a single sheet. Find a good ruler and jot down the following details:

• Label Width: The width of a single label.
• Label Height: The height of a single label.
• Top Margin: The distance from the top edge of the paper to the top of the first row of labels.
• Left Margin: The distance from the left edge of the paper to the left side of the first column of labels.
• Horizontal Gap: The space between two labels side-by-side (from the right edge of one to the left edge of the next).
• Vertical Gap: The space between two labels stacked on top of each other (from the bottom edge of one to the top edge of the one below it).

Having these precise numbers handy is the key to creating a template that lines up perfectly when you print.

Setting Up Your Excel Worksheet for Labels

Now it's time to translate those physical measurements into a digital grid. This part is about preparing your canvas before you add any data.

Step 1: Switch to Page Layout View

Regular Excel view is an endless grid of cells, which isn't helpful for this task. You need to see the boundaries of your physical paper.

Go to the View tab on the Ribbon and select Page Layout. Your spreadsheet will instantly transform to look like a series of pages. This view is incredibly helpful because it displays rulers along the top and side showing measurements in inches (or your system's default unit), making our job much easier.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

Step 2: Configure Your Page Margins

Next, let's adjust the page margins to match the measurements you just took.

1. Navigate to the Page Layout tab.
2. Click on Margins, then select Custom Margins... at the bottom of the dropdown menu.
3. In the Page Setup window that appears, punch in the Top and Left margins you measured from your label sheet. You can also input the Right and Bottom margins if you have them, but the Top and Left are the most important for starting your grid accurately.
4. Click OK. You'll see the working area of your sheet adjust.

Step 3: Set Column and Row Sizes to Match Your Labels

This is where your template truly takes shape. We are going to resize the cells to match the physical dimensions of your labels and the gaps between them.

Let’s assume your label sheet has 3 columns and 10 rows of labels.

To set column widths:

• Your first label is in column A. Click the header for column A to select it. Move your cursor to the right edge of the header until it becomes a double-sided arrow. Click and drag to resize it. As you do, a small tooltip will appear showing the current width in inches. Adjust it until it matches your measured Label Width.
• Your first horizontal gap is in column B. Select column B and resize it to match your measured Horizontal Gap.
• Continue this pattern across the page. For a 3-column label sheet, you'd set the width for columns A, C, and E to your Label Width, and columns B and D to your Horizontal Gap width.

To set row heights:

• Click the header for row 1 to select it. Move your cursor to the bottom edge of the row header until you see the double-sided arrow.
• Drag to adjust the height until it matches your measured Label Height.
• Your first vertical gap will be in row 2. Select row 2 and resize its height to match your Vertical Gap measurement.
• Repeat this pattern down the page. Set your main rows (1, 3, 5, etc.) to the Label Height and spacer rows (2, 4, 6, etc.) to the Vertical Gap height.

When you're done, your Excel grid should look like a digital twin of your physical label sheet, with large cells for the labels and thin blank cells for the gaps.

Adding Your Content to the Labels

With the template built, now comes the easy part: adding text. How you do this depends on whether you're printing the same information on every label or pulling data from a list.

For Identical Labels (like Return Addresses)

If you're making repeat labels, your job is simple.

1. Click into the first label cell (A1 in our example).
2. Type your content. If you need to create a new line within the same cell (for example, to separate a name from an address), press ALT + ENTER. This creates a line break inside the cell.
3. Once you're happy with the first label, copy the cell (Ctrl+C).
4. Select all the other big "label" cells on your sheet (holding Ctrl while clicking allows you to select non-adjacent cells like A3, C1, C3, etc.) and paste (Ctrl+V).

A quick tip: to ensure all other labels update automatically if you change the original, select the second label cell (say, C1) and type =A1. Then, drag that formula to the other label cells. Now, any edit you make in A1 will instantly appear on all other labels.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

For Unique Labels From a List (Mail Merge from Data)

This is where Excel really shines. Let's say you have a list of contacts you want to create address labels for.

Step 1: Organize Your Data in a New Tab

First, create a separate tab in your workbook and call it "Data." This keeps everything clean. Set up your data in a simple table with headers like FirstName, LastName, Address, City, State, and ZIP.

Step 2: Write a Formula to Pull in the Data

Go back to your label template tab. In the first label cell (A1), we'll write a formula to combine the data from your other sheet. We use the ampersand (&) symbol to join bits of text together.

The magic ingredient here is CHAR(10), which is Excel's formula for a line break (just like ALT + ENTER).

Here's a sample formula to create a standard address block:

=Data!A2 & " " & Data!B2 & CHAR(10) & Data!C2 & CHAR(10) & Data!D2 & ", " & Data!E2 & " " & Data!F2

Let's break that down:

• Data!A2 grabs the first name from the second row of your Data sheet.
• & " " & adds a space.
• Data!B2 grabs the last name.
• & CHAR(10) & adds a line break.
• Data!C2 grabs the street address.
• ...and so on, adding spaces, commas, and line breaks where needed.

After you enter the formula, you'll need to go to the Home tab and click Wrap Text to see the line breaks correctly.

Step 3: Fill Your Label Sheet

Now, just replicate that formula for every label, changing the row number to pull the next record. For the second label (cell C1), copy the formula but change all the 2s to 3s to pull the contact from row 3 on your data sheet.

=Data!A3 & " " & Data!B3 & CHAR(10) & ... (etc.)

Continue this process for all your labels. It takes a minute to set up, but once finished, your template is populated with all your unique data.

Printing Your Labels Perfectly

You've done the hard work, but don't rush the final step. Wasting a whole sheet of labels due to a small alignment issue is frustrating.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

Step 1: Test Print on Regular Paper First

This is the most important tip. Before loading your expensive label stock, print your sheet on a plain piece of A4 or Letter paper. Then, hold this printed page up against a blank label sheet, backed by a window or a bright light. This will show you exactly how well your content lines up with the physical labels.

Step 2: Make Tiny Adjustments as Needed

If the alignment is slightly off, go back to your Excel file.

• If everything is shifted up or left, you just need to slightly increase your Top or Left margins under Page Layout > Margins.
• If the spacing between labels gets progressively worse down the page, your Row Height or Vertical Gap measurement might need a tiny adjustment.

Make one small change at a time and do another test print. A little patience here saves a lot of wasted supplies.

Final Thoughts

Setting up a label template in Excel takes some initial effort, but creating a reusable grid that perfectly matches your label sheets gives you a powerful tool for mailings, products, and organization. By leveraging the Page Layout view and getting your measurements right, you can bypass dedicated software and handle everything within a familiar spreadsheet.

While Excel is great for structured layouts like these, tying together all your business data often feels like a constant struggle. At Graphed, we built a tool to solve that. Rather than exporting CSVs from your marketing and sales platforms, we make it easy to connect your accounts and ask for dashboards and reports in plain English. For example, just ask "Show me my Facebook Ad lead conversions over the last 30 days," and Graphed builds the live dashboard for you, keeping everything in one place so you can focus on insights instead of manual reporting.