Manage drive space with Storage Sense - Microsoft Support
Cloud files can exist locally on the disk or be available online only. To choose the conditions for when inactive files are made online only, under Content will become online-only if not opened for more than: choose your preferred amount of time. Note that starting in Windows 11, version 22H2, the default for OneDrive cloud files is to make files online-only if not opened for more than 30 days.
List templates in Microsoft 365 - Microsoft Support
List column. Description. Column type. Asset tag. Identification number of the asset. Single line text. Status. Choose from available, reserved, in use, in repair or retired
Applies To:
SharePoint in Microsoft 365, Microsoft Lists, Microsoft Teams
Change the column width or row height in Excel - Microsoft Support
Note: The boundary is the line between cells, columns, and rows.If a column is too narrow to display the data, you will see ### in the cell.
Applies To:
Excel for Microsoft 365, Excel 2024, Excel 2021, Excel 2019, Excel 2016
Create Quick Notes - Microsoft Support
Note: Closing a Quick Note window doesn't delete the note.OneNote automatically saves your Quick Notes. Quick Notes are stored in the Quick Notes section in your default notebook. You can find them quickly by opening your Notebooks list (click the down-arrow next to the name of your notebook and look at the bottom of the list for Quick Notes).
Applies To:
OneNote for Microsoft 365, OneNote 2024, OneNote 2021, OneNote 2016
Sign in to your work or school account using your two-step verification ...
To sign in using a verification code with the Microsoft Authenticator app. If you use the Microsoft Authenticator app to get verification codes, then when you open the app you see a number under your account name.
Create a desktop shortcut for an Office program or file
Note: This article explains how to create a shortcut on your desktop.You can also add a program to the taskbar. If you are using Windows 10, right-click the program name or tile, click More > Pin to taskbar.If you are using Windows 11, right-click the program name or tile, and then select Pin to taskbar.
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, Excel 2024, Outlook 2024, PowerPoint 2024, Access 2024, OneNote 2024, Project Standard 2024, Excel 2021, Word 2021, Outlook 2021, PowerPoint 2021, Access 2021, Project Standard 2021, Publisher 2021, Visio Standard 2021, OneNote 2021, Excel 2019, Word 2019, Outlook 2019, PowerPoint 2019, Access 2019, Project Standard 2019, Publisher 2019, Visio Standard 2019, Excel 2016, Word 2016, Outlook 2016, PowerPoint 2016, Access 2016, OneNote 2016, Project Standard 2016, Publisher 2016, Visio Standard 2016
Uninstall Office from a PC - Microsoft Support
Tip: If you installed the Microsoft 365 apps as part of a suite, such as Office Home and Student or Microsoft 365, search for the suite name.For stand-alone apps search by the app name, such as Project or Visio. In most cases you can't uninstall an individual app if it's included in your Microsoft 365 suite.
Applies To:
Office 2024, Office 2021, Office 2019, Office 2016, 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, Office 365 Germany - Enterprise, Office 365 Germany - Enterprise admin
COUNTIF function - Microsoft Support
Argument name. Description. range (required). The group of cells you want to count. Range can contain numbers, arrays, a named range, or references that contain numbers. Blank and text values are ignored. Learn how to select ranges in a worksheet.. criteria (required). A number, expression, cell reference, or text string that determines which cells will be counted.
Applies To:
Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2024, Excel 2024 for Mac, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2016
DATEDIF function - Microsoft Support
Argument. Description. start_date . Required. A date that represents the first, or starting date of a given period. Dates may be entered as text strings within quotation marks (for example, "2001/1/30"), as serial numbers (for example, 36921, which represents January 30, 2001, if you're using the 1900 date system), or as the results of other formulas or functions (for example, DATEVALUE("2001 ...
Applies To:
Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2024, Excel 2024 for Mac, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2016, Windows SharePoint Services 3.0
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 2024, Excel 2021, Excel 2019, Excel 2016