Thoughtful, detailed coverage of the Mac, iPhone, and iPad, plus the best-selling Take Control ebooks.

 

 

Pick an apple! 
 
Search Snippets on the Fly in TextExpander

Have a large number of snippets and can't remember them all your abbreviations? Use TextExpander's Suggest Matching Abbreviations search feature. It makes finding your snippets fast and simple.

Set your hotkey combination by going to TextExpander > Preferences > Hotkeys. Once it's set, to use the Suggest Matching Abbreviations hotkey combination:

  1. Type a few characters of your snippet or its abbreviation.
  2. Press your hotkey combination immediately after typing the characters. (Don't enter a space before pressing the hotkey combination.)
  3. A popup menu appears with all snippets that contain the characters you typed. Scroll through them and click the one you want.

Visit Smile

 
 

Excel Workbook Backup Tip

Send Article to a Friend

In TidBITS-133 Andy Williams passed on a warning about a potentially dangerous bug in Excel 4.0 that could cause you to lose data bound into a workbook. The problem arises if your computer crashes while saving, because Excel will have overwritten the old, complete version with the newer, incomplete version, and you then can start on the hair-pulling. At the end of Andy's note, I mentioned that a clever macro programmer could probably script an automatic backup to ensure that you always had two copies of the workbook when you were working on it. Luckily for the Excel community, our local Seattle Excel guru Howard Hansen has come up with a workaround that doesn't even require a macro and will create a backup of the workbook every time you save. To do this, follow these steps:

  • Activate the workbook's contents page.

  • Choose Save As... from the File menu.

  • Click the Options button. Excel will bring up its Options dialog box.

  • Check the Create Backup File checkbox, then click the OK button to close the Options dialog box.

  • Click the Save button to save the file to disk (and make a backup).

Excel will now take the old workbook file and rename it "Backup of" and the name. If anything evil happens during a save, you will always have the backup.

Information from:
Howard Hansen -- HHansen@aol.com

 

READERS LIKE YOU! Support TidBITS by becoming a member today!
Check out the perks at <http://tidbits.com/member_benefits.html>
Special thanks to Michael Daren, Lawrence Kerr, Charles Eimermann, and
Edie Evans for their generous support!