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
Add an app to run automatically at startup in Windows 10
Right-click the app, select More, and then select Open file location.This opens the location where the shortcut to the app is saved. If there isn't an option for Open file location, it means the app can't run at startup.
Lock or unlock specific areas of a protected worksheet
Clear this check box. To prevent users from. Select locked cells. Moving the pointer to cells for which the Locked check box is selected on the Protection tab of the Format Cells dialog box. By default, users are allowed to select locked cells.
Applies To: Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016
Set up the Microsoft Authenticator app as your verification method
Method. Used for. Authenticator app. Two-factor verification and password reset authentication. Text messages. Two-factor verification and password reset authentication.
Download free, pre-built templates - Microsoft Support
Find and download free templates to create documents like calendars, business cards, letters, greeting cards, brochures, newsletters, or resumes.
Applies To: Excel for Microsoft 365, Word for Microsoft 365, PowerPoint for Microsoft 365, Access for Microsoft 365, Project Online Desktop Client, Publisher for Microsoft 365, Excel 2021, Word 2021, PowerPoint 2021, Access 2021, Project Professional 2021, Project Standard 2021, Publisher 2021, Excel 2019, Word 2019, PowerPoint 2019, Access 2019, Project Professional 2019, Project Standard 2019, Publisher 2019, Excel 2016, Word 2016, PowerPoint 2016, Access 2016, Project Professional 2016, Project Standard 2016, Publisher 2016, Visio Professional 2016, Visio 2010, InfoPath 2013
Getting started with Planner in Teams - Microsoft Support
Track your tasks in My Tasks. Planner offers a purpose-built My Tasks view, designed to centralize all the tasks relevant to you. My Tasks is organized into four distinct views, each serving a unique purpose: Private tasks: Private tasks is a place for you to quickly jot down tasks at the speed of thought.This is a place where you can create tasks that do not belong to a plan yet.
Applies To: Microsoft Planner, Microsoft Teams, Microsoft Teams for Education, Microsoft Teams personal, Microsoft Teams small business
FILTER function - Microsoft Support
The FILTER function allows you to filter a range of data based on criteria you define.
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
Find your notifications - Microsoft Support
Windows 10 puts notifications and quick actions in Action Center—right on the taskbar—where you can get to them instantly. Select Action Center on the taskbar to open it. (You can also swipe in from the right edge of your screen, or press Windows logo key + A.). Notifications at a glance
Use voting buttons in messages - Microsoft Support
Track and print results. When you create and send an email with voting buttons to others, you may want to track and print the results. You can either quickly copy the voting results into a blank Word document or a new email, or copy them into Excel so you can work with the data later.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016, Outlook 2013
How to get and use app passwords - Microsoft Support
After you turn on two-step verification or set up the Authenticator app, you may run into issues if you use older devices (like Xbox 360 or a mail-sending security camera) that don't support two-step verification. For those devices, you can sign in with an app password instead. An app password is a long, randomly generated password that you provide only once instead of your regular password ...