Hello!

if you want to add 3% or 5% to a column, first, we'll name the base column as Column A, then if we want to add 3% to 5% on to column A, we just need to put 1.03 or 1.05 to a random cell, Z1. Now, we can place a formula on another column, B, and use the formula:

=A*Z1

on Column B, and just drag it until the last entry of the column A. now we get a 3% increase for all the entries in Column A which are in Column B.

For more tips on excel and Financial Models, you can check this out. Hope this Helps!