Uncategorized

Making labels in excel mac

If you are using Microsoft Office , the steps to make address labels from Excel are slightly different.


  1. dvd copy free software for mac!
  2. sistemas operacionais windows mac linux?
  3. bible code software free mac.
  4. Office 2011 for Mac All-in-One For Dummies.
  5. Word 2011 for Mac: Making Labels by Merging from Excel!
  6. mac identifier by serial number?

Play around with the mail merge feature in Word. You can use data in Excel to create everything from form letters and envelopes to emails and directories. Using data you already have in Excel or can enter into a worksheet quickly and easily can make light work of typically time consuming tasks. Share Pin Email. She's written tips and tutorials for Microsoft Office applications and other sites.

Updated November 24, For instance, if you want to create mailing labels from Excel, you might have the following column headings: Title Mr. In Word, click on the File tab and choose Options at the bottom of the left pane. Click Advanced in the left pane of the Word Options window and then scroll down to the General section. Open a blank Word document. Choose the brand in the Label Vendors box and then choose the product number, which is listed on the label package.

You can also select New Label if you want to enter custom label dimensions.

Apple Footer

Click OK when you are ready to proceed. Navigate to the Excel worksheet containing your list in the Select Data Source window that opens and click Open. Click OK to confirm that you want to use the list and click OK again to select the table containing your list. This is where those headings you added to your Excel worksheet will come in handy.

Create mailing labels in Word by using mail merge - Word for Mac

Make sure your headings correspond with the required fields. If any of them are incorrect, use the drop-down arrow beside it to match up to the correct field.


  • Step 1: Prepare the worksheet data in Excel for the mail merge.
  • stick rpg 2 directors cut free download for mac.
  • bo du film le mac.
  • mac os x server certificate has expired!
  • Click OK. Click Edit Individual Documents to preview how your printed labels will appear.

    X-Labels on Excel for Mac

    Select All and click OK. Open a new Word document. Select Labels and click Next: Starting Document. Click Label Options to open the Label Options dialog box. The Mail Merge Recipients window opens. Make sure to remove the checks from the Headers and Footers checkboxes as headers and footers limit the amount of printable space available to you on the page. Next add a new table to the document using the Table button on the Toolbar. By default, Pages inserts a three-by-three table with a single header row.

    Now, change the column width to 1. You should note that the column width field will only allow you to change the number to 1.

    Create and print labels in Word for Mac

    Select the Cell Background section and choose None. In this case, I changed the left margin to 2. Once I made these changes I could change the column width to 1. Making adjustments is less a matter of science than it is a matter of judgement. I suggest that you make smaller changes,. When your labels are finished and printed, you'll get something that looks like this. First, select the table.

    One way to do this is to control-click on the table and choose Select All. Now you're ready to print out your labels.

    Thank you for your feedback!

    Jeffery Battersby is an Apple Certified Trainer, very smalltime actor, and regular contributor to Macworld. He writes about Macs and more at his blog. First Look: FileMaker Pro Advanced 17 review: Plenty of great reasons to upgrade to this How to change the default app for a file. Change Apple Watch app grid to list view.