View previous versions of Office files - Microsoft Support
WEBMicrosoft 365 Office 2016 - 2021 macOS Web. Learn how Version History helps you see what changes have been made in a file, compare different versions, or restore the version you want: Open the file you want to view. Click the …
Access your Account Privacy Settings - Microsoft Support
WEBIf you're using Office with a work or school account, your administrator may have configured what settings you can change. On Windows these settings apply to Word, Excel, PowerPoint, Outlook, OneNote, Access, Project, and Visio.
Activate Office - Microsoft Support
WEBActivate a brand new Office product key. Troubleshoot activation errors. Activate Microsoft 365 or a non-subscription version of Office. When you start an Microsoft 365 app that's not activated, you'll be prompted to sign in to Microsoft 365.
Connected experiences in Microsoft 365 - Microsoft Support
WEBThese are experiences that allow you to search and download online content including templates, images, 3D models, Microsoft 365 help, videos, and reference materials to enhance your documents. Excel's rich data types or Outlook's weather info are examples of these kinds of experiences.
Apply sensitivity labels to your files and email - Microsoft Support
WEBThe 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.
About Power Query in Excel - Microsoft Support
WEBWith Power Query (known as Get & Transform in Excel), you can import or connect to external data, and then shape that data, for example remove a column, change a data type, or merge tables, in ways that meet your needs. Then, you can load your query into Excel to create charts and reports.
Insert data from picture - Microsoft Support
WEBLearn how to insert data from a picture with Excel - and you can use your smartphone or tablet to take the picture. Excel's powerful AI capabilities can convert your hand written or printed data into a table.
Refresh an external data connection in Excel - Microsoft Support
WEBYou can refresh the data for PivotTables connected to external data, such as a database (SQL Server, Oracle, Access, or other), Analysis Services cube, data feed, as well as data from a source table in the same or a different workbook. PivotTables can be refreshed manually or automatically when you open the workbook.
Convert dates stored as text to dates - Microsoft Support
WEBBecause Error Checking in Excel can identify text-formatted dates with two-digit years, you can use the automatic correction options to convert them to date-formatted dates. You can use the DATEVALUE function to convert most other types of text dates to dates.
Show or hide subtotals and totals in a PivotTable
WEBWhen you create a PivotTable that shows value amounts, subtotals and grand totals appear automatically, but you can also show or hide them. Show or hide subtotals. Click anywhere in the PivotTable to show the PivotTable Tools. Click Design > Subtotals. Pick the option you want: Do Not Show Subtotals. Show all Subtotals at Bottom of Group.
Microsoft 365 Quick Starts - Microsoft Support
WEBTraining: Get started quickly on all of your favorite Microsoft 365 apps with our popular Quick Start guides.