Create workbook links - Microsoft Support
Important: Workbook links are considered potentially unsafe and must be enabled when you open a formula workbook.When you open a formula workbook, click Enable Content in the Message Bar to allow the workbook links to function. If you don't, Excel keeps the most recent values and disables refreshing the links with values from the data workbook.
Applies To: Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2019, Excel 2016
Add, remove, or change time zones - Microsoft Support
At any time, you can change the time zone in Outlook so that it matches your current geographic location. Changing the time zone in Outlook is the same as changing it in the Windows Control Panel, and the change is reflected in the time displays in all other Microsoft Windows-based programs.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016
Download language pack for speech - Microsoft Support
Manually download a language for Cortana speech. Go back to Settings > Time & language > Language, select your new language, and then use the up-arrow button to move it to the top of the list and make it the default.
Windows keyboard shortcuts for accessibility - Microsoft Support
Press this key. To do this. Windows logo key + Plus sign (+). Turn Magnifier on. Windows logo key + Esc. Turn Magnifier off. Windows logo key + Plus sign (+) or Minus sign (-). When Magnifier is on, zoom in or out
Use Game Mode while gaming on your Windows device
When you use Game Mode, Windows prioritizes your gaming experience by turning things off in the background. When you’re running a game, Game Mode:
KB5012170: Security update for Secure Boot DBX
Issue. Next step. If BitLocker Group Policy Configure TPM platform validation profile for native UEFI firmware configurations is enabled and PCR7 is selected by policy, it may result in the update failing to install.. To view the PCR7 binding status, run the Microsoft System Information (Msinfo32.exe) tool with administrative permissions.
UNIQUE function - Microsoft Support
Examples. Example 1. This example uses SORT and UNIQUE together to return a unique list of names in ascending order. Example 2. This example has the exactly_once argument set to TRUE, and the function returns only those customers who have had service one time.
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel for iPad, Excel for iPhone, Excel for Android tablets, Excel for Android phones
Check spelling and grammar in Office - Microsoft Support
To. Do this. Change the word. Under Suggestions, click the word that you want to use, and then click Change.. Change every occurrence of this word in this document. Under Suggestions, click the word that you want to use, and then click Change All.. Ignore this word and move on to the next misspelled word
Applies To: Excel for Microsoft 365, Word for Microsoft 365, Outlook for Microsoft 365, PowerPoint for Microsoft 365, Project Online Desktop Client, Publisher for Microsoft 365, Excel for Microsoft 365 for Mac, Outlook for Microsoft 365 for Mac, PowerPoint for Microsoft 365 for Mac, Excel 2021, Word 2021, Outlook 2021, PowerPoint 2021, Project Professional 2021, Project Standard 2021, Publisher 2021, Visio Professional 2021, Visio Standard 2021, OneNote 2021, Excel 2021 for Mac, Outlook 2021 for Mac, PowerPoint 2021 for Mac, Excel 2019, Word 2019, Outlook 2019, PowerPoint 2019, Project Professional 2019, Project Standard 2019, Publisher 2019, Visio Professional 2019, Visio Standard 2019, Excel 2019 for Mac, Outlook 2019 for Mac, PowerPoint 2019 for Mac, Excel 2016, Word 2016, Outlook 2016, PowerPoint 2016, OneNote 2016, Project Professional 2016, Project Standard 2016, Publisher 2016, Visio Professional 2016, Visio Standard 2016, InfoPath 2013, InfoPath Filler 2013
Register the password reset verification method for a work or school ...
Important: This article is intended for users trying to use sign up for self-service password reset.This means that you’ll be able to reset your own work or school password (such as alain@contoso.com), without requiring your administrator’s help.
Set up rules in Outlook - Microsoft Support
Select a condition, and what to do with the message based on the condition. For example, to move messages with a certain title to a specific folder, select the Subject contains condition, select Move the item to folder, select or create a New folder, and then select OK.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016