Learn how to download a recovery image for your Surface device and restore it to factory settings.

When you open a destination workbook, and the source workbook is not open, you may be alerted by the Trust Bar to update the links. You can control whether the Trust Bar alerts you, and whether to update all links when the alert does not appear.

Total row Once you add a total row to a table, Excel gives you an AutoSum drop-down list to select from functions such as SUM, AVERAGE, and so on.When you select one of these options, the table will automatically convert them to a SUBTOTAL function, which will ignore rows that have been hidden with a filter by default.

Need the full set of Excel features? Open your file in the Excel desktop app one of two ways, depending on what you see in your workbook: Select Open in Desktop App at the top of your workbook.If you don't see it, there should be a search bar along the top of your workbook.

Insert rows. To insert a single row: Right-click the whole row above which you want to insert the new row, and then select Insert Rows. To insert multiple rows: Select the same number of rows above which you want to add new ones.Right-click the selection, and then select Insert Rows.. Insert columns. To insert a single column: Right-click the whole column to the right of where you want to add ...

在 “个性化设置背景”旁边的列表中，选择“图片”、“ 纯色”、“ 幻灯片放映”或“ Windows 聚焦 (”，) 查看来自世界各地的新图像。

The COUNTIFS function is similar to the COUNTIF function with one important exception: COUNTIFS lets you apply criteria to cells across multiple ranges and counts the number of times all criteria are met. You can use up to 127 range/criteria pairs with COUNTIFS. The syntax for COUNTIFS is: COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2],…)

Devices running Windows 11 version 22H2 and older. If you're running Windows 11 version 22H2 and older, Windows 10, Windows 8.1, Windows 7 or any other earlier OS version, your device will not be affected by the MSDT Troubleshooter retirement.

Install the S/MIME control. Get a certificate, sometimes referred to as a key or digital ID. The first step to use S/MIME is to obtain a certificate from your IT administrator or helpdesk.

Important: If you originally installed the Excel add-in from a network file server or from a shared folder, you might need to remove the add-in from that location.If you installed the Excel add-in from a CD and you mapped your CD drive to a new drive letter after installing the add-in, you need to reinstall the add-in from the CD.