FILTER function - Microsoft Support
In the following example we used the formula =FILTER(A5:D20,C5:C20=H2,"") to return all records for Apple, as selected in cell H2, and if there are no apples, return an empty string ("").
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel for iPad, Excel for iPhone, Excel for Android tablets, Excel for Android phones
Create and send email in Outlook - Microsoft Support
Focused Inbox. Focused Inbox helps you focus on the emails that matter most. It separates your inbox into two tabs—Focused and Other. If messages aren't sorted the way you like, you can move them and set where to deliver future messages from that sender.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016
Print in Microsoft Edge - Microsoft Support
Choose number of pages to print per sheet: Printing multiple pages on a single sheet of paper is a useful technique to save paper, reduce printing costs, and create compact versions of your documents. The number of pages that can be printed on a single sheet depends on the capabilities of your printer and the printing options you choose (Example: 1, 2, 4, 6, 9 or 16 pages per sheet).
Customize keyboard shortcuts - Microsoft Support
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 ...
Applies To: Word for Microsoft 365, Word 2021, Word 2019, Word 2016
Create a template - Microsoft Support
Tip: To change where your application automatically saves your templates, click File > Options > Save and type the folder and path you want to use in the Default personal templates location box. Any new templates you save will be stored in that folder, and when you click File > New > Personal, you'll see the templates in that folder.
Applies To: Excel for Microsoft 365, Word for Microsoft 365, PowerPoint for Microsoft 365, Access for Microsoft 365, Excel for Microsoft 365 for Mac, Word for Microsoft 365 for Mac, PowerPoint for Microsoft 365 for Mac, Word for the web, Excel 2021, Word 2021, PowerPoint 2021, Access 2021, Visio Standard 2021, Excel 2021 for Mac, Word 2021 for Mac, PowerPoint 2021 for Mac, Excel 2019, Word 2019, PowerPoint 2019, Access 2019, Visio Standard 2019, Excel 2019 for Mac, Word 2019 for Mac, PowerPoint 2019 for Mac, Excel 2016, Word 2016, PowerPoint 2016, Access 2016, Visio Standard 2016
Reinstall Windows - Microsoft Support
Notes: Reinstalling Windows 11 using installation media while choosing to ‘Keep nothing’ (a clean install) will automatically enable reserved storage if the partition you reinstall Windows to is 20GB or larger. Reserved storage sets aside disk space to be used by updates, apps, temporary files, and system caches, thus improving the day-to-day function of your PC by ensuring that critical ...
Como iniciar sessão no Hotmail - Suporte da Microsoft
Notas: A sua palavra-passe do Hotmail ou Outlook.com é a mesma que a palavra-passe da sua Conta Microsoft. Se conseguir iniciar sessão mas estiver a ter problemas com o Outlook.com, verifique o estado do serviço.Se o estado não estiver verde, aguarde até que o serviço volte ao normal e tente novamente.
Applies To: Outlook.com
Hotmail - Microsoft
Hotmail が Outlook.com になりました。 Hotmail アカウントにサインインするには、[ www.outlook.com] に移動し、[サインイン] を選択 します。 ユーザー名またはパスワードを忘れた場合は、 サインインのトラブルシューティング ツールを使用しますが、2 年以上アカウントにサインインしていない場合は ...
Applies To: Outlook.com
Use the On-Screen Keyboard (OSK) to type - Microsoft Support
To open the On-Screen Keyboard. Go to Start , then select Settings > Accessibility > Keyboard, and turn on the On-Screen Keyboard toggle. A keyboard that can be used to move around the screen and enter text will appear on the screen. The keyboard will remain on the screen until you close it.
How do I upgrade Office? - Microsoft Support
Microsoft 365 Family or Personal. If you have a Microsoft 365 Family or Microsoft 365 Personal subscription, you already have the most current version of Office at no additional cost and should already receive the latest features to your Office apps.See What’s new in Microsoft 365 to learn more about the newest features.. If you don’t see these features, you may not have received the ...
Applies To: Excel for Microsoft 365, Word for Microsoft 365, Outlook for Microsoft 365, PowerPoint for Microsoft 365, Access for Microsoft 365, OneNote for Microsoft 365, Project Online Desktop Client, Publisher for Microsoft 365, Visio Plan 2, Excel for Microsoft 365 for Mac, Word for Microsoft 365 for Mac, Outlook for Microsoft 365 for Mac, PowerPoint for Microsoft 365 for Mac, Excel 2016, Word 2016, Outlook 2016, PowerPoint 2016, Access 2016, OneNote 2016, Project Professional 2016, Project Standard 2016, Publisher 2016, Visio Professional 2016, Visio Standard 2016, Office 2016, Excel 2016 for Mac, Word 2016 for Mac, Outlook 2016 for Mac, PowerPoint 2016 for Mac, OneNote 2016 for Mac, Office 2016 for Mac, Excel 2013, Word 2013, Outlook 2013, PowerPoint 2013, Access 2013, OneNote 2013, Visio Professional 2013, Visio 2013, Office 2013, Microsoft 365 for home, Office for business, Office 365 Small Business, Microsoft 365 admin, Office 365 operated by 21Vianet, Office 365 operated by 21Vianet - Small Business Admin, Office 365 operated by 21Vianet - Admin, Project Online, Microsoft 365 for Mac, Office 365 Germany - Enterprise, Office 365 Germany - Enterprise admin