Create a PivotTable to analyze external data. Create a PivotTable to analyze data in multiple tables. Sort data in a PivotTable. Group or ungroup data in a PivotTable. In Excel, use slicers and other ways to filter large amounts of PivotTable data to show a smaller portion of that data for in-depth analysis.

Insert a picture. To insert a picture in the body of your email message, place your cursor in the body of the email message, select the Insert menu, and then choose Pictures from the Illustrations group on the Ribbon.. If the picture looks too big (or too small), you can use the sizing handles on the picture to resize the image.

What you need. To download the recovery image, you’ll need a USB drive. Before you download a recovery image, format your USB drive to FAT32.

Photos Legacy is the app for Microsoft’s Legacy Collections, Albums, and Video Editor. Be empowered to do more with your photos and videos. You can view, edit, compare, create albums, and make movies of your special memories easily. You can use the filmstrip to locate and jump to another photo while staying immersed in the experience.

Select the cells you want to lock. On the Home tab, in the Alignment group, select the small arrow to open the Format Cells popup window. On the Protection tab, select the Locked check box, and then select OK to close the popup. Note: If you try these steps on a workbook or worksheet you haven't protected, you'll see the cells are already locked.

If you're using Word, Outlook, or Excel, you can remove all hyperlinks in a file by using a keyboard shortcut. In Word and Outlook: Press Ctrl+A to select all text. Press Ctrl+Shift+F9. In Excel: Select all cells that contain hyperlinks, or press Ctrl+A to select all cells. Right-click, and then click Remove Hyperlinks.

If you need to install or reinstall the OneNote desktop app on Windows (formerly called “OneNote 2016”), do the following: Download OneNote. When finished downloading, double-click the downloaded file to begin Setup. The installer will automatically detect if you’re currently running a 32-bit or 64-bit version of Microsoft 365 or Office ...

Contact Support. For technical support, go to Contact Microsoft Support, enter your problem and select Get Help. If you still need help, select Contact Support to be routed to the best support option. Learn how to keep your Microsoft account safe, including making a strong password, identifying safe emails, and reviewing account activity.

Automate your repetitive tasks with Office Scripts in Excel for the web, Windows, and Mac. Create scripts and replay them whenever you want. Share your scripts across the organization to help others make their workflows fast and consistent. Edit your scripts as your workflow changes and let the cloud update your solutions across the organization.

Press the Xbox button on your controller to open the guide and go to Profile & system > Settings > Devices & connections > Remote features. Check the box to enable remote features. For Power options, select Sleep mode. Note If the console isn’t set to Sleep mode, remote features won’t work.