Display empty cells, null (#N/A) values, and hidden worksheet data in …
Change the way that empty cells, null (#N/A) values, and hidden rows and columns are displayed in a chart. Click the chart you want to change. Go to Chart Tools on the Ribbon, then on the Design tab, in the Data group, click Select Data. Click Hidden and Empty Cells.
Control the formatting when you paste text - Microsoft Support
By default, Word preserves the original formatting when you paste content into a document using Ctrl + V, the Paste button, or right-click + Paste. To change the default, follow these steps. Go to File > Options > Advanced. Under Cut, copy, and paste, select the …
Keep text together - Microsoft Support
To keep two words or a hyphenated word together on one line, you can use a nonbreaking space or nonbreaking hyphen instead of a regular space or hyphen. Click where you want to insert the nonbreaking space. You can also use the keyboard shortcut.
Create a form in Word that users can complete or print
Applies To. Windows macOS Web. In Word, you can create a form that others can fill out and save or print. To do this, you will start with baseline content in a document, potentially via a form template. Then you can add content controls for elements such as check boxes, text boxes, date pickers, and drop-down lists.
Set text direction and position in a shape or text box in Word ...
The text can be positioned horizontally or vertically, and it can appear on one line or wrap to multiple lines. You can change the direction of the text, and you can also change the margins of text boxes and shapes for optimal spacing, or resize shapes for a better text fit.
Add, remove, or change a trusted location in Microsoft Office
Change a trusted location. In your Office app, click File > Options. Click Trust Center > Trust Center Settings > Trusted Locations. In the Trusted Locations list, select a location, and then click Modify. Make the modifications you want, and then click OK.
Make your Word documents accessible to people with disabilities
Best practices for making Word documents accessible. Check accessibility while you work in Word. Avoid using tables. Use built-in title, subtitle, and heading styles. Create paragraph banners. Add alt text to visuals. Add accessible hyperlink text and ScreenTips. Use accessible font format and color. Create accessible lists.
Create a waterfall chart - Microsoft Support
Create a sunburst chart in Office. Use the waterfall chart to quickly see positive and negative values impacting a subtotal or total value. Waterfall charts are often used to visualize financial statements, and are sometimes called bridge charts.
Set the rules for a mail merge - Microsoft Support
Go to Mailings > Rule, and choose a rule based on the descriptions below. Use mail merge rules such as fil in, if/then, next, previous, or skip record to customize your mail merge.
Insert a table - Microsoft Support
To draw your own table, select Insert > Table > Draw Table. For a basic table, click Insert > Table and move the cursor over the grid until you highlight the number of columns and rows you want. For a larger table or to customize a table, select Insert > Table > Choose row and column.
Merge or split cells in a table - Microsoft Support
Select the cells to merge. On the table's Layout tab, select Merge Cells in the Merge group. Split cells. Select one or more cells to split. On the table's Layout tab, select Split Cells in the Merge group. Enter the number of columns or rows that you want to split the selected cells into.