This allows Excel to return an array of all names. Tips: If you format the range of names as an Excel table, then the formula will automatically update when you add or remove names. If you want to sort the list of names, you can add the SORT function: =SORT (UNIQUE (B2:B12&" "&A2:A12)) Example 4. This example compares two columns and returns ...

Create a presentation. Open PowerPoint. In the left pane, select New. Select an option: To create a presentation from scratch, select Blank Presentation. To use a prepared design, select one of the templates. To see tips for using PowerPoint, select Take a Tour, and then select Create, . Add a slide.

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

設定で目的の言語とは異なる言語で記述されたページを開くと、Microsoft Edge自動的に翻訳を求めるメッセージが表示されます。 翻訳アイコン は、外国語で記述された Web ページに移動すると、アドレス バーに表示されます。 言語が設定の優先言語の一覧に含まれていない場合、言語は外部言語 ...

In the search box on the taskbar, type System Information, right-click System Information in the list of results, then select Run as administrator. Or you can select the Start button, and then under Windows Administrative Tools, select System Information. At the bottom of the System Information window, find Device Encryption Support.

Encontrar la papelera de reciclaje. Windows 10. Si en el escritorio no aparece ningún icono, haz clic con el botón derecho en el escritorio (o mantenlo presionado) y selecciona Ver. Si Mostrar iconos del escritorio no tiene ninguna marca de verificación, haga clic en él para agregar uno. Si eso no diera resultado, prueba lo siguiente ...

Get going quickly and easily with Microsoft 365 video training. Start now. See how to get started with Copilot for Microsoft 365, your everyday AI companion. Watch Copilot videos. Learn what's possible with Word, Excel, and PowerPoint. Download now. Visit the small business help & learning page to learn how you can use Microsoft 365 in your ...

Turn offline access on or off. Offline is turned on by default in new Outlook for Windows. To turn it off or on, do the following: Select Settings > General > Offline. Select the toggle Enable offline email, calendar, and people to turn offline access on or off. Select Save.

Sorting data helps you quickly visualize and understand your data better, organize and find the data that you want, and ultimately make more effective decisions. You can sort data by text (A to Z or Z to A), numbers (smallest to largest or largest to smallest), and dates and times (oldest to newest and newest to oldest) in one or more columns.

Go to Home > Replace. Enter the word or phrase you want to replace in Find what. Enter your new text in Replace with. Choose Replace All to change all occurrences of the word or phrase. Or, select Find Next until you find the one you want to update, and then choose Replace. To specify only upper or lowercase in your search, select More > Match ...