Tip: If you want to find cells that just match a specific format, you can delete any criteria in the Find what box, and then select a specific cell format as an example. Select the arrow next to Format, select Choose Format From Cell, and then select the cell that has the formatting that you want to search for.

The TEXTJOIN function combines the text from multiple ranges and/or strings, and includes a delimiter you specify between each text value that will be combined. If the delimiter is an empty text string, this function will effectively concatenate the ranges.

Description. The ROUND function rounds a number to a specified number of digits. For example, if cell A1 contains 23.7825, and you want to round that value to two decimal places, you can use the following formula:

Tip: If you encounter a problem on your Windows device, pressing the Windows logo key + F takes a screenshot, then opens the Feedback Hub app and automatically uploads the screenshot to the Feedback tab. Follow the on-screen instructions to detail the problem you've encountered.

Tip: Instead of inviting people to share a notebook, you can create a special link to the notebook that you can then copy and paste into an email, into a text message, or onto a webpage.On the Send Link pane, click Copy Link.Keep in mind, access to this link is controlled by the access set for sharing at the top of the Send Link pane.

When you delete an online-only file from your device, you delete it from your OneDrive on all devices and online. You can restore deleted files and folders from your OneDrive recycle bin on the web for up to 30 days for items stored in OneDrive personal (when you're signed in with a Microsoft account), or for up to 93 days for items stored in OneDrive for work or school or SharePoint in ...

When PowerPoint for the web is unable to automatically scale your content, it prompts you with two options: Maximize: Select this option to increase the size of your slide content when you are scaling to a larger slide size.Choosing this option could result in your content not fitting on the slide.

At any time, you can change the time zone in Outlook so that it matches your current geographic location. Changing the time zone in Outlook is the same as changing it in the Windows Control Panel, and the change is reflected in the time displays in all other Microsoft Windows-based programs.

On the Chart Design tab, click Add Chart Element, point to Up/Down Bars, and then click Up/down Bars.. Depending on the chart type, some options may not be available.

Use the People app to see all your contacts in one place, listed alphabetically. To open the app, select the Start button, and then select People.Enter your account info if you’re asked to sign in.