Find or replace text and numbers on a worksheet
Tip: If you want to find cells that just match a specific format, you can delete any criteria in the Find what box, and then select a specific cell format as an example. Select the arrow next to Format, select Choose Format From Cell, and then select the cell that has the formatting that you want to search for.
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016
Apply data validation to cells - Microsoft Support
Note: To let a user enter percentages, for example 20%, select Decimal in the Allow box, select the type of restriction that you want in the Data box, enter the minimum, maximum, or specific value as a decimal, for example .2 , and then display the data validation cell as a percentage by selecting the cell and clicking Percent Style in the Number group on the Home tab.
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016
Update your security processor (TPM) firmware - Microsoft Support
2. Install any applicable firmware updates. If you have a Surface device, see Security issue for TPM on Surface devices for more information and instructions.. If your device is not from Microsoft, locate the device manufacturer of your device in the following table, select the corresponding link, and apply the firmware update that's provide.
Microsoft 365 help & learning
Get Microsoft 365 support, help, and learning resources. Organize your life, expand your creativity, and protect what’s important with Microsoft 365
Applies To: Office 2021, Office 2021 for Mac, Office 2019, Office 2019 for Mac, Office 2016, Microsoft 365 for home, Microsoft 365 for Mac, Microsoft 365 for Windows
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
Activer Windows - Support Microsoft
Si vous installez Windows sur un nouvel appareil ou une carte mère pour la première fois et que vous n’avez pas de clé de produit, sélectionnez Je n’ai pas de clé de produit pendant les écrans d’installation. À l’invite, entrez le compte Microsoft à utiliser pour acheter une licence numérique pour cet appareil.
SUBTOTAL function - Microsoft Support
This article describes the formula syntax and usage of the SUBTOTAL function in Microsoft Excel.. Description. Returns a subtotal in a list or database. It is generally easier to create a list with subtotals by using the Subtotal command in the Outline group on the Data tab in the Excel desktop application. Once the subtotal list is created, you can modify it by editing the SUBTOTAL function.
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016
How do I create a new account for Skype? - Microsoft Support
If you don't have a Microsoft account for Skype: In the Skype sign in window, select Create new account (or go directly to the Create an account page).
Present your data in a Gantt chart in Excel - Microsoft Support
Need to show status for a simple project schedule with a Gantt chart? Though Excel doesn’t have a predefined Gantt chart type, you can simulate one by customizing a stacked bar chart to show the start and finish dates of tasks, like this:
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016
Digital signatures and certificates - Microsoft Support
Certificate authority (CA) A certificate authority is an entity similar to a notary public.It issues digital certificates, signs certificates to verify their validity and tracks which certificates have been revoked or have expired.
Applies To: Excel for Microsoft 365, Word for Microsoft 365, PowerPoint for Microsoft 365, Access for Microsoft 365, Visio Plan 2, Excel 2021, Word 2021, PowerPoint 2021, Access 2021, Visio Professional 2021, Visio Standard 2021, Excel 2019, Word 2019, PowerPoint 2019, Access 2019, Visio Professional 2019, Visio Standard 2019, Excel 2016, Word 2016, PowerPoint 2016, Access 2016, Visio Professional 2016, Visio Standard 2016