Sparse Copy

From: MrExcel3

Added: 16 years ago · 3:12 · 480p

My favorite trick is to double click the fill handle to copy a formula. But, this requires the column to the left to have no blanks cells.