Susan Harkins

Creating a list of sequential numbers isn’t as difficult as it might sound at first. If you can create a table, you can create a list of sequential numbers.

Editing text is tedious work. Use these two shortcuts to delete whole words instead of single characters.

This illustrated walk-through (with a demo worksheet) shows how easy it is to create a multi-column search solution using validation lists and conditional formatting.

When Word’s default tab stops of every half inch don’t get the job done, change the default setting!

Inputting data is seldom anybody’s favorite chore but controlling the way the cursor moves certainly eases the task.

We seldom need the XLStart folder, so when we do, we can never remember the entire path. Instead of searching, use this quick Excel tip instead.

Excel’s AVERAGE() function evaluates zero values. If you want to exclude zeroes, use these alternatives.

You can delete a problematic AutoCorrect entry or you can try this case shuffling trick to have your cake and eat it too.

Use Outlook’s conversation view to arrange related messages into meaningful groups.

You’ll want to add this quick selection trick to your repertoire. It’s handy when the range isn’t a complete data range or it comprises more than one data range.

Word’s default bullet character is adequate, but you can add a bit of distinction or creativity by using custom bullet characters.

After adding several charts to a sheet, you might want to adjust their sizes so they’re all the same. You can do so manually or by using the easy macro.