How to Print Labels from Excel - Excel Labels Guide (2024)

SHOP NOW

SHOP NOW

Yes. Whether making address or barcode labels, you can print labels directly from Excel without going to Word. You have multiple options when printing labels directly from Excel.

You can create labels by manually formatting the cells and contents in the spreadsheet and layout the document to print to your desired paper size in the Page Layout Menu.

You can also create labels through Macros or VBA to create a template that you can use anytime without going through all the formatting commands and steps. This tool can be useful if you constantly use Excel to print similar information.

In this article, we will learn how to print labels from Excel directly using its basic formatting tools.

You can print labels from an Excel spreadsheet in two ways.

1. 1. Print labels from Excel Using Word
   2. Print labels from Excel directly

1. 1. Open Excel.
   2. Click Blank Workbook.
   3. Enter and organize your data according to categories or import data from an app.
   4. Click File > Save.
   5. Close the workbook.

1. Open MS Word.

2. Click New Document.

3. Go to Mailings > Start Mail Merge > Step-by-Step Mail Merge Wizard.

4. Select Labels.

5. Select Starting document > Label Options. Choose your Label vendors and Product number. Click OK after you have chosen your label size.

6. Click Select recipients > Browse. Select the appropriate spreadsheet file and then OK > OK.

7. To customize your labels, click Arrange your labels > Address block and add or remove recipient information. Click OK. To replicate the first label, select Update all labels.

8. To edit the layout of your labels, click Preview your labels.

9. Click Complete the progress.

10. To print, click Print > OK > OK to print your labels.

11. To save, click File > Save.

1. Open Excel.

2. Click Blank Workbook.

3. Insert Data in Column A.

4. Press Alt + F11 to open the VBA Window.

5. Right-click the sheet that contains your label data.

6. Go to Insert > Module to open a module to create VBA Code for labels.

‘This Code Will Create Labels in Excel

Sub Createlabels()

Application.Run “AskForColumn”

Cells.Select

Selection.RowHeight = 75.75

Selection.ColumnWidth = 34.14

With Selection

.HorizontalAlignment = xlCenter

.VerticalAlignment = xlBottom

.WrapText = False

.Orientation = 0

.AddIndent = False

.IndentLevel = 0

.ShrinkToFit = False

.ReadingOrder = xlContext

.MergeCells = False

End With

With Selection

.HorizontalAlignment = xlCenter

.VerticalAlignment = xlCenter

.WrapText = False

.Orientation = 0

.AddIndent = False

.IndentLevel = 0

.ShrinkToFit = False

.ReadingOrder = xlContext

.MergeCells = False

End With

End Sub

Sub AskForColumn()

Dim refrg As Range

Dim vrb As Long

Dim dat As Long

Set refrg = Cells(Rows.Count, 1).End(xlUp)

dat = 1

On Error Resume Next

incolno = InputBox(“Enter Number of Columns Desired”)

For vrb = 1 To refrg.Row Step incolno

Cells(dat, “A”).Resize(1, incolno).Value = _

Application.Transpose(Cells(vrb, “A”).Resize(incolno, 1))

dat = dat + 1

Next

Range(Cells(dat, “A”), Cells(refrg.Row, “A”)).ClearContents

End Sub

Source: Exceldemy.com

8. Press F5 and select Createlabels ().

9. Click Run.

10. Type 3 in Enter Number of Columns Desired.

11. Click OK.

12. Click File > Print.

13. Select the printer you want to use and customize the settings.

14. Click the Print Icon.

SHOP NOW

SHOP NOW

1. Open Excel.

2. Click Blank Workbook.

3. Insert Data in Column A.

4. Click Page Layout > Margins > Custom Margins.

5. For address labels, enter 0.5 in the Top and Bottom margin fields and 0.215 in the Left and Right margin fields.

6. Click OK.

7. Click File > Print.

8. Select your printer.

9. Click No Scaling > Fit All Columns in One Page.

10. Click the Print Icon.

You can create Avery labels from an Excel Spreadsheet by using Mail Merge in Microsoft Word or by printing directly from Excel.

From Word, you can choose different label brands and product numbers. You can select the Avery label template that suits your needs.

You can also develop a code from Excel that corresponds to the label dimensions and print directly without using Word.

You can also export data from your Excel and print them using Avery label makers and other third-party label software.

Here is how to print labels from Excel to Word using an Avery label.

1. Open MS Word.
2. Click New Document.
3. Go to Mailings > Start Mail Merge > Step-by-Step Mail Merge Wizard.
4. Select Labels.
5. Select Starting document > Label Options. Choose Avery standard under label options and the Avery product number. Click OK after you have chosen your label size.
6. Click Select recipients > Browse. Select the appropriate spreadsheet file and then OK > OK.
7. To customize your labels, click Arrange your labels > Address block and add or remove recipient information. Click OK. To replicate the first label, select Update all labels.
8. To edit the layout of your labels, click Preview your labels.
9. Click Complete the progress.
10. To print, click Print > OK > OK to print your labels.
11. To save, click File > Save.

1. Open Word.
2. Open a Blank Document.
3. Click Tools > Mail Merge Manager.
4. In Mail Merge Manager, click Create New > Labels.
5. Select Dot Matrix or Laser and inkjet Printer in the Printer Information.
6. Choose from the Label products. If using Avery, click Avery standard.
7. Choose the Avery product number of the label you are going to use. For example, click 5160 – Address for the standard address labels. This action will open the template of the selected product number in your document.
8. Under Select Recipients List, click Get List > Open Data Source.
9. Choose a Data file that contains the spreadsheet of your mailing list, then click Open. Click OK until it opens an Edit Labels box.
10. Click Insert Merge Field and click on the information you want to include in your address labels. Click OK once you have incorporated the fields you want to show on your labels.
11. In Filter Recipients, select the addresses you want to include and exclude.
12. Click the Preview button. Once the addresses appear in your document, you can customize the labels by formatting the font style and size.
13. Click the Merge to New Document button.
14. Click File > Print. Follow the prompts and click Print once all is ready.
15. Click File > Save As if you want to save the file template.

FacebookTwitterYoutubeInstagram