SUMIFS function - Microsoft Support
Problem. Description. 0 (Zero) is shown instead of the expected result. Make sure Criteria1,2 are in quotation marks if you are testing for text values, like a person's name.. The result is incorrect when Sum_range has TRUE or FALSE values.. TRUE and FALSE values for Sum_range are evaluated differently, which may cause unexpected results when they're added. ...
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
Record a slide show with narration and slide timings
The slide show opens in the Recording window (which looks similar to Presenter view), with buttons at the top left for starting, pausing, and stopping the recording.Click the round, red button (or press R on your keyboard) when you are ready to start the recording. A three-second countdown ensues, then the recording begins.
Applies To: PowerPoint for Microsoft 365, PowerPoint for Microsoft 365 for Mac, PowerPoint for the web, PowerPoint 2021, PowerPoint 2021 for Mac, PowerPoint 2019, PowerPoint 2019 for Mac, PowerPoint 2016
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
How to perform a clean boot in Windows - Microsoft Support
How to determine what is causing the problem after you do a clean boot. If your problem does not occur while the computer is in a clean boot environment, then you can determine which startup application or service is causing the problem by systematically turning them on or off and restarting the computer.
Help with the Microsoft account recovery form
2. Fill out the form using a recognized device and location. If possible, complete the form using a device you previously used to sign into your account and at a location where you commonly use that device and that we'll recognize, such as your home or office.
如何在 OneDrive 中移除帳戶 - Microsoft Support
附註: 移除帳戶並不會遺失檔案或資料夾。 取消連結之後,您所有的檔案都可從OneDrive網頁版取得。 標示為 此裝置上可用 的檔案會保留在您電腦的 OneDrive 資料夾中。. 標示為 線上時可用 的檔案僅能從網路上的 OneDrive 存取。. 如果您只想要移除特定資料夾,請參閱如何選擇要同步處理到您電腦的 ...
Applies To: OneDrive (home or personal), OneDrive for Mac, OneDrive for Windows
FILTER function - Microsoft Support
The FILTER function allows you to filter a range of data based on criteria you define.
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
See what's on the Start menu - Microsoft Support
Get started. To pin your favorite apps to the Start menu, select and hold (or right-click) the app you want to pin. Then select Pin to Start .. To group your apps into folders, simply drag an app on top of another with mouse or touch or highlight the app with your keyboard and use the Ctrl + Shift + <Left or Right arrow> keyboard shortcut.. Your apps and programs—right at your fingertips
Windows 中 HDR 视频的显示要求 - Microsoft 支持
如果转到“设置”>“系统”>“显示”>“高级显示”,但显示器未显示为通过认证(而是在“hdr 认证”旁边显示“找不到”),则可能是因为显示器未通过 hdr 认证,或者显示器制造商可能尚未发布有关显示器的 hdr 认证信息。要了解显示器是否已通过 hdr 认证,请访问设备制造商的网站。
Remove a page break - Microsoft Support
There are two types of page breaks in Word: breaks that Word automatically adds to mark the end of each page, and manual page breaks that you can add.
Applies To: Word for Microsoft 365, Word for Microsoft 365 for Mac, Word for the web, Word 2021, Word 2021 for Mac, Word 2019, Word 2019 for Mac, Word 2016