EXCEL: Recovering Unsaved Workbooks (2010)

Leave a comment

What if you forget to save a workbook, or accidentally saved it when you should have saved it as a different name, or maybe you lose work because of that rare power outage? There’s no need to panic when you think you’ve lost your work in Excel 2010. You can quickly and easily recover older (unsaved) versions of your workbook.

Excel 2010 saves your unsaved versions of files in a specific folder on your hard drive.

Remember that these are new, unsaved files or temporary files, such as those you might open from an email or file transfer. Here’s how you can recover one of these unsaved files.

To recover an unsaved version of a file:

  1. Open Excel 2010 and click on the File tab.
  2. Click Recent on the left, and then click the Recover Unsaved Workbooks button.
  3. In the Open dialog box, you’ll see the contents of your UnsavedFiles folder. For Windows Vista/7, this location is: C:\Users\User_Name\AppData\Local \Microsoft\Office\UnsavedFiles. For Windows XP, the location is: C:\Documents and Settings\User_Name \LocalSettings\Application Data\Microsoft\Office\UnsavedFiles.

Note that the files saved in your UnsavedFiles folder will no longer be available after four days from the file’s creation or modification.

EXCEL: 11 very useful excel keyboard shortcuts

Leave a comment

11 very useful excel keyboard shortcuts

EXCEL: Double Click Tricks

Leave a comment

  1. Double Click on the XL logo on the very top left corner to Close Excel.
  2. Adjust column widths by selecting multiple columns and double clicking on the separators (the thin line between the column letters).  This method also works for the rows.
  3. Auto-fill a series of cells with data or formulas using the double-click. Lets say you have a table where in one column you have some data and in the next you have written a formula in the first row. Simply, select the one cell then double click on the autofill box which can be found at the bottom right corner of the cell.  The mouse converts to a skinny black cross. The trick works for formulas, auto-fills (of numbers, dates, what not) as long as the adjacent column has data.
  4. Jump to last row/column in table with double-click. Just select any cell in the table and double click on the cell-border in the direction you want to go.
  5. Lock a particular feature and reuse them with double-click. You can lock any repeatable feature (like format painter, drawing connectors, shapes etc.) by just double clicking on the icon (in Excel 2007 this works for format painter, but for drawing shapes you need to right click and select lock drawing mode). This can save you a ton of time when you need to repeat same action several times.

EXCEL: Insert Multiple Columns at Once

3 Comments

Suppose you have three columns (Column B, Column C, and Column D) that contains information, then you want to insert blank columns in between these columns here is how to do it:

  • Hold down control key.
  • Select one column at a time
  • Right click and choose Insert
  • Done!

Suppose now you want to insert three blank columns to the left of columns Column B,  here is how to do it:

  • Select column B, C and D at a time
  • Right click and choose Insert
  • Done!

Announcing my new app: Ease-eKeys

2 Comments

I am proud to announce my apps for the iPhone and iPod. It called Ease-eKeys. Everyone always asks what is that shortcut command in Word that does…well, my apps does just that. For 99 cents you will get all the shortcuts and keyboard commands for Word Excel PowerPoint and OneNote. The iPad apps will come down the road. Send me your comments. Thank you!

Ease-eKeys photo 1 Ease-eKeys photo 2 Ease-eKeys photo 3 Ease-eKeys photo 4

EXCEL: Recovering Unsaved Workbooks in 2010

Leave a comment

The most important rule is Properly SAVE your Work!  However there are times when:

  • you forget to save a workbook
  • you accidentally save it when you should have saved it as a different name
  • lose work due to  power outage

So DON”T PANIC, you can quickly and easily recover older (unsaved) versions of your workbook.

Excel 2010 saves your unsaved versions of files in a specific folder on your hard drive. Please take note that these are new, unsaved files or temporary files, similar to files that you open from an email or file transfer. Here are the steps to recover the unsaved file:
To recover an unsaved version of a file:

  1. Open Excel 2010 and click on the File tab.
  2. Click Recent on the left, and then click the Recover Unsaved Workbooks button.
  3. In the Open dialog box, you’ll see the contents of your UnsavedFiles folder. For Windows Vista/7, this location is: C:\Users\User_Name\AppData\Local \Microsoft\Office\UnsavedFiles. For Windows XP, the location is: C:\Documents and Settings\User_Name\Local Settings\Application Data\Microsoft\Office\UnsavedFiles.

Note that the files saved in your Unsaved Files folder will no longer be available after four days from the file’s creation or modification.

EXCEL:How Large is the Excel Worksheet?

1 Comment

By pressing Ctrl+End, the active cell will automatically jump to the last cell that has input in the worksheet of an Excel workbook. Therefore, there is no data beyond this row or no data beyond this column anywhere in the worksheet. And the opposite of Ctrl+End is Ctrl+Home.

Older Entries

Follow

Get every new post delivered to your Inbox.

Join 477 other followers