External or guest sharing in OneDrive, SharePoint, and Lists
If you want to secure your content and get a link that only works for the people you invite, select Specific people in Link settings when creating the sharing link.. The recipients' experience depends on the settings you select when creating the sharing link, and the account they use to view the file.
Applies To: Microsoft Lists, OneDrive (work or school), OneDrive for Mac, OneDrive for Windows
Schedule a Microsoft Teams meeting from Outlook
Troubleshooting The people selection menus in Meeting options don't show invitees I've added to an occurrence of a meeting series. In this scenario, you will need to invite people to the meeting series, rather than to the meeting occurrence.
Applies To: Microsoft Teams
Change the look and feel of Microsoft 365 - Microsoft Support
Important: By default, Word and Outlook recolor your documents and e-mails to match the rest of the application when in Black theme. To disable this behavior in Word, navigate to File > Options > General > Personalize your copy of Microsoft Office, then check Never change the document page color.. To disable this behavior in Outlook, navigate to File > Options > General > Personalize your copy ...
Applies To: Excel for Microsoft 365, Word for Microsoft 365, Outlook for Microsoft 365, PowerPoint for Microsoft 365, Access for Microsoft 365, Publisher for Microsoft 365, Visio Plan 2, Excel for Microsoft 365 for Mac, Word 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, Access 2021, Project Professional 2021, Publisher 2021, Visio Professional 2021, Visio Standard 2021, OneNote 2021, Excel 2021 for Mac, Word 2021 for Mac, Outlook 2021 for Mac, PowerPoint 2021 for Mac, Excel 2019, Word 2019, Outlook 2019, PowerPoint 2019, Access 2019, Project Professional 2019, Publisher 2019, Visio Professional 2019, Visio Standard 2019, Excel 2019 for Mac, Word 2019 for Mac, Outlook 2019 for Mac, PowerPoint 2019 for Mac, Excel 2016, Word 2016, Outlook 2016, PowerPoint 2016, Access 2016, OneNote 2016, Project Professional 2016, Publisher 2016, Visio Professional 2016, Visio Standard 2016, Project for Office 365
Change from a local account to a Microsoft account
When you initially setup your Windows device, you might have opted to use a local account instead of a Microsoft account. The main difference between a local account and a Microsoft account is that a local account is specific to one device, while a Microsoft account can be used across multiple devices and Microsoft services.
Get updates for apps and games in Microsoft Store
Learn more. Fix problems with apps from Microsoft Store. Manage your purchases from the Microsoft Store. Need more help? Contact Support. For technical support, go to Contact Microsoft Support, enter your problem and select Get Help.If you still need help, select Contact Support to be routed to the best support option.
Location and privacy in Microsoft Edge - Microsoft Support
How Microsoft Edge interacts with operating system permissions when sharing your location with a website. Windows can use information such as your IP address, nearby Wi-Fi access points, and GPS data, if available, to estimate your precise or imprecise location coordinates and pass this info to Microsoft Edge.
Applies To: Microsoft account dashboard
IFS function - Microsoft Support
The IFS function checks whether one or more conditions are met and returns a value that corresponds to the first TRUE condition. IFS will allow you to include up to 127 pairs of conditions (the test if something is True and the result if something is true). IFS can take the place of multiple nested IF statements.
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac
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 or subtract dates - Microsoft Support
Add or subtract months from a date with the EDATE function. You can use the EDATE function to quickly add or subtract months from a date.. The EDATE function requires two arguments: the start date and the number of months that you want to add or subtract. To subtract months, enter a negative number as the second argument.
Applies To: Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2019, Excel 2016
How do I upgrade Office? - Microsoft Support
Microsoft 365 Family or Personal. If you have a Microsoft 365 Family or Microsoft 365 Personal subscription, you already have the most current version of Office at no additional cost and should already receive the latest features to your Office apps.See What’s new in Microsoft 365 to learn more about the newest features.. If you don’t see these features, you may not have received the ...
Applies To: Excel for Microsoft 365, Word for Microsoft 365, Outlook for Microsoft 365, PowerPoint for Microsoft 365, Access for Microsoft 365, OneNote for Microsoft 365, Project Online Desktop Client, Publisher for Microsoft 365, Visio Plan 2, Excel for Microsoft 365 for Mac, Word for Microsoft 365 for Mac, Outlook for Microsoft 365 for Mac, PowerPoint for Microsoft 365 for Mac, Excel 2016, Word 2016, Outlook 2016, PowerPoint 2016, Access 2016, OneNote 2016, Project Professional 2016, Project Standard 2016, Publisher 2016, Visio Professional 2016, Visio Standard 2016, Office 2016, Excel 2016 for Mac, Word 2016 for Mac, Outlook 2016 for Mac, PowerPoint 2016 for Mac, OneNote 2016 for Mac, Office 2016 for Mac, Excel 2013, Word 2013, Outlook 2013, PowerPoint 2013, Access 2013, OneNote 2013, Visio Professional 2013, Visio 2013, Office 2013, Microsoft 365 for home, Office for business, Office 365 Small Business, Microsoft 365 admin, Office 365 operated by 21Vianet, Office 365 operated by 21Vianet - Small Business Admin, Office 365 operated by 21Vianet - Admin, Project Online, Microsoft 365 for Mac, Office 365 Germany - Enterprise, Office 365 Germany - Enterprise admin