how to print address labels from excel 2011

You’ll notice that, even though we’ve entered the information exactly as it appears in the measurements on the labels package, our labels don’t all fit on a single page. When you’re done, your workspace should look like the image above. Set one to display document settings and the other to display table settings. After the blank document appears, open two Inspectors by first choosing Show -> Inspector, and then choosing View -> New Inspector. To create your own template, launch Pages (in /Applications) and create a new, blank word processing document.

It will be easier to tweak your label layout if you open two Inspector windows, one for document settings and the other for table settings, along with the label document you’re working on. You’ll use this information to create the template. Search the package for measurement information or use a ruler to take measurements from the label itself. Staples brand Big Tabs 8 tab folder dividers, but you can substitute whatever numbers you need for the labels you want to use. For the purposes of this exercise we’re going to use the information that ships with Labels with no templates typically have measurement information that you can use to create the label manually. You’ll use this information to create your template from scratch. Look at your labels to find their measurements.

How to print address labels from excel 2011