Use conditional formatting to highlight information in Excel
Notes: The formatting options that appear in the Formatting tab depend on the data you have selected. If your selection contains only text, then the available options are Text, Duplicate, Unique, Equal To, and Clear.When the selection contains only numbers, or both text and numbers, then the options are Data Bars, Colors, Icon Sets, Greater, Top 10%, and Clear.
Applies To: Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2019, Excel 2016
Insert or delete rows and columns - Microsoft Support
Insert rows. To insert a single row: Right-click the whole row above which you want to insert the new row, and then select Insert Rows. To insert multiple rows: Select the same number of rows above which you want to add new ones.Right-click the selection, and then select Insert Rows.. Insert columns. To insert a single column: Right-click the whole column to the right of where you want to add ...
Applies To: Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2019, Excel 2016
Signing in with a passkey - Microsoft Support
Creating a passkey. To create a passkey for your Microsoft account, follow these steps on the device for which you’d like to create a passkey:
Applies To: Microsoft account dashboard
Open your entire favorites bar in Microsoft Edge
Choose Open all, or Open all in new window, or Open all in new InPrivate window.
See your Google Calendar in Outlook - Microsoft Support
By importing a snapshot of your Google calendar into Outlook, you can see it alongside other calendars in the Outlook Calendar View. To keep the imported calendar up-to-date, subscribe to the Google Calendar in Outlook.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016, New Outlook for Windows
Transcribe your recordings - Microsoft Support
The transcribe feature converts speech to a text transcript with each speaker individually separated. After your conversation, interview, or meeting, you can revisit parts of the recording by playing back the timestamped audio and edit the transcription to make corrections.
Applies To: Word for Microsoft 365, OneNote for Microsoft 365, Word for the web
Change your two-step verification method and settings
After you set up your security verification methods for your work or school account, you can update the related details. Using the Security info page
Download free, pre-built templates - Microsoft Support
Find and download free templates to create documents like calendars, business cards, letters, greeting cards, brochures, newsletters, or resumes.
Applies To: Excel for Microsoft 365, Word for Microsoft 365, PowerPoint for Microsoft 365, Access for Microsoft 365, Project Online Desktop Client, Publisher for Microsoft 365, Excel 2021, Word 2021, PowerPoint 2021, Access 2021, Project Professional 2021, Project Standard 2021, Publisher 2021, Excel 2019, Word 2019, PowerPoint 2019, Access 2019, Project Professional 2019, Project Standard 2019, Publisher 2019, Excel 2016, Word 2016, PowerPoint 2016, Access 2016, Project Professional 2016, Project Standard 2016, Publisher 2016, Visio Professional 2016, Visio 2010, InfoPath 2013
Protect a worksheet - Microsoft Support
Option. Allows users to. Select locked cells. Move the pointer to cells for which the Locked box is checked on the Protection tab of the Format Cells dialog box. By default, users are allowed to select locked cells. Select unlocked cells
Applies To: Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2019, Excel 2016
SUMIF function - Microsoft Support
sum_range Optional.The actual cells to add, if you want to add cells other than those specified in the range argument. If the sum_range argument is omitted, Excel adds the cells that are specified in the range argument (the same cells to which the criteria is applied).. Sum_range should be the same size and shape as range.If it isn't, performance may suffer, and the formula will sum a range of ...
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