Susan Harkins

Protecting data in a Word table isn’t as simple as turning a protection feature on, but it’s possible using Text Form Field controls.

Susan Harkins shows you two quick and easy methods for sending contact information to others via email with Outlook.

This week, share your Excel skills by completing a production sheet and learn why a Word document might show index tags, despite your best efforts to hide them.

Susan Harkins shows you how to add the Blind Carbon Copy and From fields to your next Microsoft Outlook email.

Add-ins let you enhance your Office apps so they can do more things — and do things better. Susan Harkins combed through the vast sea of Office add-ins to produce this gallery of winners.

Susan Harkins shows you a quick method for removing validation rules for multiple ranges in Excel, at the same time.

Word offers a variety of standard ways to enter and format page numbers in a document. But these advanced tricks will let you achieve far more control and flexibility for your specific needs.

Excel 2007’s new table feature eliminates the need to copy formulas; once you define a data range as a table, Excel will do it for you!

Microsoft Excel’s fill handle tool won’t create an alphabetic list by default, but there are a few tricks you can use to make it work.

Populating a combo box isn’t hard, but getting the combo box to communicate with a constantly changing list is a little more difficult. Learn how to populate your combo box with a dynamic list.

Learn how to identify formula cells the easy way using VBA, and then combine VBA and conditional formatting for more permanent identification.

The superiority of surrogate versus natural keys is a hotly debated topic among database developers. Susan Harkins offers some insights into when — and why — you might choose one over the other.