Reid | search
Click here to view Reid news from 60+ newspapers.
Bookmark or Share- Apply or remove cell borders on a worksheet - Microsoft SupportApply or remove cell borders on a worksheet. By using predefined border styles, you can quickly add a border around cells or ranges of cells. If predefined cell borders do not meet your needs, you can create a custom border. Note: Cell borders that you apply appear on printed pages.
- Break a link to an external reference in Excel - Microsoft SupportWhen you break a link to the source workbook of an external reference, all formulas that use the value in the source workbook are converted to their current values. Because this action cannot be undone, you may want to save a version of the destination workbook as a backup.
- Use conditional formatting to highlight information in ExcelConditional formatting can help make patterns and trends in your data more apparent. To use it, you create rules that determine the format of cells based on their values, such as the following monthly temperature data with cell colors tied to cell values.
- Remove a drop-down list - Microsoft SupportTo remove a drop-down list, click the cell with the list, then click Data > Data Validation, and then on the Settings tab, click Clear All, then OK. A drop-down list is also known as a drop-down box or drop-down menu.
- Active content types in your files - Microsoft SupportThis article lists types of active content that can be blocked by the settings in Trust Center and which, when present, will cause the display of a message bar upon opening the document. When active content is blocked, a Security Warning appears.
More
