Enable or disable macros in Microsoft 365 files
Block suspicious macros in Office on Windows 10 S. How malware can infect your PC. Improve security, evaluate and mitigate the risks of running macros, and see how to enable or disable macros for Microsoft 365.
Change macro security settings in Excel - Microsoft Support
In 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.
Undo, redo, or repeat an action - Microsoft Support
You can undo changes, even after you have saved, and then save again, as long as you are within the undo limits (By default Office saves the last 100 undoable actions). Windows macOS Web. Undo an action. To undo an action press Ctrl+Z on your keyboard, or select Undo on the Quick Access Toolbar.
Display or hide formulas - Microsoft Support
You can control the display of formulas in the following ways: Switch between displaying formulas and their results from the ribbon. Switch between displaying formulas and their results from the keyboard. Prevent a formula from displaying in the formula bar. Show formulas that were previously hidden by removing protection.
How to correct a #VALUE! error - Microsoft Support
The #VALUE! error is also shown when a formula references one or more cells that have text instead of numbers, and uses the standard math operators (+, -, *, and /) to add, subtract, multiply, or divide the different data types.
Create custom functions in Excel - Microsoft Support
Excel includes several built-in functions—RAND and NOW, for example—that don’t use arguments. Following the Function statement, a function procedure includes one or more VBA statements that make decisions and perform calculations using the arguments passed to …
Load the Solver Add-in in Excel - Microsoft Support
The Solver Add-in is a Microsoft Office Excel add-in program that is available when you install Microsoft Office or Excel. To use the Solver Add-in, however, you first need to load it in Excel. Windows macOS Android iOS Windows Mobile. Go to File > Options.
Use AND and OR to test a combination of conditions
This formula nests the AND function inside the OR function to search for units sold between April 1, 2011 and January 1, 2012, or any units sold by Nancy. You can see it returns True for units sold by Nancy, and also for units sold by Tim and Ed during the dates specified in the formula.
Using IF with AND, OR, and NOT functions in Excel
In Excel, the IF function allows you to make a logical comparison between a value and what you expect by testing for a condition and returning a result if that condition is True or False. =IF (Something is True, then do something, otherwise do something else)
View or change the properties for an Office file - Microsoft Support
Document properties, also known as metadata, are details about a file that describe or identify it. They include details such as title, author name, subject, and keywords that identify the document's topic or contents. If you include the document properties for your files, you can easily organize and identify them later.
Use the SUM function to sum numbers in a range
You can use a simple formula to sum numbers in a range (a group of cells), but the SUM function is easier to use when you’re working with more than a few numbers. For example =SUM (A2:A6) is less likely to have typing errors than =A2+A3+A4+A5+A6.