How-To Geek on MSN

How to use the EXPAND function in Microsoft Excel

Lock dynamic arrays into fixed shapes so dashboards stay neat, tables stack cleanly, and templates keep their layout.
Hosted on MSN

Don't trust Excel's COUNTA function to count non-blank cells—here's a better method

In most counting scenarios in Excel, COUNTBLANK reliably counts blank cells, and COUNTA reliably counts populated cells. However, with these functions comes a problematic paradox: an empty string from ...