Excel, matched with high quality labels from Enko Products, provides a versatile tool for a variety of business needs from organizing data to printing labels. Dymo 30252 Large Address Labels1-1/8″ x 3-1/2″ SHOP NOW Dymo 30321 Address Labels1-4/10″ x 3-1/2″ SHOP NOW This guide outlines the steps on how to print labels from Excel. Excel perfectly suits data entry and sorting needs in neat columns and rows. With Excel, you can create and print labels within minutes directly from your spreadsheet or through Word using the Mail Merge tool. CONTENT Can you print labels directly from Excel without Word? How to print labels from an Excel spreadsheet - Option 1. How to print labels from Excel using Word - Option 2. How to print labels from Excel without Word Can you make Avery labels from an Excel spreadsheet? How to Print Labels from Excel on Mac Can you print labels with a regular printer? Can you print labels directly from Excel without Word? 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. How to print labels from an Excel spreadsheet You can print labels from an Excel spreadsheet in two ways. Print labels from Excel Using Word Print labels from Excel directly Option 1. How to print labels from Excel using Word One of the most common ways to print labels from Word is to import a mailing list created using the Excel spreadsheet. Using the Word Mail Merge tool, you can link your spreadsheet and use the data, such as the names, addresses and other customer information needed to print your labels. Here are the steps. Step 1. Set up the data in Excel. Open Excel. Click Blank Workbook. Enter and organize your data according to categories or import data from an app. Click File > Save. Close the workbook. Enko Products Mailing List Enko Products Price List Sample Barcode Spreadsheet Step 2. Use Word Mail Merge Tool to create labels in Word. 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. White Address Labels Total Labels : 3000 (100 sheets) Size (inch) : 1″ x 2-5/8″ Printer Technology : Deskjet & Laser Printers AS LOW AS $11.77/PACK Option 2. How to print labels from Excel without Word How to Print Labels from Excel without Work Using VBA Code 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. 7. Copy and paste the code below. ‘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. This VBA code contains formats of address labels for printing on a full sheet. You can change the codes depending on your type of label and printer. Compatible Brother DK-1209 Address Labels1-1/7″ x 2-3/7″ SHOP NOW Compatible Brother DK-1201 Address Labels1-1/7″ x 3-1/2″ SHOP NOW How to Print Labels in Excel Without Word Using Page Layout 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. Can you make Avery labels from an Excel spreadsheet? 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. Open MS Word. Click New Document. Go to Mailings > Start Mail Merge > Step-by-Step Mail Merge Wizard. Select Labels. 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. Click Select recipients > Browse. Select the appropriate spreadsheet file and then OK > OK. 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. To edit the layout of your labels, click Preview your labels. Click Complete the progress. To print, click Print > OK > OK to print your labels. To save, click File > Save. How to Print Labels from Excel on Mac In this guide on how to print labels from Excel on Mac, we will go through the steps using Mail Merge for Mac. Open Word. Open a Blank Document. Click Tools > Mail Merge Manager. In Mail Merge Manager, click Create New > Labels. Select Dot Matrix or Laser and inkjet Printer in the Printer Information. Choose from the Label products. If using Avery, click Avery standard. 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. Under Select Recipients List, click Get List > Open Data Source. Choose a Data file that contains the spreadsheet of your mailing list, then click Open. Click OK until it opens an Edit Labels box. 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. In Filter Recipients, select the addresses you want to include and exclude. Click the Preview button. Once the addresses appear in your document, you can customize the labels by formatting the font style and size. Click the Merge to New Document button. Click File > Print. Follow the prompts and click Print once all is ready. Click File > Save As if you want to save the file template. Can you print labels with a regular printer? You can use a regular printer such as an inkjet or a laser printer to print labels on a standard 8.5” x 11” full label sheet or a half sheet. Final Thoughts Microsoft Excel is a versatile tool that commonly organizes and sorts data. And Excel practically functions as a platform to create and print labels. In this guide, we have outlined several helpful and easy ways on how to print labels from Excel. With our guide, Excel can be a very powerful, convenient, and quick-processing tool to help you with a variety of your business needs, from organizing your data to printing labels. Facebook Twitter Youtube Instagram Like & follow our social media pages to see more updates and promotions ! Gene Paul Lim
