Customize the Quick Access Toolbar - Microsoft Support
Notes: To find an item in the Choose commands from list, it may be helpful to first confirm its location and name within the app. Commands that are no longer visible in the app could still be listed here under All commands.To help identify this type of command, a more descriptive tooltip name may appear in parentheses next to the legacy command name in this form:
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 2021, Word 2021, Outlook 2021, PowerPoint 2021, Access 2021, Project Professional 2021, Project Standard 2021, Publisher 2021, Visio Professional 2021, Visio Standard 2021, OneNote 2021, Excel 2019, Word 2019, Outlook 2019, PowerPoint 2019, Access 2019, Project Professional 2019, Project Standard 2019, Publisher 2019, Visio Professional 2019, Visio Standard 2019, 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, InfoPath 2013, SharePoint Workspace 2010
Find and remove duplicates - Microsoft Support
How to find and remove duplicates in Excel. Filter for unique values in large or small datasets to clean up your worksheets and workbooks.
Applies To: Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016
IFERROR function - Microsoft Support
Examples. Copy the example data in the following table, and paste it in cell A1 of a new Excel worksheet. For formulas to show results, select them, press F2, and then press Enter.
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 Web App
How to correct a #VALUE! error - Microsoft Support
Check your computer's date settings. Excel uses your computer's date system. If a cell's date isn't entered using the same date system, Excel won't recognize it as a true date.
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 Web App
Find your IP address in Windows - Microsoft Support
For Wi-Fi connection. Select Start > Settings > Network & internet > Wi-Fi and then select the Wi-Fi network you're connected to.
How to open Registry Editor in Windows 10 - Microsoft Support
There are two ways to open Registry Editor in Windows 10: In the search box on the taskbar, type regedit, then select Registry Editor (Desktop app) from the results.
SUMIF function - Microsoft Support
sum_range Optional.The actual cells to add, if you want to add cells other than those specified in the range argument. If the sum_range argument is omitted, Excel adds the cells that are specified in the range argument (the same cells to which the criteria is applied).. Sum_range should be the same size and shape as range.If it isn't, performance may suffer, and the formula will sum a range of ...
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
Share files and folders in OneDrive (personal) - Microsoft Support
It’s always good to stay on top of the content you’ve shared with friends, family, and collaborators. OneDrive makes it easy. Simply log into your account at OneDrive.com, and in the left-side navigation area, you’ll see a view called Shared.. This view lets you quickly see all of your content that’s shared, especially the content that you’ve shared with others.
Applies To: OneDrive (home or personal), OneDrive for Mac, OneDrive for Windows
在 Windows 中配对蓝牙设备 - Microsoft 支持
在快速设置中: 若要查找蓝牙的快速设置,请选择任务栏右侧的时间和日期旁边的 网络、 声音或 电池 图标 ( ) 。选择“蓝牙 ”将其打开。 如果在未连接任何蓝牙设备的情况下打开,则它可能显示为“未连接 ”。 如果在快速设置中看不到蓝牙 ,则可能需要添加它。
Microsoft 365 basics video training - Microsoft Support
Training: Learn how to quickly get started with Microsoft 365, share and collaborate, work in Microsoft Teams, work from anywhere, and try cool Microsoft 365 features.
Applies To: Microsoft 365 for home, Office for business, Office 365 Small Business, Microsoft 365 admin, Office 365 First Release program