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
Create a new workbook - Microsoft Support
A workbook is a file that contains one or more worksheets to help you organize data. You can create a new workbook from a blank workbook or a template. By default, a new workbook contains three worksheets, but you can change the number of worksheets that you want a new workbook to contain. You can also add and remove worksheets as needed.
Applies To: Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016, Excel 2013
Help with the Microsoft account recovery form
2. Fill out the form using a recognized device and location. If possible, complete the form using a device you previously used to sign into your account and at a location where you commonly use that device and that we'll recognize, such as your home or office.
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
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
Cómo usar la aplicación Comprobación de estado del PC
Cómo abrir la Comprobación de estado del PC. En Windows, escribe "Comprobación de estado del PC" en el área de búsqueda de la barra de tareas y selecciónalo en la lista de resultados.
Find and open File Explorer - Microsoft Support
File Explorer in Windows 11 helps you get the files you need quickly and easily. To check it out in Windows 11, select it on the taskbar or the Start menu, or press the Windows logo key + E on your keyboard.. How to use File Explorer:
How to find and enable missing Copilot button in Microsoft 365 apps
Important: Copilot in Outlook only supports work or school accounts, and Microsoft accounts using outlook.com, hotmail.com, live.com, and msn.com email addresses at this time. Any Microsoft account using an account from a third-party email provider, such as a Gmail, Yahoo, or iCloud, can still use Outlook, but won't have access to the Copilot features in Outlook.
Applies To: Excel for Microsoft 365, Word for Microsoft 365, Outlook for Microsoft 365, PowerPoint for Microsoft 365, OneNote for Microsoft 365, Excel for Microsoft 365 for Mac, Word for Microsoft 365 for Mac, Outlook for Microsoft 365 for Mac, PowerPoint for Microsoft 365 for Mac, OneNote for Microsoft 365 for Mac
Share your network printer - Microsoft Support
In Windows 10, you can share your printer with many PCs on your network. To share a printer from the PC that the printer is connected to (the primary PC) with secondary PCs that the printer is not connected to, you must set up sharing settings for the printer, connect the printer to the primary PC (either wirelessly or by using a USB cable), and then turn on the printer.
How do I use the Fn key/F Lock key/Alternate command keys?
Alternate command key. What it does. Help. Opens the Help system (if any) for the active window. Undo. Cancels the previous action. Redo. Cancels the previous Undo action.