Should You Raise Prices? Everything worked well on my computer, so I sent the file to my client, for testing. Keep in mind that this is only an alternative approach to iterative calculations. Chances are this post did not give you the exact answer you were looking for. We can select any range but selecting the same range makes it easy to implement. The example demonstrates how to fill cells by day increments, but you can also increment by week, month and year. Excel will automatically autofill the entire column, but only down to where the adjacent column actually has data. Or if possible autofill every other blank column automatically with the percentage formulas using VBA.