Excel - Easiest way to identify empty columns

I have a formula like this: =COUNTBLANK(BA3:BA21771)/ROWS(BA3:BA21771) I have columns that extend all the way out to KM. I really 开发者_开发百科don't want to have modify each column's formula like so:

=COUNTBLANK(BA3:BA21771)/ROWS(BA3:BA21771) =COUNTBLANK(BB3:BB21771)/ROWS(BB3:BB21771) =COUNTBLANK(BC3:BC21771)/ROWS(BC3:BC21771)

There must be an easier way! Any help?

Are you familiar with Edit->Fill Right?

You can "Fill Right" from the original formula, and it will copy the formula with an updated column label.

Highlight the cell with the formula, and then using the black + at the bottom right of the cell, drag the box right to fill in the other columns. Each column will have the same formula, but will replace BA with BB, BC, BD, and so on.

If you need to anchor a column, you can use the '$' prefix, e.g. $BA.