Automatic formula copying in Excel (even with blanks) Imagine that you have 50,000 rows of data. You want to add a new calculated column. Adding the formula is easy. But copying it to 50,000 rows is nothing but Read ยป