If you encrypt an Outlook message that contains voting buttons, message recipients won't be able to see them. That feature isn't supported at this time. Create an email message or reply to or forward a message that you received. On the Options tab, in the Tracking group, click Use Voting Buttons.

Conditional formatting can help make patterns and trends in your data more apparent. To use it, you create rules that determine the format of cells based on their values, such as the following monthly temperature data with cell colors tied to cell values.

If you’re new to Excel, or even if you have some experience with it, you can walk through Excel’s most common formulas in this tour. With real-world examples and helpful visuals, you’ll be able to Sum, Count, Average, and Vlookup like a pro.

See plans and pricing. Find help and support content for Microsoft Phone Link. Learn time-saving tips and explore how you can use Phone Link to stay productive.

Macros are sequences of events (such as keystrokes, mouse clicks, and delays) that can be played back to help with repetitive tasks. They can also be used to replay sequences that are long or difficult to run. You can assign a macro recorded in Microsoft Mouse and Keyboard Center to a key or a mouse button.

The HDR display or TV must support HDR10, DisplayPort 1.4, HDMI 2.0 or higher, USB-C, or Thunderbolt. To find the specifications for a specific PC or external display, visit the device manufacturer’s website.

The SUM function adds values. You can add individual values, cell references or ranges or a mix of all three. For example: =SUM (A2:A10) Adds the values in cells A2:10. =SUM (A2:A10, C2:C10) Adds the values in cells A2:10, as well as cells C2:C10.

How to use the SUMPRODUCT function in Excel, one of Excel’s math and trig functions, using multiplication, addition, subtraction, and/or division to return the sum of the products of corresponding ranges or arrays.

使用 SUMPRODUCT 对一个或多个数组中的对应值的乘积求和. Excel 2013. SUMPRODUCT 使用单元格区域 ( 或创建数组 公式) 作为参数 (公式的各个部分，使其) 。. 它将数组中的项相乘，然后对结果进行汇总。. 此示例是一个购物清单，其中一个数组列出每个商品的成本，另 ...

使用 SUM 函数对区域中的数字求和. Microsoft 365 专属 Excel Excel 网页版 更多... 可以使用 简单的公式对) 一组单元格 (区域中的数字求和，但在处理多个数字时 ，SUM 函数 更易于使用。. 例如，=SUM (A2：A6) 出现键入错误的可能性小于 =A2+A3+A4+A5+A6。. 下面是使用两个单元 ...