Auto-complete dropdown lists for data validation

Feature updates

Excel

• Data Validation dropdown list autocomplete: Dropdown lists are a handy way to make data entry and validation more efficient in Excel. We’ve now added AutoComplete functionality, which automatically compares the text typed in a cell to all items in the dropdown list and displays only the items that match. You’ll spend less time scrolling through lists, dealing with data validation errors, or writing complex code to handle this task.
  See details in blog post
• Paste values directly into your workbook using a keyboard shortcut: The keyboard shortcut CTRL+SHIFT+V lets you quickly Paste Values rather than having to choose Paste Values from the menu.
  See details in blog post

Outlook

• Block emails with sensitive labels: Implement pop-up messages in Outlook that warn, justify, or block emails being sent based on sensitivity labels.

Resolved issues

Excel

• We fixed an issue where using "Alt + P" as a hot key for Previous was conflicting with "Alt + P" for the Replace tab.

Outlook

• We fixed an issue where the Me control showed the wrong display name in Office apps.

Word

• We fixed an issue where doing a mail merge would display the error, "Microsoft Word is required to run the Mail Merge Wizard".

Office Suite

• We fixed an issue where sensitivity labeling was unavailable for documents opened from SharePoint on-premise servers.