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
Getting ready for the Windows 11 upgrade - Microsoft Support
If you're running Windows 8.1 or earlier, or if your PC doesn't meet the minimum system requirements to run Windows 11, consider moving to a new Windows 11 device. Find a PC that meets your needs. Set up your Microsoft account to transfer files and favorites. One account connects your device across Microsoft apps and services like Microsoft 365, OneDrive, Edge, and Microsoft Store.
Manage cameras with Camera settings in Windows 11
Note: Some cameras won't appear in the Camera settings page.These include infrared (IR) cameras used for Windows Hello Face authentication, cameras using DirectShow technology (like many apps provided by DSLR or action camera manufacturers so their devices can be used as webcams), and proprietary cameras that aren't managed by Windows—such as industrial cameras and many networked cameras.
Office 2021 and Office LTSC for Windows and Mac FAQ
Microsoft 365 is a subscription that comes with premium apps like Word, Excel, PowerPoint, OneNote, Outlook, Publisher, and Access (Publisher and Access available on PC only). The apps can be installed on multiple devices, including PCs, Macs, iPads, iPhones, Android tablets, and Android phones. Microsoft 365 also comes with services like 1 TB of OneDrive storage, 60 Skype minutes per month ...
Applies To: Office 2021, Office 2021 for Mac
Change how the message list is displayed in Outlook
In the Show Columns window, in the Available columns list, select a column name, and then select Add.. If the column that you want is not in the Available columns list, click the Select available columns from drop down to see additional sets of columns.. To create a custom column, select New Column, enter a Name for the column, and then select the Type and Format of information that you want ...
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016, Office for business, Office 365 Small Business, Microsoft 365 admin, Outlook on the web, Outlook.com, New Outlook for Windows
POP, IMAP, and SMTP settings for Outlook.com
If you're trying to add your Outlook.com account to Outlook or another mail app, you might need the POP, IMAP, or SMTP settings. You can find them below or by viewing them in your Outlook.com settings.. Outlook and Outlook.com may be able to detect your account's mailbox settings automatically, but for other non-Microsoft accounts, you may need to contact your email provider for their settings.
Applies To: Outlook for Microsoft 365, Outlook for Microsoft 365 for Mac, Outlook 2021, Outlook 2021 for Mac, Outlook 2019, Outlook 2019 for Mac, Outlook 2016, Outlook Web App for Office 365, Outlook Web App for Office 365 Small Business, Outlook on the web, Outlook.com, Outlook Web App for Office 365 operated by 21Vianet, Outlook Web App Light, New Outlook for Windows, Outlook for Android, Outlook Mail for Windows 10, Outlook on the web for Exchange Server 2016, Outlook on the web for Exchange Server 2019, Outlook Web App
Can my PC run Windows 11? - Microsoft Support
Your PC can run Windows 11 if it meets minimum (basic) system requirements. For information on basic system requirements and additional requirements for specific features, see Find Windows 11 specs, features, and computer requirements.
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
Insert a signature - Microsoft Support
Scan the page and save it on your computer in a common file format: .bmp, .jpg, or .png. For information on how to use your scanner, use the manufacturer’s manual or Web site.
Applies To: Word for Microsoft 365, Word for Microsoft 365 for Mac, Word 2021, Word 2021 for Mac, Word 2019, Word 2019 for Mac, Word 2016
How do I log on as an administrator? - Microsoft Support
Open User Accounts by clicking the Start button , clicking Control Panel, clicking User Accounts and Family Safety, clicking User Accounts, and then clicking Manage another account .. If you're prompted for an administrator password or confirmation, type the password or provide confirmation.