how to print address labels from excel spreadsheet on mac

The Table and the name that we defined will expand automatically. I do this by adding a new column to the Table for this year. In the New Name dialog, type the name Addresses and the range of cells your addresses are in ($B$2:$G$15 in this case)Īfter my Table is created and a name applied, I start going through the addresses to confirm which ones are correct.To define a name, click “Define Name” command on the Formula Tab.This is helpful in this case because I want to add and remove addresses during the process of printing envelopes. When a name is defined for a Table in a worksheet, the name will update automatically as the table is resized to add or remove data. The range of cells will now have a table style applied and dropdowns at the top of each column that provide options for sorting and filtering.Įxcel allows you to define names that apply to a range of cells in the worksheet.Verify that the items are correct and click OK. A dialog will appear asking for the range of cells containing your addresses and whether your table has headers.On the Insert Tab, click on the Table button.Select a cell within the range containing the addresses, such as cell B2.

The first step is to create a Table from the list of addresses. Given the number that I need to do for the holidays, I do want to get started though. I have a number of addresses that I know are correct but there are others that I need to confirm before printing them out. If you’re like me, you don’t keep your address list up to date and you don’t print envelopes often. I have most of my addresses in Excel with columns for FirstName, LastName, Address, City, State and Postal Code. Very useful nonetheless.Īt this time of the year I find myself preparing to send out a large number of greeting cards to friends and family. Today’s author, Eric Patterson, a Program Manager on the Excel team, describes how to use Excel Tables as a source for a mail merge – a great productivity tool for sending out holiday greeting cards! 🙂 Eric wrote this before the holidays but unfortunately I was out of the office and didn’t get to post this until now.

How to print address labels from excel spreadsheet on mac