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.

You can create a simple formula to add, subtract, multiply or divide values in your worksheet. Simple formulas always start with an equal sign (=), followed by constants that are numeric values and calculation operators such as plus (+), minus (-), asterisk (*), or forward slash (/) signs.The following is an example of a simple formula.

Note: If you use a Manual Table of Contents style, Word won't use your headings to create a table of contents and won't be able to update it automatically. Instead, Word will use placeholder text to create the look of a table of contents so you can manually type each entry into the table of contents.

For fast and simple editing, we've added Clipchamp as the official Microsoft video editor. Microsoft Clipchamp comes preinstalled on Windows 11 devices. To open Clipchamp, go to the search box on the taskbar, type Clipchamp, and select it from the results.Or you can select Start , then select All apps and scroll down to find Clipchamp in the list of apps.

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.

In the search box on the taskbar, type Create a restore point, and select it from the list of results.

Try it! Discover your Outlook inbox for the first time and see how everything's organized. Overview of Outlook layout. Folders are available in the Folder Pane.

This article is for Outlook Web App, which is used by organizations that manage email servers running Exchange Server 2013 or 2010. If you're using Microsoft 365, or Exchange Server 2016 or 2019, your email program is Outlook on the web.

Compress the file. When you compress, or zip, your file, it decreases its size, and it might decrease it enough to fit within the Outlook size limits for attachments.The following articles describe how to compress and extract files for different Windows operating systems.

Important: Exchange Online on Microsoft 365 provides some search features via Microsoft Search.This includes suggested recipients when composing a new email. Starting with Outlook for Microsoft 365 Version 2202 (Build 14931.20604), if you are connected to an Exchange Online mailbox, the compose suggestions for To/CC/BCC are powered by Microsoft Search and some information in this article doesn ...