To keep an area of a worksheet visible while you scroll to another area of the worksheet, go to the View tab, where you can Freeze Panes to lock specific rows and columns in place, or you can Split panes to create separate windows of the same worksheet.

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. ...

After you restart your computer, the uninstall tool automatically re-opens to complete the final step of the uninstall process. Follow the remaining prompts.

Microsoft Authenticator is a free app that helps you sign in to all your accounts without using a password - just use a fingerprint, face recognition, or a PIN.

若要捕获视频截图，请打开“截图工具”，选择“ 录制 ”按钮，然后选择“ 新建录制”，或按 Windows 徽标键 + Shift + R。选择要录制的屏幕区域，然后选择“ 开始”。完成后，选择“ 停止”。此时，可以按原样保存录制内容，或在 Clipchamp 视频编辑器中选择“在 Clipchamp 中编辑 ”以使用录制内容。

If pressing the Connect button in action center doesn't find your device in Windows 10, here are some things to try:. Check action center to see if your Windows device supports Bluetooth. If it does, there'll be a Bluetooth button in action center. Make sure it's turned on.

Get steps for connecting a Miracast wireless display. If pressing the Connect button in the action center doesn't find your device, try the troubleshooting steps provided at Fix connections to Miracast wireless displays.

On a Mac? See Check for Office for Mac updates automatically.. Click here for the Latest updates for versions of Office that use Windows Installer (MSI).. Choose your version of Office. If you're not sure what version of Office you have, see What version of Office am I using?. Not sure which type of install you have?

To clear your out of office status and turn off your automatic reply in Teams, return to the Out of Office screen, click the toggle next to Turn on automatic replies and select the Save button. Once you've scheduled an out of office status and message in Teams, you'll see automatic replies turned on in Outlook with the time range and message you set in Teams.

Send in your Surface. If none of the previous solutions have resolved your issue, you can send in your Surface. If you decide to send it in, go to Device service and repair and sign in with your Microsoft account. If your device is already registered, select it and follow the instructions.