enow.com Web Search

Search results

  1. Results from the WOW.Com Content Network
  2. Manage data source settings and permissions (Power Query) - ...

    support.microsoft.com/en-us/office/manage-data-source-settings-and-permissions...

    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.

  3. Enable or disable macros in Microsoft 365 files

    support.microsoft.com/en-us/office/enable-or-disable-macros-in-microsoft-365...

    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.

  4. Check out, check in, or discard changes to files in a SharePoint...

    support.microsoft.com/en-us/office/check-out-check-in-or-discard-changes-to...

    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 ...

  5. Apply sensitivity labels to your files and email - Microsoft...

    support.microsoft.com/en-us/office/apply-sensitivity-labels-to-your-files-and...

    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.

  6. View, manage, and install add-ins for Excel, PowerPoint, and Word...

    support.microsoft.com/en-us/office/view-manage-and-install-add-ins-for-excel...

    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.

  7. Add, remove, or change a trusted location in Microsoft Office

    support.microsoft.com/en-us/office/add-remove-or-change-a-trusted-location-in...

    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.

  8. Remove or allow a circular reference in Excel - Microsoft Support

    support.microsoft.com/en-us/office/remove-or-allow-a-circular-reference-in...

    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.

  9. Change macro security settings in Excel - Microsoft Support

    support.microsoft.com/en-us/office/change-macro-security-settings-in-excel-a97...

    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.

  10. Open file links directly in Office desktop apps - Microsoft...

    support.microsoft.com/en-us/office/open-file-links-directly-in-office-desktop...

    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.

  11. Apply data validation to cells - Microsoft Support

    support.microsoft.com/en-us/office/apply-data-validation-to-cells-29fecbcc-d1b...

    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 ...

  12. Automatically run a macro when opening a workbook

    support.microsoft.com/en-us/office/automatically-run-a-macro-when-opening-a...

    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.