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.

Lithium-ion batteries wear out over time, which can result in a battery not holding a charge for as long as it did when it was new. Keeping the battery charged to 100% all the time can cause it to deteriorate faster.

Optional: To customize the ScreenTip that appears when you rest the pointer over the hyperlink, click ScreenTip in the top-right corner of the Insert Hyperlink dialog box and enter the text you want. You can also create a hyperlink to a blank email message by simply typing the address in the document. For example, type someone@example.com, and Microsoft 365 creates the hyperlink for you ...

Microsoft account help and support. Get help with signing in, locked or compromised accounts, linked accounts, closing, reopening, and updating your security info and account profile.

Argument name. Description. range (required). The group of cells you want to count. Range can contain numbers, arrays, a named range, or references that contain numbers. Blank and text values are ignored. Learn how to select ranges in a worksheet.. criteria (required). A number, expression, cell reference, or text string that determines which cells will be counted.

The issues you encounter when trying to install Microsoft 365, or Office 2021, 2019, or 2016 and how you fix them depends on whether your product is part of an Office for home or Office for business plan.. In addition, with Office for business plans only admins responsible for managing Microsoft 365 in their organization can do certain tasks. Therefore, admins should view the issues and ...

When prompted, enter the product key. You can find the product key on the sticker on the CD case or other packaging. If you need help, see Find your Product Key for Office 2007.

As your everyday AI companion, Microsoft Copilot assists you with everything from starting with a blank page to finding the perfect words. It simplifies tasks, boosting your productivity and ensuring you focus on what matters most.

Immersive Reader advanced color support. In Immersive Reader, we've added many additional ways you can choose a page color.Selecting a page color can make text easy to scan with less eye strain. On the Immersive Reader tab click Page Color to see a 4x5 color picker.. Click More Colors to see additional color selection options such as Wheel, Sliders, Color Palettes, Image Palettes, and Pencils.

Cloud files can exist locally on the disk or be available online only. To choose the conditions for when inactive files are made online only, under Content will become online-only if not opened for more than: choose your preferred amount of time. Note that starting in Windows 11, version 22H2, the default for OneDrive cloud files is to make files online-only if not opened for more than 30 days.