How to Print Address Labels in Excel

It's common to use data in an Excel workbook in tandem with address label forms in Word using a process called mail merge. Working exclusively in Excel requires more formatting and a bit of trial-and-error with printing. However, this is a one-time setup, and your workbook can be saved and used as a template for short runs of manually entered address labels any time. This example uses labels compatible with Avery's 5160 label layout.

Set Up the Label Page

Step

Select the range from cell A1 to cell C10. This highlights a grid of 30 cells, corresponding to the 30 cells on a 5160-style sheet of labels.

Selecting 30 Cells
credit: Image courtesy of Microsoft
Setting the margins
credit: Image courtesy of Microsoft

Step

Set the margins by first clicking the Page Layout tab on the ribbon then Margins. Enter the following values:

Step

  • Top and Bottom: 0.5 inches
  • Left and Right: 0.19 inches
  • Center on page: check both boxes

Step

Click OK when you're done.

Setting Column Width
credit: Image courtesy of Microsoft

Step

Click column A in the column headers and drag to column C to select the three columns of labels. Right-click the highlighted columns and select Column Width. Enter a value of 32 and click OK.

Step

Click row 1 in the row headers and drag to row 10 to select the 10 rows of labels. Right-click the highlighted rows and select Row Height. Enter a value of 73 and click OK.

Formatting Cells
credit: Image courtesy of Microsoft

Step

Select all label cells by clicking cell A1 and dragging to C10. Right-click the highlighted cells and select Format Cells.

Alignment Changes
credit: Image courtesy of Microsoft

Step

Select the Alignment tab and set both horizontal and vertical text alignment to Center. Check the Wrap text box. The workbook is now ready for data entry. Save the blank workbook to use as a template by clicking File and Save As. Select a location and a name for your mailing label template.

Entering Data
credit: Image courtesy of Microsoft

Step

Use the template by entering name and address data directly in each of the 30 cells. Move between cells by clicking Enter. To format name and address within a cell, add spaces to bump data to the next line.

Printing the Labels
credit: Image courtesy of Microsoft

Step

Click File on the ribbon and click Print. The print screen shows your labels as they will be printed. Check that the formatting for each label is correct. There is no need to change default printer settings. Load 5160-compatible labels into your printer. Select it on the Print menu and click Print.