Excel table formulas shift from cell positions to named columns with #All-style tags, keeping calculations readable when layouts change.

Welcome back to my blog on the features of Excel that are often overlooked in our hurry to be productive. A while back, we had part 1. Moving around an Excel worksheet can be challenging, especially ...