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
Create and format a hard disk partition - Microsoft Support
To create a partition or volume (the two terms are often used interchangeably) on a hard disk, you must be logged in as an administrator, and there must be either unallocated disk space or free space within an extended partition on the hard disk.
Print a document in Word - Microsoft Support
If you want multiple copies of a printout, change the number of copies in the Print page: On Windows 7 or earlier, at the top of the Print page is a box labeled Copies with up and down arrows for you to choose how many copies of the document you want. Make your choice (either by entering a number or using the arrows), and then click Print.
Applies To: Word for Microsoft 365, Word for the web, Word 2021, Word 2019, Word 2016
Create a document - Microsoft Support
Click a template to see a preview. Click the arrows on the side of the preview to see more templates.
Applies To: Word for Microsoft 365, Word 2021, Word 2019, Word 2016
How to get and use app passwords - Microsoft Support
After you turn on two-step verification or set up the Authenticator app, you may run into issues if you use older devices (like Xbox 360 or a mail-sending security camera) that don't support two-step verification. For those devices, you can sign in with an app password instead. An app password is a long, randomly generated password that you provide only once instead of your regular password ...
How to sign in to Outlook on the web - Microsoft Support
Note: If you signed in with a Microsoft account such as an Outlook.com, Hotmail, Live, or MSN email account instead of your work or school account, sign out, and then sign in again using the correct account. Not sure which account you're signed in with? Select Account manager in the Outlook navigation header. If you're not signed in with the account you want, select Sign out and start the ...
Applies To: Office for business, Office 365 Small Business, Microsoft 365 admin, Outlook on the web, Outlook on the web for Exchange Server 2016
Guidelines and examples of array formulas - Microsoft Support
An array formula (one that spans multiple cells) can do calculations on rows and columns of cells where you might otherwise need to use several formulas. For example, you can count the number of characters that are contained in a range of cells, sum only numbers that meet certain conditions (such as the lowest values in a range or numbers that fall between an upper and lower boundary), and sum ...
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, Excel for iPad, Excel for iPhone
Create a document in Word for the web - Microsoft Support
Create, edit and share documents with Microsoft Word online. Learn how to use Word for the web to create, open, and rename documents with ease.
Applies To: Word for the web, Office for business
View previous versions of Office files - Microsoft Support
Use Version History to view previous versions of files stored in OneDrive or SharePoint libraries.
Applies To: Excel for Microsoft 365, Word for Microsoft 365, PowerPoint for Microsoft 365, Excel for Microsoft 365 for Mac, Word for Microsoft 365 for Mac, PowerPoint for Microsoft 365 for Mac, Excel for the web, Excel 2021, Word 2021, PowerPoint 2021, Excel 2021 for Mac, Word 2021 for Mac, PowerPoint 2021 for Mac, Excel 2019, Word 2019, PowerPoint 2019, Excel 2019 for Mac, Word 2019 for Mac, PowerPoint 2019 for Mac, Excel 2016, Word 2016, PowerPoint 2016
Troubleshoot installing Office - Microsoft Support
The issues you encounter when trying to install Microsoft 365, or Office 2021, 2019, or 2016 and how you fix them depends on whether your product is part of an Office for home or Office for business plan.. In addition, with Office for business plans only admins responsible for managing Microsoft 365 in their organization can do certain tasks. Therefore, admins should view the issues and ...
Applies To: Office 2021, Office 2021 for Mac, Office 2019, Office 2019 for Mac, Office 2016, Microsoft 365 for home, Office for business, Office 365 Small Business, Microsoft 365 admin, Microsoft 365 for Mac