Apply data validation to cells - Microsoft Support
Note: To let a user enter percentages, for example 20%, select Decimal in the Allow box, select the type of restriction that you want in the Data box, enter the minimum, maximum, or specific value as a decimal, for example .2 , and then display the data validation cell as a percentage by selecting the cell and clicking Percent Style in the Number group on the Home tab.
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, Excel 2016
Install or reinstall OneNote for Windows - Microsoft Support
Note: If you installed OneNote before you install and activate Microsoft 365 or Office 2019, then the end-user license that appears in OneNote will display as “Home and Student.”As soon as you’ve activated your edition of Microsoft 365 or Office 2019 and then restart OneNote, your license will be applied to OneNote, even though the default license for it may still be displayed as “Home ...
Applies To: OneNote for Microsoft 365, OneNote 2016, Office for business
View email messages by conversation in Outlook - Microsoft Support
Under Message organization, choose either of the options depending on whether you want to show email grouped by conversation or as individual message.. If you select Show email grouped by conversation, under Arrange the reading pane, select either of the options: Newest on top, Newest on bottom, or Show each message separately.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016, Outlook Web App for Office 365 Small Business, Outlook.com, New Outlook for Windows
Check your Microsoft account balance - Microsoft Support
For help with checking your balance from an Xbox console, see Check your Microsoft account balance on an Xbox console. 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.
Applies To: Microsoft account dashboard
Align text left or right, center text, or justify text on a page
The term "alignment" generally specifies the appearance and orientation of the edges of a paragraph -- left-aligned text, right-aligned text, centered text, or "justified" text (aligned evenly from left to right margins).
Applies To: Word for Microsoft 365, Word 2021, Word 2019, Word 2016
How do I turn on AutoSave? - Microsoft Support
If you open an Office file from your recent files list via the Taskbar or the Office app, you will need to open the file as described above to enable AutoSave.. To check, hover your mouse over the recent list: Files that begin C:\Users\ in their path will not open with AutoSave, but files with https:// will.. Close and re-open the file from within the Microsoft 365 app, not the recent file list.
Applies To: Excel for Microsoft 365, Word for Microsoft 365, PowerPoint for Microsoft 365, Excel for Microsoft 365 for Mac, Word for Microsoft 365 for Mac, PowerPoint for Microsoft 365 for Mac, OneDrive (home or personal), OneDrive for Mac, OneDrive for Windows
Insert ASCII or Unicode Latin-based symbols and characters
Inserting ASCII characters. To insert an ASCII character, press and hold down ALT while typing the character code. For example, to insert the degree (º) symbol, press and hold down ALT while typing 0176 on the numeric keypad.
Applies To: Excel for Microsoft 365, Outlook for Microsoft 365, PowerPoint for Microsoft 365, Publisher for Microsoft 365, Excel 2021, Outlook 2021, PowerPoint 2021, Publisher 2021, Visio Professional 2021, Visio Standard 2021, OneNote 2021, Excel 2019, Outlook 2019, PowerPoint 2019, Publisher 2019, Visio Professional 2019, Visio Standard 2019, Excel 2016, Outlook 2016, PowerPoint 2016, OneNote 2016, Publisher 2016, Visio Professional 2016, Visio Standard 2016
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
About Microsoft Authenticator - Microsoft Support
Microsoft Authenticator is a free app that helps you sign in to all your accounts without using a password - just use a fingerprint, face recognition, or a PIN.
Applies To: Microsoft account dashboard
Turn new message alert pop-up on or off - Microsoft Support
A Desktop Alert is a notification that appears on your desktop when you receive a new email message, a meeting request, or a task request. By default, Desktop Alerts are turned on.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016, New Outlook for Windows