Create and print mailing labels for an address list in Excel
The mail merge process creates a sheet of mailing labels that you can print, and each label on the sheet contains an address from the list. To create and print the mailing labels, you must first prepare the worksheet data in Excel and then use Word to configure, organize, review, and print the mailing labels.
Prepare your Excel data source for a Word mail merge
If your data source is an existing Excel spreadsheet, then you just need to prepare the data for a mail merge. But if your data source is a tab delimited (.txt) or a comma-separated value (.csv) file, you first need to import the data into Excel, and then prepare it for a mail merge.
ADDRESS function - Microsoft Support
You can use the ADDRESS function to obtain the address of a cell in a worksheet, given specified row and column numbers. For example, ADDRESS (2,3) returns $C$2. As another example, ADDRESS (77,300) returns $KN$77.
Share and print - Microsoft Support
Print a worksheet in landscape or portrait orientation. Print rows with column headers on top of every page. Create and print mailing labels for an address list in Excel. Repeat specific rows or columns on every printed page.
Download free, pre-built templates - Microsoft Support
You can download free, pre-built document templates with useful and creative themes from Office when you click File > New in your Office app. Templates can include calendars, business cards, letters, cards, brochures, newsletters, resumes, cover …
Troubleshoot printing problems in Microsoft 365 apps
This article provides steps to diagnose and resolve issues that occur when you cannot print in a Microsoft 365 app, such as Excel, or Word on a PC or Mac. Windows Mac. Try the following options to help determine the problem: Test printing in other programs. Open WordPad.
Add commands to the Quick Access Toolbar - Microsoft Support
If you frequently create PDFs, or do something else that requires going to the File tab, here’s how to add that command to the Quick Access Toolbar. Click Customize the Quick Access Toolbar, and then click More Commands. Choose the command, and then click Add. Click OK.
Repeat specific rows or columns on every printed page
If a worksheet spans more than one printed page, you can label data by adding row and column headings that will appear on each print page. These labels are also known as print titles. Follow these steps to add Print Titles to a worksheet: On the worksheet that you want to print, in the Page Layout tab, click Print Titles, in the Page Setup group.
Dynamically display the contents of a cell or range in a graphic …
To display the contents of a worksheet cell in a shape, text box, or chart element, you can link the shape, text box, or chart element to the cell that contains the data that you want to display. Using the Camera command, you can also display the contents of a …
Display numbers as postal codes - Microsoft Support
In the Type list, type *0 followed by the postal code format that you want to use. For example, for a 5-digit postal code, type *0#####. Create or delete a custom number format. Learn how to create your own custom postal code format in Excel, and format numbers as postal codes.
Apply sensitivity labels to your files and email - Microsoft Support
The sensitivity bar makes it easy for you to see what label is applied to your file, and to apply or change a label whenever you need to, including when saving the file. Just select the sensitivity bar in the save dialog to see the labeling options for this file.