You can use the Advanced Filter dialog box to extract the unique values from a column of data and paste them to a new location. Then you can use the ROWS function to count the number of items in the new range.. Select the range of cells, or make sure the active cell is in a table. Make sure the range of cells has a column heading.

If your SharePoint lists or libraries are set to track versions, you can restore a previous version of a list item or file. To learn how you can delete a version, all versions, or just minor versions of an item or file if your list or library is configured for it, see Delete a previous version on an item or file in SharePoint.. For info about turning versioning on, see Turn on version history ...

The People app is your address book. You can add your contacts and keep in touch with friends and family. The People, Mail, and Calendar apps work together so you can easily send mail to and schedule appointments with your most important people.

How to find and remove duplicates in Excel. Filter for unique values in large or small datasets to clean up your worksheets and workbooks.

Free screen recorder with Microsoft 365 work or school account. Record your screen or create a new video in Microsoft Stream (on SharePoint), including webcam, background removal, inking, stickers, music, and text. Instantly share your video for others to view and get analytics.

On a Mac, you'll need to install the latest Teams audio driver in order to include computer audio in a Teams meeting and avoid sound issues like echoing.

If you select multiple files or folders and then select Download from Microsoft OneDrive, SharePoint in Microsoft 365, or from SharePoint Server Subscription Edition, your browser will start downloading a .zip file containing all the files and folders you selected. If you're in a folder and you select Download without selecting any files or folders, your browser will begin downloading all ...

如果无法登录到Microsoft帐户，大多数问题都可以通过登录帮助程序工具进行识别。 该工具将要求你输入尝试登录时使用的电子邮件地址或移动电话号码，并检查你提供的详细信息。

Turn the feature on or off while presenting. If you're in the middle of giving a presentation and want to turn the feature on or off, click the Toggle Subtitles button from Slide Show View or Presenter View, on the toolbar below the main slide:. In Slide Show View:. In Presenter View:. You can also toggle subtitles from the right-click menu, or with the shortcut key J.

Differences are highlighted with a cell fill color or text font color, depending on the type of difference. For example, cells with "entered values" (non-formula cells) are formatted with a green fill color in the side-by-side grid, and with a green font in the pane results list.