Legal Office Guru header image

Legal Office Guru

≡ Menu

Weekly Roundup: Outlook Autocomplete, When Excel Won’t Calc, etc.

Weekly Roundup: Outlook Autocomplete, When Excel Won’t Calc, etc. post image

Unless otherwise noted, all instructions and screenshots are from Microsoft Office for Windows.

From this week’s reading: when Outlook’s Autocomplete … won’t, when Excel’s autocalc … doesn’t, cleaning up imported data in Excel, and what to do with 250 Vcards.

Autocomplete in Outlook not working — For those of you not familiar with the term “autocomplete” in this context, this is the feature by which Outlook will attempt to “guess” which email address you’re typing in after you’ve gotten about 3-4 characters in (so, if you’ve emailed john.doe@gmail.com before, Outlook will offer to automatically complete the address after you’ve typed “john”). It’s a controversial feature, particularly among lawyers (for example, click here and here and here), but if yours suddenly stops working and you like this feature, click the title link above for a tip on restoring it.

Mass Import of VCards into Outlook – A Painful Process — From “friend of this blog” Vivian Manning comes the tale of an IT challenge: taking a disk with 250 (yes, two hundred fifty) VCards and saving them into someone’s Outlook Contacts. “Painful” pretty much nails it. If you’ve got an easier solution to share with Vivian, she’s invited any and all to leave comments on the article linked above.

Why Excel formulas might not calculate as expected — If you’ve ever had an Excel formula that you’ve checked (and double-checked and triple-checked), but you know it’s still not calculating right, Susan Harkins at TechRepublic has one more thing you can check.

Clean up imported data in Excel — Got some data you’ve pulled into Excel from another source? Microsoft’s Excel blog has a tutorial on re-formatting that data into a more aesthetically pleasing and/or useful layout (including stringing together different columns like lastname + firstname into one column). Click the link above for not only an illustrated tutorial, but also a practice spreadsheet you can work with at your desk.

by Deborah Savadra

I spend an inordinate amount of my time playing with computers and attempting to explain technology to lawyers and law office staff. It's not always easy, but someone's got to do it.

WOW – You read that whole post!

Want more Legal Office Guru goodness? Give me your email and I’ll send you
my top tips & tricks for Microsoft Office
PLUS my 22-page illustrated Fast Formatting Fixes report!

Your email and other personal information will never be sold or given to any third party.