Create and print mailing labels for an address list in Excel
If you want to send a mass mailing to an address list that you maintain in a Microsoft Excel spreadsheet, you can use a Microsoft Word mail merge. 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.
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.
Add a label or text box to a worksheet - Microsoft Support
If someone's entering data inaccurately, or you think a coworker may be confused about how to enter data, add a label. A simple name, such as "Phone," lets others know what to put in a cell, and your labels can also provide more complex instructions. You can add labels to forms and ActiveX controls. Add a label (Form control)
Download free, pre-built templates - Microsoft Support
To download and use it, click the Create button and a new file will be created for you, using that template, all ready for you to customize with your information. If you're looking to print on Avery labels you may find this article helpful: Print on Avery Labels with Microsoft Word.
Add or remove data labels in a chart - Microsoft Support
Depending on what you want to highlight on a chart, you can add labels to one series, all the series (the whole chart), or one data point. Add data labels. You can add data labels to show the data point values from the Excel sheet in the chart. Click More Data Label Options to change the look of the data labels.
Change the format of data labels in a chart - Microsoft Support
You can format the labels to show specific labels elements like, the percentages, series name, or category name. There are a lot of formatting options for data labels. You can use leader lines to connect the labels, change the shape of the label, and resize a data label.
Create holiday decorations, cards, gift tags, and more
Discover what you can create for your holidays, right within Office. For more tips and tools, see the complete holiday template collection or watch holiday how-to videos. Create your own holiday cards. Make professional-looking, custom seasonal greeting cards.
Edit titles or data labels in a chart - Microsoft Support
If your chart contains chart titles (ie. the name of the chart) or axis titles (the titles shown on the x, y or z axis of a chart) and data labels (which provide further detail on a particular data point on the chart), you can edit those titles and labels.
Insert a caption for a picture - Microsoft Support
Click the picture you want to add a caption to. Click References > Insert Caption. To use the default label (Figure), type your caption in the Caption box. Tip: You can also create your own default caption label by clicking New Label, and then adding your caption in the Label box.
Create a named range from selected cells in a worksheet
You can quickly create a named range by using a selection of cells in the worksheet. Note: Named ranges that are created from selecting cells have a workbook-level scope. Select the range you want to name, including the row or column …
Change the format of data labels in a chart - Microsoft Support
To format data labels, select your chart, and then in the Chart Design tab, click Add Chart Element > Data Labels > More Data Label Options. Click Label Options and under Label Contains , pick the options you want.