Restore deleted files or folders in OneDrive - Microsoft Support
If you accidentally delete a file or folder in OneDrive, you may be able to recover it later from the OneDrive recycle bin.. For info about restoring a SharePoint file or folder, see how to restore items from the SharePoint recycle bin.For info about restoring SharePoint files stored in OneDrive, see Restore a previous version of a file in OneDrive.
Applies To: OneDrive for Business, SharePoint Server Subscription Edition, SharePoint Server 2019, OneDrive (work or school), OneDrive (home or personal), OneDrive (work or school) operated by 21Vianet, OneDrive for Mac, OneDrive for Windows
Combine text from two or more cells into one cell
Select the cell you want to combine first. Use commas to separate the cells you are combining and use quotation marks to add spaces, commas, or other text.
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, Excel Mobile
Create, load, or edit a query in Excel (Power Query) - Microsoft Support
A Data Model typically contains several tables arranged in a relationship. You load a query to a Data Model by using the Load To command to display the Import Data dialog box, and then selecting the Add this data to the Data Model check box.For more information about Data Models, see Find out which data sources are used in a workbook data model, Create a Data Model in Excel, and Use multiple ...
Applies To: Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016
XLOOKUP function - Microsoft Support
Use the XLOOKUP function to find things in a table or range by row. For example, look up the price of an automotive part by the part number, or find an employee name based on their employee ID. With XLOOKUP, you can look in one column for a search term and return a result from the same row in another column, regardless of which side the return column is on.
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 2016, Excel for iPad, Excel for iPhone, Excel for Android tablets, Excel for Android phones
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
Make a checklist in Word - Microsoft Support
Add an interactive checklist. Checklist is a feature that allows you to insert an interactive list in Word for Web. You can check and uncheck the checklist and keep track of the tasks that you are performing.
Applies To: Word for Microsoft 365, Word for the web, Word 2021, Word 2019, Word 2016
Stay protected with Windows Security - Microsoft Support
Tip: If you're a Microsoft 365 Family or Personal subscriber you get Microsoft Defender, our advanced security software for Windows, Mac, iOS, and Android, as part of your subscription.Learn more at Getting started with Microsoft Defender.
Encrypt email messages - Microsoft Support
When you need to protect the privacy of an email message, encrypt it. Encrypting an email message in Outlook means it's converted from readable plain text into scrambled cipher text.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016
Look up values in a list of data - Microsoft Support
C1 is the upper left cells of the range (also called the starting cell).. MATCH("Oranges",C2:C7,0) looks for Oranges in the C2:C7 range. You should not include the starting cell in the range. 1 is the number of columns to the right of the starting cell where the return value should be from. In our example, the return value is from column D, Sales. Top of Page
Applies To: Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2019, Excel 2016
My Computer is now This PC - Microsoft Support
Find it. To get to This PC in Windows 10, open File Explorer from the taskbar and select This PC in the left pane.. Pin it to Start. If you want This PC to show up in your Start menu, open File Explorer, right-click (or press and hold) This PC in the left pane, and then select Pin to Start. Now, there's a This PC tile on the Start menu.