In the upper left corner of the window, select the app launcher > All apps > SharePoint Tip: If you don't see the SharePoint app under All apps, use the Search box near the top of the window to search for SharePoint.

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

Notes: You don't need a smartphone to receive a security code. Text messages may come from either "MSFT", a short number, or a mobile number.If you have requested a security code, you can trust the message that arrives.

Note: The boundary is the line between cells, columns, and rows.If a column is too narrow to display the data, you will see ### in the cell.

If you want to change what appears behind you in your video meeting or call, you can either blur your background, replace it entirely with any image you want, or use Teams virtual background template.And with a Teams Premium license, you can change your Teams meeting background to a branded logo or image specific to your company.

Change the appearance of your email. Select View.. From here, you can: Change the size of the Folder Pane.

Training: Get up to speed in minutes, quickly refer to things you’ve learned, and master keyboard shortcuts with these handy cheat sheets for Microsoft Office.

Use AutoFilter or built-in comparison operators like "greater than" and “top 10” in Excel to show the data you want and hide the rest. Once you filter data in a range of cells or table, you can either reapply a filter to get up-to-date results, or clear a filter to redisplay all of the data.

Tips: While signing in, select Yes at the "Stay signed in?" prompt if you want to go straight to your mailbox next time (not recommended for shared computers). Alternatively, check the "Don't show this again" box and select No to be prompted for your password each time.. If you can't sign in, or have forgotten your username or password, use our sign-in troubleshooter.

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.