Click here to increase or decrease font size: A  A  A  A







Home Biography Published Works Blog Message Board Newsletter Guestbook Contact

Archive for the 'Office' Category



Friday, September 16th, 2011
Word 2010 Tip: Keep the last autosaved version if I close without saving.

Most users of Microsoft Word make good use of Word’s autosave functionality and have appreciated the ability to retrieve documents that fell victim to sudden power failures, mysterious operating system or application crashes, or even the cases of overly helpful children or pets. At least you are able to get back the work up until the last autosave so (assuming you don’t have the period between saves set to a huge number, will often give you enough to get you back on track pretty quickly.

But how many users have had some sort of situation where they have to quickly close their document (or have had someone else close it for them)? Have you ever carefully poured work into your document and then clicked to close it and responded “Don’t Save” when prompted whether you wanted to save the changes? This is usually followed by open-mouthed disbelief, curse words and sometimes tears. How long was it since you saved your document?

In prior versions of Word, you were hosed. As soon as you clicked on the “Don’t Save” button, your autosave files were deleted and you were back to your last saved work.  If this was a brand new document, you were entirely hosed because there would be no last saved work to return to.

Word 2010 has added a new feature to autorecover that will help you retain your sanity and your editor’s good graces. There is now an option to save the last autosaved version if you close a document without saving. (Sorry, Mac people or those on prior versions of Word, this is a Word 2010 for Windows only feature at the moment though I will bet it will show up in the next Mac Office version.)

First, you need to turn on the feature:

  1. Open any document in Word 2010.
  2. Select File -> Options.
  3. In the left-hand pane, select Save.
  4. In the right-hand pane, ensure Save AutoRecover information is checked and you have a reasonable time period set (I generally advise 5-10 minutes.)
  5. Check the box for Keep the last autosaved version if I close without saving.
  6. Choose OK to save your changes.

Now if you close a document without saving your changes, you can do the following to get your last autosaved version back:

  1. Open the document you need to recover in Word 2010.
  2. Select the File -> Info.
  3. Under Manage Versions, you’ll see any number of entries but one will say (when I closed without saving) after the date and time. That is your last autosaved version. Select that version.
  4. Select Restore in the yellow banner at the top of the recovered document.

If you want to see the differences between the saved document and the last one autosaved, you can select Compare and Word 2010 will open a somewhat confusing screen to show you the differences between the two documents.

Friday, April 2nd, 2010
Rodent Program Managers – Update

This week the rodent program managers have become Nutria:

nutriapic

When I stopped to talk to them on Thursday, they told me that one of the development leads had confessed to both the capybara and nutria monikers and they think another PM had started it off with the squirrels tag but they’re not sure who labeled them hamsters.

Have to see what happens next week!

Friday, March 2nd, 2007
Excel – How to flip data axes (Transpose)

Another interesting question from a friend – If you have a Microsoft Excel spreadsheet and you realize your data should have it’s axes reversed (the data currently arranged vertically should be arranged horizontally), are you stuck retyping it or doing ugly cut & paste work for a long time?

Nope

The easiest way I’ve found to accomplish this switch is to make use of Excel’s own paste functionality.

  • Select all your data
  • Right click and choose “Copy”
  • Go to a new page in the spreadsheet and right click on the cell you want as the upper left cell
  • Select “Paste Special” from the context menu that popped up when you right clicked
  • Select “Transpose”
  • You’ll note that your data is now on the opposite axis from its original position.