UNIQUE function - Microsoft Support
Examples. Example 1. This example uses SORT and UNIQUE together to return a unique list of names in ascending order. Example 2. This example has the exactly_once argument set to TRUE, and the function returns only those customers who have had service one time.
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
Set up auto-reply (out of office) - Microsoft Support
Notes: To set an automatic reply for contacts outside your company, select Outside My Organization > Auto-reply to people outside my organization, type in a message, and select OK.. The OK button may be missing because of certain screen solution and scaling settings. To resolve this issue, you can adjust the screen resolution and scaling settings, or use a large monitor.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016
Xbox Cloud Gaming in Microsoft Edge with Steam Deck
Update RECENT GAMES: Once you have used the shortcut and launched Xbox Cloud Gaming (Beta) at least once, it will appear in the RECENT GAMES section (again, within the desktop Steam client) with a blank background.Just as before, right-click, select Manage > Set custom artwork, navigate to your artwork and select Xbox_Cloud_Gaming_Capsule.jpg.
Applies To: Microsoft Edge
Control the formatting when you paste text - Microsoft Support
Merge Formatting (M) This option discards most formatting that was applied directly to the copied text, but it retains formatting that is considered emphasis, such as bold and italic, when it is applied to only a portion of the selection.The text takes on the style characteristics of the paragraph where it is pasted. The text also takes on any direct formatting or character style properties of ...
Applies To: Word for Microsoft 365, Word 2021, Word 2019, Word 2016, Word 2013
Windows activity history and your privacy - Microsoft Support
Note: If you have previous activity history stored in the cloud before Windows 11 23H2 and 22H2, January 23, 2024-KB5034204 update, you can use the Clear activity history button to delete previously stored data in the cloud. Otherwise, your activity history will be automatically deleted within 30 days from when your data was last synced to the cloud
Applies To: Microsoft account dashboard
Reduce the size of your mailbox and Outlook Data Files (.pst and .ost)
There are several ways to reduce your mailbox size. You can use the Mailbox Cleanup tool to view the size of your mailbox and individual folders. This tool can also help you search for older or very large messages that you might want to delete or move to an Outlook Data File (.pst).
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016, Outlook 2013
Welcome to Copilot in OneNote - Microsoft Support
In the compose box, enter a request like “List pros and cons” and details to clarify what insights you want to know about your notes.For example, “List the pros and cons of the Q4 sales strategy" or "List the pros and cons of buying a used car. Alternatively, select the View Prompt icon to open the Copilot prompt menu and select List the pros and cons of.
Applies To: OneNote for Microsoft 365
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
Enable or disable macros in Microsoft 365 files
Disable all macros except digitally signed macros Macros are disabled, and security alerts appear if there are unsigned macros present.However, if the macro is digitally signed by a trusted publisher, the macro just runs. If the macro is signed by a publisher you haven't trusted yet, you are given the opportunity to enable the signed macro and trust the publisher.
Applies To: Excel for Microsoft 365, Word for Microsoft 365, Outlook for Microsoft 365, PowerPoint for Microsoft 365, Access for Microsoft 365, Excel 2021, Word 2021, Outlook 2021, PowerPoint 2021, Access 2021, Visio Professional 2021, Visio Standard 2021, Excel 2019, Word 2019, Outlook 2019, PowerPoint 2019, Access 2019, Visio Professional 2019, Visio Standard 2019, Excel 2016, Word 2016, Outlook 2016, PowerPoint 2016, Access 2016, Visio Professional 2016, Visio Standard 2016
Create and use modern pages on a SharePoint site
Learn how to add a page to a SharePoint Online site. Add web parts. Web parts are the building blocks of your page. For more information on the different types of web parts and how to use them, check out Using web parts on pages.. If you have the content pane enabled:
Applies To: SharePoint Server Subscription Edition, SharePoint Server 2019, SharePoint in Microsoft 365, Microsoft 365 admin, SharePoint operated by 21Vianet