![what if analysis excel 2010 what if analysis excel 2010](https://www.addictivetips.com/app/uploads/2010/03/Emailinsert1.jpg)
![what if analysis excel 2010 what if analysis excel 2010](https://www.excel-easy.com/data-analysis/images/what-if-analysis/add-scenario.png)
Excel 2010 remembers the workbooks you trust so that you can avoid being prompted each time you open the workbook. Now, after you confirm that active content in a workbook is safe to enable, you don't have to repeat yourself. Trusted documents The trusted documents feature is designed to make it easier to open workbooks and other documents that contain active content, such as data connections or macros. You can also set specific file types to open in Protected View regardless of where they originate. You can control which originating sources trigger Protected View. When this happens, you see a warning on the Message bar, along with the option to enable editing. By default, documents that originate from an Internet source are opened in Protected View. Protected view Excel 2010 includes a Protected View, so you can make more informed decisions before exposing your computer to possible vulnerabilities. Read more about recovering your Office files. This is helpful when you forget to manually save, when you save changes that you didn't mean to save, or when you just want to revert to an earlier version of your workbook. Recover previous versions You can now recover versions of files that you closed without saving. Microsoft Office Backstage viewĬlick the File tab to open Backstage view, where you create new files, open existing files, save, send, protect, preview, and print files, set options for Excel, and more.Įxcel 2010 comes with tools that can help you manage, protect, and share your content. In Excel 2010, however, you can create custom tabs and groups and rename or change the order of the built-in tabs and groups. Although you could customize the Quick Access Toolbar in Excel 2007, it wasn't possible to add your own tabs or groups to the ribbon. Improved ribbonįirst introduced in Excel 2007, the ribbon makes it easy for you to find commands and features that were previously buried in complex menus and toolbars. Like the other Microsoft Office 2010 programs, Excel 2010 includes the Microsoft Office Fluent interface, which consists of a customizable visual system of tools and commands. New and improved features can help you be more productive, but only if you can find them when you need them. Support for high-performance computing Access the right tools, at the right time Obtain powerful analysis from your desktop Make fast, effective comparisons from lists of data In this articleĪccess the right tools, at the right time This article describes the new and improved features in Microsoft Excel 2010.