Search results
Results from the WOW.Com Content Network
Global permissions To change permissions for all your workbooks. If there are many data sources, enter a search phrase in the Search data source settings box or select the Sort button on the right to sort by the name or kind of data source.
If you see a security warning when you open a document or try to run a macro, you can choose to make it a trusted document and enable macros. This example is on an Excel workbook. Select Enable Content. In the Security Warning dialog, select Yes to make the document trusted. Macros are now enabled on this document.
Select the file or files that you want to check out. , and then select Check out. When the file is checked out, a small icon appears to the right of the file name. This tells you, or anyone else, that the file is checked out. If you point your mouse at the file name, you can see details about the file, including the name of the person who has ...
The sensitivity bar makes it easy for you to see what label is applied to your file, and to apply or change a label whenever you need to, including when saving the file. Just select the sensitivity bar in the save dialog to see the labeling options for this file.
Select File > Get Add-ins. Alternatively, you can also view your add-ins directly from the Home tab by selecting Add-ins. You can directly install add-ins from this page or select More Add-ins to explore. In the Office Add-ins dialog, select My Add-ins tab.
A trusted location in Microsoft Office is a folder that contains files you trust to be safe. You should use a trusted location to store a file when you don't want that file to be checked by the Trust Center, or if you don't want it to open in Protected View.
You can move between cells in a circular reference by double-clicking the tracer arrow. The arrow indicates the cell that affects the value of the currently selected cell. You show the tracer arrow by selecting Formulas, and then select either Trace Precedents or Trace Dependents.
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.
This feature works for links to Word, Excel, or PowerPoint files, stored on OneDrive or SharePoint, that you click in Word, Excel, Outlook, or PowerPoint for Microsoft 365 on Windows or Mac. Once a user turns this feature on, it will apply to all three apps - Word, PowerPoint, and Excel.
Apply data validation to cells. Use data validation to restrict the type of data or the values that users enter into a cell, like a dropdown list. Select the cell (s) you want to create a rule for. Select Data >Data Validation. Whole Number - to restrict the cell to accept only whole numbers. Decimal - to restrict the cell to accept only ...
The next time you open the workbook, the code you added to the Workbook_Open procedure will run automatically. Need more help? You can always ask an expert in the Excel Tech Community or get support in Communities. Use Auto_Open to create a macro that runs every time you open a specific workbook.