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.

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 ...

To make substantial layout changes to a PivotTable or its various fields, you can use one of three forms: Compact form displays items from different row area fields in one column and uses indentation to distinguish between the items from different fields.Row labels take up less space in compact form, which leaves more room for numeric data.

Get started with basic tasks in Excel such as opening a workbook, entering and formatting data, calculating data, and trying some quick analysis features..

Important: Section breaks are different from page breaks.If you already have a page break before the page where you want to change the header or footer, remove a page break and replace it with a section break as shown below.

Using the equal sign to type text or a value. Because the equal sign (=) is used to indicate a formula when you type text or a value in a cell, Excel evaluates what you type; however, this may cause unexpected filter results.To indicate an equality comparison operator for either text or a value, type the criteria as a string expression in the appropriate cell in the criteria range:

This article is for Outlook.com. If you're using Outlook for Windows, see Fixes or workarounds for recent issues in Outlook for Windows.. If you're having problems accessing Outlook.com, you can see the status of Microsoft Office Online Services at the Service Health portal.. If you're having problems sending or receiving email, read how to Fix Outlook.com email sync issues.

To turn it off, switch the setting to Off.. Turning off Microsoft Defender Firewall could make your device (and network, if you have one) more vulnerable to unauthorized access.

In the search box on the taskbar, type Create a restore point, and select it from the list of results.

Note: The TEXT function converts numbers to text, which may make it difficult to reference in later calculations.It’s best to keep your original value in one cell, and then use the TEXT function in another cell. Then, if you need to build other formulas, always reference the original value and not the TEXT function result.