Use the Office offline installer to install Office 2016 or Office 2013 if you don't have an active Internet connection or you're having problems with slow speed or unreliable connections.

An array formula (one that spans multiple cells) can do calculations on rows and columns of cells where you might otherwise need to use several formulas. For example, you can count the number of characters that are contained in a range of cells, sum only numbers that meet certain conditions (such as the lowest values in a range or numbers that fall between an upper and lower boundary), and sum ...

Learn how to sign into your PC with Windows Hello using a PIN, facial recognition, or fingerprint.

如果您要刪除欄 b、c 或 d，則會造成 #ref! 錯誤。 在此案例中，我們會刪除欄 c (2007 銷售額)，而公式現在會變成 =sum(b2,#ref!,c2)。 當您使用像這樣的明確儲存格參照 (您在其中個別參照每個儲存格並以逗號分隔) 且刪除參照的列或欄時，excel 無法解析，所以就會傳 ...

This article is for Outlook.com. If you're using Outlook for Windows, see Fixes or workarounds for recent issues in Outlook for Windows.. If you're having problems accessing Outlook.com, you can see the status of Microsoft Office Online Services at the Service Health portal.. If you're having problems sending or receiving email, read how to Fix Outlook.com email sync issues.

Note: Calculated fields can only operate on their own row, so you can't reference a value in another row, or columns contained in another list or library.Lookup fields are not supported in a formula, and the ID of newly inserted row can't be used as the ID doesn't exist when the formula is processed.

Note: The Phone Link doesn't currently support multiple Android profiles or work/school accounts. How to link your devices starting from Phone Link Make sure to have both your PC and Android device nearby, turned on, and connected to the same Wi-Fi network.

Structured references make it easier to use formulas with Excel tables by replacing cell references, such as C2:C7, with predefined names for the items in a table.

In Word, you can create a form that others can fill out and save or print. To do this, you will start with baseline content in a document, potentially via a form template.

Many users find that using an external keyboard with keyboard shortcuts for Excel helps them work more efficiently. For users with mobility or vision disabilities, keyboard shortcuts can be easier than using the touchscreen and are an essential alternative to using a mouse.