It doesn’t include label features automatically. Google Sheets offers a free cloud-based spreadsheet tool with features similar to Excel. Review the formatting in your Word document before sending it to your printer.Select “Start Mail Merge, then “Labels.” Select the document you created in Excel and add those recipients to your Word doc.In a new Word document, go to the “Mailings” tab and select “Labels.” Use the label options dialog box to choose the correct template.Make sure none are left blank, as this could throw off the formatting. Type the information for each recipient into the correct column.This may include things like: title, first name, last name, street address, city, state, and zip code. Create a new Excel sheet and type a heading in the first cell of each column describing the information you want included in each label.This feature makes printing labels in Word significantly easier by giving users a pop-up to add all the relevant information. The labels and envelopes dialog box is available in the “Mailings” tab of Word 2007 and newer. Printing Labels in Word Using the Envelopes and Labels Dialog Box Make sure your label sheet is correctly inserted into the tray. Select “Print” to send your labels to your printer.Format or edit any individual labels if necessary.For example, if you have a sheet of 30 labels, select the 30 Per Page option that matches your dimensions. Choose the type of sheet specified on your label package.Select “Options,” and a dialog window should pop up.Choose the row and column where the label is located on your sheet.To print a single label, select “Single Label.” To print a full page, select “Full Page of the Same Label.”.Enter the address you want included on your label in the dialog box.Click the “Mailings” tab, then the “Labels” button.Here’s a rundown of the most basic method to create labels in Word.

And there’s a Mail Merge feature that makes it easy to input a large number of addresses at the same time.

How to print address labels from excel