Enable or disable macros in Microsoft 365 files
Disable all macros except digitally signed macros Macros are disabled, and security alerts appear if there are unsigned macros present.However, if the macro is digitally signed by a trusted publisher, the macro just runs. If the macro is signed by a publisher you haven't trusted yet, you are given the opportunity to enable the signed macro and trust the publisher.
Applies To: Excel for Microsoft 365, Word for Microsoft 365, Outlook for Microsoft 365, PowerPoint for Microsoft 365, Access for Microsoft 365, Excel 2021, Word 2021, Outlook 2021, PowerPoint 2021, Access 2021, Visio Professional 2021, Visio Standard 2021, Excel 2019, Word 2019, Outlook 2019, PowerPoint 2019, Access 2019, Visio Professional 2019, Visio Standard 2019, Excel 2016, Word 2016, Outlook 2016, PowerPoint 2016, Access 2016, Visio Professional 2016, Visio Standard 2016
Create and add an email signature in Outlook.com or Outlook on the web
Automatically add a signature to a message. You can create an email signature that you can add automatically to all outgoing messages or add manually to specific ones.
Applies To: Outlook on the web, Outlook.com, Outlook on the web for Exchange Server 2016, Outlook on the web for Exchange Server 2019
XLOOKUP function - Microsoft Support
Use the XLOOKUP function when you need to find things in a table or a range by row. For example, look up the price of an automotive part by the part number, or find an employee name based on their employee ID. With XLOOKUP, you can look in one column for a search term, and return a result from the same row in another column, regardless of which side the return column is on.
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2016, Excel for iPad, Excel for iPhone, Excel for Android tablets, Excel for Android phones
Overview of PivotTables and PivotCharts - Microsoft Support
You can use data from a Excel worksheet as the basis for a PivotTable or PivotChart. The data should be in list format, with column labels in the first row, which Excel will use for Field Names.Each cell in subsequent rows should contain data appropriate to its column heading, and you shouldn't mix data types in the same column.
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2019, Excel 2016
KB5028997: Instructions to manually resize your partition to install ...
Windows 10 Windows 10, version 1607, all editions Windows Server 2016, all editions Win 10 Ent LTSC 2019 Win 10 IoT Ent LTSC 2019 Windows 10 IoT Core LTSC Windows Server 2019 Windows 10 Enterprise and Education, version 21H2 Windows 10 IoT Enterprise, version 21H2 Windows 10 Enterprise Multi-Session, version 21H2 Windows 10, version 22H2, all editions Windows 11 version 21H2, all editions ...
Sign-in options in Windows - Microsoft Support
Dynamic lock is a security feature that automatically locks your device when you are not around. It uses Bluetooth to pair with a phone, and locks the device when the Bluetooth signal drops below a certain level, indicating that you are no longer near your device.
Get started with Copilot in Microsoft Teams meetings
From the meeting chat, select Open Copilot in the upper-right corner of the chat—you'll see the Copilot icon.From here, Copilot bases responses on the meeting transcript, not the meeting chat. You'll see the same conversation history with Copilot as the one accessed from Recap.Select View prompts to choose from the suggestions, or try the following prompts:
Applies To: Microsoft Teams
Zip and unzip files - Microsoft Support
Zipped (compressed) files take up less storage space and can be transferred to other computers more quickly than uncompressed files. In Windows, you work with zipped files and folders in the same way that you work with uncompressed files and folders.
Use Smart charging in Windows - Microsoft Support
Lithium-ion batteries wear out over time, which can result in a battery not holding a charge for as long as it did when it was new. Keeping the battery charged to 100% all the time can cause it to deteriorate faster.
Microsoft 365 Training
Get productive quickly with Microsoft 365 videos and tutorials. Explore Microsoft 365 training guides and tips to collaborate with anyone, anywhere.