How Do You Print Labels From Microsoft Excel?
Printing labels using Microsoft Excel is a great way to save hours of time that you might otherwise spend handwriting labels. Whether you’re compiling a mass group of envelopes to mail out to associates or organizing your office or home, printing labels is a quick and easy way to get the job done. Set up your Excel document. Create a header row by typing the names of each column in the top row of that column. For example, if you’re printing mailing labels, the first box in the first column might be “Recipient’s first name” (or “first name,” for short), the second box might be called “Last name,” then “Mailing address,” followed by boxes for city, state and ZIP code. Save your Excel document. Click “File,” “Save As” and choose a name and location that is easily remembered. Open a blank Microsoft Word document. You need to combine Word and Excel to create your labels. Choose the label paper. Peel-and-stick label paper is available from any office supply store. Create the labels. Click on
