Advanced search options - Microsoft Support
Notes: By default, all searches are AND searches. You must capitalize the NOT and OR operators. Otherwise, Bing will ignore them as stop words, which are commonly occurring words and numbers that are omitted to speed a full-text search.
Zip and unzip files - Microsoft Support
Press and hold (or right-click) the file or folder, select (or point to) Send to, and then select Compressed (zipped) folder. A new zipped folder with the same name is created in the same location.
Choose between the 64-bit, 32-bit, and ARM version of OneDrive
If you're not sure which OneDrive version is better for you, you can review the reasons to choose the 64-bit version, the 32-bit version, ARM64 version for Windows, or the Apple silicon version for Mac. If you know what version you want, you can learn how to install it.. If you already have OneDrive, but you're not sure which version you have, check out Which version of OneDrive am I using?
Applies To: OneDrive (home or personal), OneDrive for Mac, OneDrive for Windows
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
Change settings in Microsoft Teams - Microsoft Support
Change Teams settings. Teams will reflect the same date and time format as your device's language, date, and time settings. For example, if your device's display language is set to English (United States), the date and time in Teams will display the regional format used in the United States.. Change your language settings
Applies To: Microsoft Teams
Examples of common formulas in lists - Microsoft Support
Note: Calculated fields can only operate on their own row, so you can't reference a value in another row, or columns contained in another list or library.Lookup fields are not supported in a formula, and the ID of newly inserted row can't be used as the ID doesn't exist when the formula is processed.
Applies To: SharePoint Server Subscription Edition, SharePoint Server 2019, SharePoint Server 2016, SharePoint Server 2013 Enterprise, SharePoint Server Central Admin 2013, SharePoint in Microsoft 365, SharePoint Server 2010, Microsoft Lists, SharePoint in Microsoft 365 Small Business
About Power Query in Excel - Microsoft Support
With Power Query (known as Get & Transform in Excel), you can import or connect to external data, and then shape that data, for example remove a column, change a data type, or merge tables, in ways that meet your needs. Then, you can load your query into Excel to create charts and reports.
Applies To: Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016
How to get service or repair for Surface - Microsoft Support
Send in your Surface. If none of the previous solutions have resolved your issue, you can send in your Surface. If you decide to send it in, go to Device service and repair and sign in with your Microsoft account. If your device is already registered, select it and follow the instructions.
Use the Navigation pane in Word - Microsoft Support
To go to a page or a heading in a Word document without scrolling, use the Navigation pane. To open the Navigation pane, press Ctrl+F, or select the View tab and choose Navigation Pane.. Browse by headings
Applies To: Word for Microsoft 365, Word 2021, Word 2019, Word 2016
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