Excel 2010: Recover Unsaved Documents

By Jill Duffy, Edward Mendelson

Word, Excel, and PowerPoint all have a new feature that saves documents that you've neglected to save when you closed them—including documents that you haven't even bothered to save with a name more specific than "Document1." This feature builds on Office's long-standing autosave feature, which automatically backs up the current version of your document every ten minutes (or whatever interval you set in the app's options). Earlier versions of Office deleted the last of these automated backups when you closed a document, but Office 2010 preserves the last automated backup and lets you open it. Click File, Recent, Recover Unsaved Documents, and then choose the document from a standard File/Open dialog box.

—Next Tip: Display Formulas Instead of Results >

http://www.pcmag.com/article2/0,2817,2386994,00.asp

Open Multiple Worksheets with One Double-Click

 

Speaking of multiple windows, sometimes you work on two or more separate worksheets at the same time, each in a separate window, and you know you'll want to work on the same set of worksheets again tomorrow. So, before you shut down Excel, go to the View menu and click Save Workspace near the right side of the Ribbon. In the Save Workspace dialog, enter a name and location for your saved view settings, and a Saved Workspace icon gets created in the location you choose, perhaps your desktop. When you want to open the same set of worksheets, simply double-click the Saved Workspace icon

By Jill Duffy, Edward Mendelson

 

http://www.pcmag.com/article2/0,2817,2386992,00.asp

see also:  http://www.empiezoinformatica.wordpress.com