Mike Harris | search
Click here to view Mike Harris news from 60+ newspapers.
Bookmark or Share- Trusted documents - Microsoft SupportTrusted documents are files that have been marked as trusted by enabling active content in them. Active content (macros, ActiveX controls, data connections, and so on) opens without the Message Bar warning after you mark the file as trusted.
- Detect errors in formulas - Microsoft SupportFormulas can sometimes result in error values in addition to returning unintended results. The following are some tools that you can use to find and investigate the causes of these errors and determine solutions. Note: This topic contains techniques that can help you correct formula errors.
- Import data from data sources (Power Query) - Microsoft SupportYou can import data into Excel from a wide variety of data sources and the sections that follow show you how. For more information on what to do with your data once it's imported, see How data journeys through Excel.
- Filter for unique values or remove duplicate values - Microsoft SupportFiltering for unique values and removing duplicate values are two similar tasks, since the objective is to present a list of unique values. There is a critical difference, however: When you filter for unique values, the duplicate values are only hidden temporarily.
- Remove or turn off hyperlinks - Microsoft SupportYou can remove a hyperlink from a single address, remove many links at once, turn automatic hyperlinks off, and turn off the requirement to press Ctrl to follow a hyperlink. To remove a hyperlink but keep the text, right-click the hyperlink and click Remove Hyperlink. To remove the hyperlink completely, select it and then press Delete. In Excel:
More
