How to Print Address Labels in Excel

Printing address labels is a task that is typically done in a word processing program, such as Microsoft Word. If you prefer to work in Microsoft Excel, however, you might appreciate finding out how to make and print address labels using Excel. You can even record a macro while setting up the labels to perform the task again in the future, or save the set-up worksheet as a template.

Things You'll Need

• Microsoft Excel 2003 2007
• Printer
• Avery brand 5160 labels, or another brand of the same size

Instructions

1. 

   Open a blank worksheet in Excel. Go to the "File" menu, click on "Page Setup" and go to the "Margins" tab in Excel 2003. In Excel 2007, go to the "Page Layout" tab and click "Margins."

2. 

   Enter "0" in the Top and Bottom boxes. Change the margins in the left and right boxes to ".19." Under Center on Page, select "Horizontally" and "Vertically." Apply these changes by clicking "OK."

3. 

   Select cells A1 through A10 with the mouse. Go to the "Format" menu in Excel 2003, point to "Row" and select "Height." In Excel 2007, click "Format" on the Home tab and click "Row Height." Enter "72" and click "OK." In the same manner, change the Column Width to 35. Repeat the steps in cells C1 through C10 and E1 through E10.

4. 

   Use the mouse to select the cells in B1 through B10. Change the width of the column to 1.29. Repeat with cells D1 through D10.

5. 

   Select all of the cells from A1 through E10 with the mouse. Click the "Borders" drop-down on the Format toolbar in Excel 2003 or the Font group on the Home tab in Excel 2007. Click "All Borders."

6. Enter the names and addresses into the label cells. The cells in columns A, C and E are the label areas. Columns B and D are the margins between labels. Print onto the label paper.

Resources

• Find address labels here.