Important: Workbook links are considered potentially unsafe and must be enabled when you open a formula workbook.When you open a formula workbook, click Enable Content in the Message Bar to allow the workbook links to function. If you don't, Excel keeps the most recent values and disables refreshing the links with values from the data workbook.

You can use data from a Excel worksheet as the basis for a PivotTable or PivotChart. The data should be in list format, with column labels in the first row, which Excel will use for Field Names.Each cell in subsequent rows should contain data appropriate to its column heading, and you shouldn't mix data types in the same column.

键盘快捷方式是键或键组合，提供了一种替代通常使用鼠标完成的任务的替代方法。 如果要拍摄屏幕截图或截屏，请参阅 如何获取屏幕截图并向其添加注释。. 本文包括分类为的键盘快捷方式列表：

Cross-device copy and paste (for Surface Duo and select Samsung and HONOR and OPPO and ASUS devices) Let emailing yourself photos and files be a thing of the past — now you can just copy and paste or drag and drop content between your Android device and your PC.

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.

Problem. Description. 0 (Zero) is shown instead of the expected result. Make sure Criteria1,2 are in quotation marks if you are testing for text values, like a person's name.. The result is incorrect when Sum_range has TRUE or FALSE values.. TRUE and FALSE values for Sum_range are evaluated differently, which may cause unexpected results when they're added. ...

Training: Watch and learn how to create a PowerPoint presentation, add/format text, and add pictures, shapes, and/or charts.

What you can customize: You can personalize your ribbon to arrange tabs and commands in the order you want them, hide or unhide your ribbon, and hide those commands you use less often.Also, you can export or import a customized ribbon. What you can't customize: You can't reduce the size of your ribbon, or the size of the text or the icons on the ribbon.

Download Microsoft Edge from the Apple App Store and sign in with your Microsoft account.

In the search box on the taskbar, type Manage BitLocker and then select it from the list of results. Or, select the Start button, and then under Windows System, select Control Panel.In Control Panel, select System and Security, and then under BitLocker Drive Encryption, select Manage BitLocker. Note: You'll only see this option if BitLocker is available for your device.