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
Change the email address or phone number for your Microsoft account
Email addresses and phone numbers associated with your Microsoft account are called aliases and they use the same contacts, online storage, subscriptions, and account settings.
Applies To: Microsoft account dashboard
How to change your Xbox gamertag | Xbox Support
Press the Xbox button to open the guide, and then go to Profile & system.; Select your Xbox profile (or select Choose a profile and sign in to your account).; Select My profile > Customize profile, and then select your current gamertag.; Under Choose your new gamertag, enter the gamertag that you want in the available text box, and then select Check availability.
What's new in Office 2021 - Microsoft Support
Immersive Reader advanced color support. In Immersive Reader, we've added many additional ways you can choose a page color.Selecting a page color can make text easy to scan with less eye strain. On the Immersive Reader tab click Page Color to see a 4x5 color picker.. Click More Colors to see additional color selection options such as Wheel, Sliders, Color Palettes, Image Palettes, and Pencils.
Applies To: Office 2021, Office 2021 for Mac
Use inbox rules in Outlook - Microsoft Support
Use rules to automatically perform specific actions on email that arrives in your inbox. For example, you can create rules that will change the importance level of messages as they come in, automatically move them to other folders, or delete them based on certain criteria.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016, Microsoft 365 admin, Outlook on the web, Outlook.com, New Outlook for Windows
Getting started with Microsoft Family Safety - Microsoft Support
A family group is a set of individuals connected through the Microsoft Family Safety app on their Windows, Xbox, or mobile devices. Establishing a family group is an easy, effective way to encourage healthy online habits and manage busy schedules.
Applies To: Microsoft Family Safety
Surface power supplies and charging requirements
For info on how to properly care for the power cord and power supply, see Clean and care for your Surface.. Safety and regulatory information. To view the safety and regulatory information for Surface and Surface power supplies, including shipping information and AC power cord safety, see Product safety warnings and instructions.. Where to find a power supply
Introduction to Outlook Data Files (.pst and .ost)
Note: In earlier versions of Outlook, IMAP accounts also used an Outlook Data File (.pst).In Outlook 2016 and Outlook for Microsoft 365, IMAP accounts use Offline Outlook Data Files (.ost). You can also use an Outlook Data File (.pst) to backup or export items from any type of email account.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016
Filter data in a range or table - Microsoft Support
Use AutoFilter or built-in comparison operators like "greater than" and “top 10” in Excel to show the data you want and hide the rest. Once you filter data in a range of cells or table, you can either reapply a filter to get up-to-date results, or clear a filter to redisplay all of the data.
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2019, Excel 2016
Find and remove duplicates - Microsoft Support
How to find and remove duplicates in Excel. Filter for unique values in large or small datasets to clean up your worksheets and workbooks.
Applies To: Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016