Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.
TEXT function - Microsoft Support
The TEXT function lets you change the way a number appears by applying formatting to it with format codes. It's useful in situations where you want to display numbers in a more readable format, or you want to combine numbers with text or symbols. Note: The TEXT function converts numbers to text, which may make it difficult to reference in later ...
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
Protect your PC from potentially unwanted applications
To configure potentially unwanted app blocking go to Start > Settings > Update & Security > Windows Security > App & browser control > Reputation-based protection settings . There you'll find a control that lets you turn potentially unwanted app blocking off, and select if you want to block apps, downloads, or both.
Get help with your Microsoft account - Microsoft Support
Help with BitLocker. Finding product keys for Windows and Office. Other support. Help with a work or school account password. I need to talk to a customer support agent. Learn how to get Microsoft account help, troubleshoot sign in issues, keep your account secure, and manage your Microsoft account dashboard.
Applies To: Microsoft account dashboard
Troubleshoot problems updating Windows - Microsoft Support
The following tips can help you pinpoint the issue affecting your device. Before you begin, make sure your device is plugged into a power source and connected to the internet. Then, try the steps listed below to get your PC to update. Some updates require administrator access. If your account doesn't have administrator access, see Create a ...
Create a named range from selected cells in a worksheet
Select the range you want to name, including the row or column labels. Click Formulas > Create from Selection. In the Create Names from Selection dialog box, select the checkbox (es) depending on the location of your row/column header. If you have only a header row at the top of the table, then just select Top row.
Applies To: Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016, Excel 2013
How to start a scan for viruses or malware in Microsoft Defender
Windows Android Mac. From the Microsoft Defender dashboard. Select Device details. Select Manage in Windows Security. Select Quick scan. Tips: If you want a deeper scan, instead of selecting Quick scan in step 3, select Scan options and choose the type of scan you want. For the most complete scan, run Microsoft Defender Offline.
Applies To: Microsoft Defender on Android, Microsoft Defender on Mac, Microsoft Defender on Windows
What's new in Excel 2021 for Windows - Microsoft Support
Excel 2021 for Windows allows you to collaboratively work with others and analyze data easily with new Excel capabilities including co-authoring, Dynamic Arrays, XLOOKUP, and LET functions. Note: Some features listed below are not included in Excel LTSC 2021 for commercial customers. Each of those features is noted if it does not apply to Excel ...
Applies To: Excel 2021
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
Repair Outlook Data Files (.pst and .ost) - Microsoft Support
Repair an Outlook data file (.pst) file. Open SCANPST.EXE. Select Browse to select the Outlook Data File (.pst) you want to scan. If you need help locating your Outlook Data File, see Locating the Outlook Data Files. Note: By default, a new log file is created during the scan.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016
Format text as superscript or subscript - Microsoft Support
Keyboard shortcuts: Apply superscript or subscript. To make text appear slightly above (superscript) or below (subscript) your regular text, you can use keyboard shortcuts. Select the character that you want to format. For superscript, press Ctrl, Shift, and the Plus sign (+) at the same time. For subscript, press Ctrl and the Equal sign (=) at ...
Applies To: PowerPoint for Microsoft 365, PowerPoint for Microsoft 365 for Mac, PowerPoint for the web, PowerPoint 2021, PowerPoint 2021 for Mac, PowerPoint 2019, PowerPoint 2019 for Mac, PowerPoint 2016