The Fill Down Function: A Fast Way to Repeat Excel Formulas

by Donald Davidoff | Sep 12, 2018 12:00:00 AM

I’ve often had customers watch me work in an Excel sheet and ask about various shortcuts they see me use. So, this is the first in a series of occasional blogs on Excel tips and tricks I hope you find useful. If you’re not familiar with the “fill down” function, this is a great way to repeat a formula down a column. For example, let’s say that you have a row of unit types with the number of expiring leases and the number of renewals and you want to calculate the renewal rate as the number of renewals divided by the number expirations. In the example below, you can see that the studio rate is 58.3%.