how to print address labels from excel 2013

Then select Visual Basic from the Code group.First, go to the Developers tab on your ribbon.Next, we need to insert the VBA code to adjust labels to our desired size and shape. Now it should be ready to work with the VBA code. In case, your dataset starts anywhere other than cell A1, like ours, which started at cell B5, first copy them into a new spreadsheet and put them at the very beginning. So, we first have to arrange our dataset containing all the labels in such a way. The VBA code’s selection here can only work properly if the cell entries start from cell A1. Once you have that, keep following the steps we have demonstrated to print these labels in Excel without Word. Click here to see how you can show the Developer tab on your ribbon. We are going to first convert each data into labels and then print them in Excel without using any help from Word.įor the purpose of using Microsoft Visual Basic for Applications (VBA) in Excel, you first need the Developer tab on your ribbon. We are going to use VBA code to perform the task for us.įirst, let’s assume we have the following dataset. We can transform cell size that fits the label size. To print labels directly from Excel without using Microsoft word, we just have to print out the Excel spreadsheet with the appropriate label size.

After specifying the desired settings, click the button.Step-by-Step Procedure to Print Labels in Excel Without Word To adjust alignment, select ' Center' for ' Show Characters'. To adjust width, select ' Small' for ' Width'. Select ' Bar Code'.Ĭlick the tab in the Bar Code Properties dialog box. Merging data into the layout as a bar codeĬlick the field name ' Part Code' and drag it into the layout window.In the same way, merge the field name ' Model Name'. The font and size can also be changed after text is pasted into the layout.Ĭlick the field name ' Part Name' and drag the field name into the layout window. In the Font Size edit box on the Text Properties, specify the font size (e.g. In the Font box on the Text Properties, specify the font (e.g. Specify the font that will be used in the layout: If the file being used contains multiple sheets, the Select Database Table dialog box appears.

How to print address labels from excel 2013