Make sure the First row of data contains column headers box is selected and click OK.Ĭheck your list. In Word, click Mailings > Start Mail Merge > Step-by-Step Mail Merge Wizard to start the mail merge wizard.Ĭhoose Labels, and then click Next: Starting document.Ĭhoose Label options, select your label vendor and product number, and then click OK.Ĭlick Browse, select your Excel mailing list, and then click Open. Once your mailing addresses are set up in an Excel spreadsheet (see the previous video to learn how), it's a snap to get Word to create mailing labels from them. Request an on-site Word class from Applied Office.This year, you can avoid that awful permanent-marker smell and get all your holiday card and package labeling done in a few quick steps. That's all there is to it! schedule a class on word

The Table Tools tab in the ribbon choose Layout, then the appropriateīutton in the Alignment group as seen here: Word 2007 users can use the above method, or from Change the alignment by right-clickingĪnywhere in your selected area and choosing 'Cell Alignment' from the Mouse (but be careful not to adjust the height or width of the cells or

If you only want to adjust specific cells, then select them with your There's a keyboard shortcut for this: Alt + Shift + 5 (on your In Word 2007, from the Table Layout tab in the ribbon, pullĭown 'Select' at the far left and choose 'Table'. In Word 2003, pull down the Table menu and choose 'Select', then The next step is to select all of the cells you wish to adjust. Butĭon't worry, they won't actually print.

You can turn the gridlines off the same way you turned them on. Ribbon, choose 'View Gridlines' at the far left, in the 'Table' group. In Word 2007, from the Table Layout tab in the In Word 2003, pull down the Table menu and choose 'View Gridlines' at When you want to adjust the cells - I mean, labels - it helps to Out using a table of three columns and ten rows, and Word has configuredĮach column and row with a precise measurement to match the physical Your Avery 5160 labels (3 x 10) are actually laid It helps to understand that a sheet of labels, in Word, is just aīunch of rows and columns inside a very particularly designed table. You create labels in Microsoft Word, for merge or anything else, it canīe tricky to adjust the alignment of your text so that it's positionedĮxactly where you want on the label.

How to make labels in word mac