label printing from excel

Question

label printing from excel

Chris Coventry 0

im printing labels from excel. i have like 6 pages. the first page i needed to hit enter to add a line for them to lineup on the label correctly. the first sheet is correct but i cant get the remaining pages to allow me to add a line to get them lined up

Ryan-N 16,110 Reputation points Microsoft External Staff Moderator

2026-01-15T20:36:16.4966667+00:00

Hi @Chris Coventry,

I hope everything is going well on your end.

I’m following up on the support thread we've been working through together. I wanted to check in and see if the information I shared in my previous answer helped resolve the issue you were experiencing.

If you're still experiencing any issues or have further questions, please feel free to reach out at any time. I’m always happy to help if you need anything else.

We want to ensure everything is functioning smoothly and that your experience remains seamless.

Thank you again for your collaboration throughout the troubleshooting process. I look forward to hearing from you soon.

Warm regards,
Faizan Kamal 5 Reputation points

2026-08-28T13:43:28.7166667+00:00

The reason page 1 lines up and the rest don't is that Excel isn't laying out a label sheet, it's flowing rows and breaking pages wherever they happen to land. Adding a blank row to fix page 1 pushes everything below it, so page 2 goes off, and fixing page 2 breaks page 3. Every fix moves the next one. Excel has no concept of a fixed grid position on the page, which is why this doesn't converge.

To answer your other question: Avery 5160 is 30 labels per sheet, 3 across and 10 down, each 2.625" × 1", on US Letter. The first label starts 3/16" from the left edge and 1/2" from the top, and rows sit on an exact 1" pitch with no gap between them. There's no gutter to absorb error, which is why small drift shows up badly by the bottom row.

You can build that in Excel with fixed row heights and column widths, but you'd need to disable every automatic adjustment and it'll break again the next time the data changes. Mail merge is the usual answer, though it's a lot of steps for placing text in a grid.

Third option, if you just want the labels: I built a free browser tool that takes your list and produces a positioned 5160 PDF directly, paste a column from Excel, download, print at 100% with Fit to Page off. https://getlabelmerge.com/avery-5160-label-template/ It also handles partial sheets if you've already used some labels. Runs entirely in your browser, nothing uploaded. (Disclosure: its free, no signup.)

3 answers

Your answer

Ryan-N 16,110 Reputation points Microsoft External Staff Moderator

2026-01-15T20:36:16.4966667+00:00

Hi @Chris Coventry,

I hope everything is going well on your end.

I’m following up on the support thread we've been working through together. I wanted to check in and see if the information I shared in my previous answer helped resolve the issue you were experiencing.

If you're still experiencing any issues or have further questions, please feel free to reach out at any time. I’m always happy to help if you need anything else.

We want to ensure everything is functioning smoothly and that your experience remains seamless.

Thank you again for your collaboration throughout the troubleshooting process. I look forward to hearing from you soon.

Warm regards,
Faizan Kamal 5 Reputation points

2026-08-28T13:43:28.7166667+00:00

The reason page 1 lines up and the rest don't is that Excel isn't laying out a label sheet, it's flowing rows and breaking pages wherever they happen to land. Adding a blank row to fix page 1 pushes everything below it, so page 2 goes off, and fixing page 2 breaks page 3. Every fix moves the next one. Excel has no concept of a fixed grid position on the page, which is why this doesn't converge.

To answer your other question: Avery 5160 is 30 labels per sheet, 3 across and 10 down, each 2.625" × 1", on US Letter. The first label starts 3/16" from the left edge and 1/2" from the top, and rows sit on an exact 1" pitch with no gap between them. There's no gutter to absorb error, which is why small drift shows up badly by the bottom row.

You can build that in Excel with fixed row heights and column widths, but you'd need to disable every automatic adjustment and it'll break again the next time the data changes. Mail merge is the usual answer, though it's a lot of steps for placing text in a grid.

Third option, if you just want the labels: I built a free browser tool that takes your list and produces a positioned 5160 PDF directly, paste a column from Excel, download, print at 100% with Fit to Page off. https://getlabelmerge.com/avery-5160-label-template/ It also handles partial sheets if you've already used some labels. Runs entirely in your browser, nothing uploaded. (Disclosure: its free, no signup.)

Answer 1

Hi @Chris Coventry,

Welcome to the Microsoft Q&A forum.

Thank you for reaching out to us. I’d like to provide you with the following information:

To print Avery 5160 labels from Excel, you can use Mail Merge so that Excel automatically creates the standard label grid for you.

Prepare your data in Excel

Each row represents one label.
Columns contain the information you want to print (e.g., Name, Address).

Open Word → Mailings → Start Mail Merge → Labels

Select Label Options → Manufacturer: Avery US Letter → Template: 5160 Address Labels.

Choose the data source

Go to Mailings → Select Recipients → Use an Existing List → Choose your Excel file.

Insert merge fields

Use Insert Merge Field to add columns from Excel into the labels.

Preview the labels

Click Preview Results to see how the labels will look with actual data.

Complete the merge

Once you’re satisfied with the preview, click Finish & Merge to print the labels or edit individual labels if needed.

You can refer to the following documentation on Mail Merge: https://support.microsoft.com/en-us/office/mail-merge-using-an-excel-spreadsheet-858c7d7f-5cc0-4ba1-9a7b-0a948fa3d7d3

I hope this information is helpful. Please follow these steps and let me know if it works for you. If not, we can work together to resolve this.

Thank you for your patience and understanding. If you have any questions or need further assistance, please feel free to share them in the comments on this post so I can continue to support you.

I look forward to continuing the conversation.

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Chris Coventry 0

what page layout do i need for avery 5160 labels

0 comments

Answer 3

When printing labels from Excel, if you need to adjust the alignment for multiple pages, you can try the following steps:

Check Page Layout: Ensure that your page layout settings are consistent across all sheets. Go to the Page Layout tab and check the margins, orientation, and size settings.
Use the Same Row Height: Make sure that the row heights are the same on all sheets. You can select the rows, right-click, and choose Row Height to set it uniformly.
Insert Rows: If you need to add lines for alignment, you can right-click on the row number where you want to insert a new line and select Insert. This will add a new row above the selected one.
Copy Formatting: If the first sheet is correct, you can copy the formatting from the first sheet to the others. Select the correctly formatted rows, right-click, and choose Copy. Then, select the same rows on the other sheets, right-click, and choose Paste Special > Formats.
Print Preview: Use the Print Preview feature to check how the labels will look before printing. This can help you identify any alignment issues.

By following these steps, you should be able to align the labels correctly across all pages.

References:

Create Address Labels from a Spreadsheet