Related topics
Using Microsoft 365 for the Holidays
Sign in with Microsoft
Sign in or create an account.
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.
Using Microsoft 365 for the Holidays

Give: Manage addresses

Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.

Watch next: Create labels with a mail merge in Word

Getting ready to send a holiday mailing - a sleigh full of gifts, holiday cards, party invitations, or thank-you notes? Manage all your mailing addresses in an Excel spreadsheet. When it's saved to your OneDrive, your family and friends can coauthor it, and add or edit entries. Watch the next video to see how Word can easily convert the addresses in your Excel sheet to mailing labels or envelopes.

Manage your address lists

  1. In Excel, type your column headers.

  2. To format the postal code so the leading 0 isn't dropped, click the column, select Format > Format Cells > Special > Zip Code, and then click OK.

  3. Enter names and addresses.

  4. To turn your list into a table, click Format as a Table, select a style, and then click OK.

  5. To sort the table, select a column header drop-down, and then select a sort option.

  6. To save your file to the cloud, click File > Save As > OneDrive - Personal, type a name, and click Save.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!