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

Choose either Above screen, Below screen, or Overlaid on screen.. When you choose Above screen or Below screen, the captions window will appear as docked to the top or bottom screen edges in reserved space on your desktop, and other apps will not be blocked by the captions window.When docked to the top, you might find that live captions works well while sharing video in a virtual meeting or ...

Get from External Data Source. Get from Data Model. Use this option if your workbook contains a Data Model, and you want to create a PivotTable from multiple tables, enhance the PivotTable with custom measures, or are working with very large datasets.. Get from Power BI. Use this option if your organization uses Power BI and you want to discover and connect to endorsed cloud datasets you have ...

Important: Reassigning a combination of keys means that you can no longer use the combination for its original purpose.For example, pressing CTRL+B changes selected text to bold. If you reassign CTRL+B to a new command or other item, you will not be able to make text bold by pressing CTRL+B unless you restore the keyboard shortcut assignments to their original settings by selecting Reset All ...

Look in the Surface app. The easiest way to find which Surface model you have is to use the Surface app. It shows the model name of your Surface device and each Surface accessory.

For more information about adding additional editing languages and keyboard layouts see Change the language Office uses in its menus and proofing tools.. Using the Language bar to Switch Keyboard Layouts. When you switch a language by using the Language bar, the keyboard layout changes to the keyboard for that language.

Type three of the characters shown below, and then press Enter. The line is inserted for the full width of the page. When inserted into a column, the line is inserted to match the width of the column.

Training: Watch and learn how to use PowerPoint in Windows. Explore PowerPoint training guides, articles, and how-to videos.

Устранение неполадок с аксессуарами Bluetooth. Если вы можете включить Bluetooth, но у вас возникают проблемы со связыванием или использованием аксессуара Bluetooth, см. следующие действия, которые помогут вам устранить ...

Learn common SharePoint Online tasks with these videos and tutorials, and get links to more training for SharePoint and Office 365.