Note: In earlier versions of Outlook, IMAP accounts also used an Outlook Data File (.pst).In Outlook 2016 and Outlook for Microsoft 365, IMAP accounts use Offline Outlook Data Files (.ost). You can also use an Outlook Data File (.pst) to backup or export items from any type of email account.

Note: The boundary is the line between cells, columns, and rows.If a column is too narrow to display the data, you will see ### in the cell.

Get up to speed with Microsoft Office by using these cheat sheets for quick reference and mastering keyboard shortcuts.

Each widget is powered by a different app or service. To see what is powering a widget, select More Options (…) in the upper-right corner of the widget, and look for the “Powered by” message at the bottom of the menu. Each individual widget is an extension of its corresponding app or service and is controlled by the settings for that app or service.

Hide or display zero values in Excel worksheets by using an option in the Advanced tab, or by using a number format, using a conditional format, a function, and by hiding zeros in PivotTable reports.

Microsoft 365 helps you manage and share your work schedule. New features allow you to specify more details about your work schedule: from where you’re working (remotely or in office) and whether you work different hours on different days. In addition, you’ll be able to schedule meetings with others based on their work location and view work location on people’s contact cards.

Edit pictures with the Photos app in Windows. Windows 11 and Windows 10 have an app named Photos, a successor to Picture Manager, that lets you edit photos.For information on how to open and use it, see Edit photos and videos.. Edit a photo you've inserted in an Office document

Examples. Example 1. This example uses SORT and UNIQUE together to return a unique list of names in ascending order. Example 2. This example has the exactly_once argument set to TRUE, and the function returns only those customers who have had service one time.

It’s always good to stay on top of the content you’ve shared with friends, family, and collaborators. OneDrive makes it easy. Simply log into your account at OneDrive.com, and in the left-side navigation area, you’ll see a view called Shared.. This view lets you quickly see all of your content that’s shared, especially the content that you’ve shared with others.

* Some accessories and software sold separately. [1] Battery life: Surface Book 3 13.5” on base: Up to 15.5 hours of battery life based on typical Surface device usage. Testing conducted by Microsoft in April 2020 using preproduction software and preproduction configurations of Surface Book 3 13.5” Intel® Core™ i5, 256 GB, 8 GB RAM.