avery 5160 label template microsoft word

#Avery 5160 label template microsoft word how to
#Avery 5160 label template microsoft word code

You can find it in the bottom right of each group. Then select the Page Setup button as shown in the figure.First of all, go to the Page Layout tab on your ribbon.To set custom margins, follow these steps. For that, we should choose the proper size in such a way that it doesn’t affect the label position or compromise any labels on the sheet. To print the labels, we need to set the correct margins for the printed page.

#Avery 5160 label template microsoft word how to

Read More: How to Print Avery Labels from Excel The labels are now ready to print in Excel without any use of Word. The spreadsheet will now look like this automatically. We are selecting 3 for the demonstration. Next, select the number of columns you desire.Now in the Macro box, select Createlables under the Macro name.Second, select Macros from the Code group.First, go to the Developer tab on your ribbon.Once you have entered the code, close the VBA window. 👉 Section 3: This portion formats each cell using the VBA Cells property. 👉 Section 2: This command runs the previous sub at this point of the code.

#Avery 5160 label template microsoft word code

👉 Section 1: This portion of the code declares the sub name Createlabels. Follow the figure at the end of the discussion for the visual part. Similar to the previous part, we have divided this sub into different sections too. 👉 Section 7: Finally, this section clears the extra contents. 👉 Section 6: This section of the code now resizes the cells. 👉 Section 5: In this section, a For loop is run for the number entered in the input box. 👉 Section 4: At this point, the code shows an input box on the spreadsheet. 👉 Section 3: In this section, we have set values for refrg and data. 👉 Section 2: We have used this section to declare three variables- refrg, vrb, and data. 👉 Section 1: This section declares the name of the sub AskForColumn. Look at the figure at the end of the discussion. First, we are going to explain what is going on in the AskForColumn sub and then move on to the CreateLabel sub to explain how the code works.įor a better understanding, we have divided the portion into different sections. There are two parts or subs in this VBA code- the CreateLabel sub and the AskForColumn sub. Range(Cells(dat, 'A'), Cells(refrg.Row, 'A')).ClearContents Incolno = InputBox('Enter Number of Columns Desired')Ĭells(dat, 'A').Resize(1, incolno).Value = _Īpplication.Transpose(Cells(vrb, 'A').Resize(incolno, 1)) Set refrg = Cells(Rows.Count, 1).End(xlUp) After that, go to the module and write down the following code.Now select the Insert tab in it and select Module from the drop-down menu. As a result, the VBA window will open up.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 the 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. Related Articles How to Print Labels in Excel Without Word: Step-by-Step Procedures