Auto fill in Excel

A good tool is one that is not only unobtrusive, but useful. Today, while working on documenting test cases I found that Excel once again surprised me with a hidden gem. While typing repetitive lists that differ only slightly it appears to have picked up the pattern and suggested in dimmed text what the rest of the table could be populated with. Pressing Enter at that point populated the table and perfectly so.

This is Excel 2016 from my Office 365 subscription. To me, this is a good tool that supports the work I’m doing. It’s something to keep in mind when building our own tools. Ensure they offer that background support to the tasks that users do most often. That’s when they add value. For more information on similar functionality have a read here.