Stop | search
Click here to view Stop news from 60+ newspapers.
Bookmark or Share- Hide error values and error indicators in cells - Microsoft SupportThere are many reasons why formulas can return errors. For example, division by 0 is not allowed, and if you enter the formula =1/0, Excel returns #DIV/0. Error values include #DIV/0!, #N/A, #NAME?, #NULL!, #NUM!, #REF!, and #VALUE!. Convert an error to zero and use a format to hide the value.
- Change macro security settings in Excel - Microsoft SupportIn Excel, you can change the macro security settings to control which macros run and under what circumstances when you open a workbook. For example, you might allow macros to run based on whether they are digitally signed by a trusted developer.
- Turn off Scroll Lock - Microsoft SupportIf a check is not visible, Scroll Lock does not appear in the Excel status bar. Simply check the box to have the status appear on the status bar. If Scroll Lock is on, your cursor moves between columns and rows, not cells. Here's how to turn off Scroll Lock.
- Restrict changes to files in Excel - Microsoft SupportRestrict changes to files. You can use formatting and editing restrictions to prevent content reviewers from accidentally changing an Excel spreadsheet.
- Undo automatic formatting in Excel - Microsoft SupportTo remove the formatting for just the text you’ve selected, click Undo. For example, if Excel automatically created a hyperlink and you want to remove it, click Undo Hyperlink. To tell Excel to stop applying this particular type of formatting to your workbook, click Stop.
More
