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 new workbook - Microsoft Support
A workbook is a file that contains one or more worksheets to help you organize data. You can create a new workbook from a blank workbook or a template. By default, a new workbook contains three worksheets, but you can change the number of worksheets that you want a new workbook to contain. You can also add and remove worksheets as needed.
Applies To: Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016, Excel 2013
Find and lock a lost Windows device - Microsoft Support
Turn on Find my device. When you set up a new device, you can decide whether to turn on or turn off the Find my device setting. If you turned it off during setup and now want to turn it on, make sure your Windows device is connected to the internet, has enough battery power so it can send its location, and that you're signed in to the device using your Microsoft account.
Applies To: Microsoft account dashboard
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
Search indexing in Windows 10: FAQ - Microsoft Support
Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.
Common file name extensions in Windows - Microsoft Support
Extension. Format. aac, adt, adts. Windows audio file. accdb. Microsoft Access database file. accde. Microsoft Access execute-only file. accdr. Microsoft Access ...
How to use alarms and timers in the Clock app in Windows 10
Alarms and timers work even if the app is closed or your device is locked. If you see a warning that notifications only show if the device is awake, make sure your device doesn’t go to sleep (Go to Start > Settings > System > Power & sleep to adjust your device’s sleep settings).
Windows の回復オプション - Microsoft サポート
重要: デバイスを暗号化した場合は、PC をリセットするために BitLocker キーが必要です。 BitLocker キーがわからない場合は、「BitLocker 回復キーを検索する」を参照してください。. リセット プロセス中に、画面が長時間 (場合によっては 15 分以上) 黒になる可能性があり、この期間中にデバイスが ...
Help in WordPad - Microsoft Support
Get answers to common questions about WordPad. Here are a few tips to help you use WordPad: To open and save files, select File, then select New to create a new document, Open to work with an existing document, or Save to save your document.(If your document doesn't have a name, WordPad will ask you to provide one.)
Design the layout and format of a PivotTable - Microsoft Support
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.
Applies To: Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2016, Excel 2013