Printing labels using the application of Microsoft Excel is an ideal way to save a lot of time, which you might otherwise spend handwriting labels. Printing labels is a very quick and a fairly easy way of getting the job done in case you are involved with compiling a mass group of envelopes to mail out to associates or organizing your home or office.
Instructions to Print Labels from Microsoft Excel
Step 1: Once you have the necessary hardware available, switch on the computer and open up the Excel application. After setting up your Excel document, create a header row by typing the names of each column in the top row of that column. For instance, if you are printing mailing labels, the first box in the first column might be ‘First name’, the second box might be called ‘Last name’, followed by a name for mailing address, and then for boxes for city, state and Postal code.
Step 2: Save the Excel document by clicking on ‘File’ followed by ‘Save as’. Type a name for the document and save the file to a location that can be easily remembered and accessed.
Step 3: Open a blank Word document; then you need to combine Excel and Word for creating your labels.
Step 4: After that, you’re required to choose the label paper.
Step 5: Create the labels by clicking on ‘Tools’, ‘Letters and Mailings’, ‘Mail Merge Wizard’ and then selecting ‘Labels’ from the list of options. Based on the type of labels you’re printing, follow the prompts. To find the product and brand number, check the package your paper came in. From the drop down box, you can select different label vendors and you would see a list of numbers to choose from. Selecting the appropriate product type would help you to ensure a perfect print job.
Step 6: Select your recipients by clicking on ‘Select recipients’ and choosing ‘Use existing list’, to use the information from your Excel spreadsheet. Browse for the spreadsheet you saved in Step 2 in the pop-up box. Highlight the spreadsheet, click ‘Open’ and click the first available option in the pop-up box. Make sure that the box named ‘First row of data contains column headers’ is marked.
Step 7: In the Mail Merge Recipients box, start clicking on the items in the header row for inserting them into each label. For example, you’ll click ‘First name’, ‘Last name’ on the first row, press Enter to start a new row, click ‘Mailing Address’, hit Enter and so on. When you are finished, click OK to proceed to the next step.
Step 8: Load the paper into the printer and then print your labels. When everything has been set up appropriately, click on ‘File’, ‘Print’, and select your printer. Proceed further to select the number of pages to print and click OK to start printing.
Thus, once you understand how to go ahead with printing labels, it becomes a very easy job. Follow these instructions it would be even simpler the next time.