Recover lost files on Windows 10 - Microsoft Support
If you can’t locate a lost file from your backup, then you can use Windows File Recovery, which is a command line app available from the Microsoft Store.Use this app to try to recover lost files that have been deleted from your local storage device (including internal drives, external drives, and USB devices) and can’t be restored from the Recycle Bin.
Open and find items in an Outlook Data File (.pst)
Expand the top level of the Outlook data file in the Outlook Navigation pane to see the subfolders in the file. Click each subfolder to see the contents.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016
Fix problems with your PC by using Windows Update
Windows Update recommends a reinstall after an update installation fails. If an update fails to install because of problems related to system files or components, you might see the following message in the Windows Update page in Settings:. Reinstall your current version of Windows to repair system files and components.
POP, IMAP, and SMTP settings for Outlook.com
If you're trying to add your Outlook.com account to Outlook or another mail app, you might need the POP, IMAP, or SMTP settings. You can find them below or by viewing them in your Outlook.com settings.. Outlook and Outlook.com may be able to detect your account's mailbox settings automatically, but for other non-Microsoft accounts, you may need to contact your email provider for their settings.
Applies To: Outlook for Microsoft 365, Outlook for Microsoft 365 for Mac, Outlook 2021, Outlook 2021 for Mac, Outlook 2019, Outlook 2019 for Mac, Outlook 2016, Outlook Web App for Office 365, Outlook Web App for Office 365 Small Business, Outlook on the web, Outlook.com, Outlook Web App for Office 365 operated by 21Vianet, Outlook Web App Light, New Outlook for Windows, Outlook for Android, Outlook Mail for Windows 10, Outlook on the web for Exchange Server 2016, Outlook on the web for Exchange Server 2019, Outlook Web App
Filter by using advanced criteria - Microsoft Support
Using the equal sign to type text or a value. Because the equal sign (=) is used to indicate a formula when you type text or a value in a cell, Excel evaluates what you type; however, this may cause unexpected filter results.To indicate an equality comparison operator for either text or a value, type the criteria as a string expression in the appropriate cell in the criteria range:
Applies To: Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016
Count how often a value occurs - Microsoft Support
The COUNTIFS function is similar to the COUNTIF function with one important exception: COUNTIFS lets you apply criteria to cells across multiple ranges and counts the number of times all criteria are met. You can use up to 127 range/criteria pairs with COUNTIFS. The syntax for COUNTIFS is: COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2],…)
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
Fix your Outlook email connection by repairing your profile
On the Email tab, choose your account (profile), and then choose Repair.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016, Office for business, Office 365 Small Business, Microsoft 365 admin
Send and receive text messages from your PC - Microsoft Support
Adding Emojis to your conversation. Below the message box are three buttons to help you insert content into your message. The emoji button opens menus where you can quickly search for what you want.
Solve PC problems remotely with Remote Assistance and Easy Connect
Do one of the following: If you've never used Easy Connect, select Use Easy Connect.. If you've used Easy Connect before, select your helper’s contact name. To invite someone who isn't on your contact list, select Invite someone to help you.
行から列、または列から行にデータを入れ替える (配置の転換)
列にデータを含むワークシートがあり、行内で並べ替えるために回転する必要がある場合は、 トランスポーズ 機能を使用します。 これを使用すると、データをすばやく列から行に切り替えることができます。
Applies To: Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2019, Excel 2016