Enter your email address for weekly access to top multifamily blogs!

Multifamily Blogs

This is some blog description about this site

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

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%. 

Excel Fill Down Function

 

To repeat this, you can re-type the formula three more times or you could copy and paste the formula three times, but both of these are pretty tedious; they would be prohibitively time consuming if you were working with a list many rows long. 

Many of you may be familiar with a shortcut whereby you first select the range of cells you want to have use the same formula and then use the keyboard shortcut CTRL-D to fill down: 

Fill Down Function

That’s great but still a bit of a pain on a very long list. Here’s my favorite shortcut…and on long lists almost looks like magic. 

Notice the little box at the bottom right of the cell selected? I’ve highlighted it with a red circle to make it more obvious: 

Fill Down Function Shortcut

 Simply double-click on that box and VOILA!...the formula fills all the way down.  

 Excel Fill Down Function Shortcut

Please note that, for this to work the way you want, there can be no blank cells in column C for any rows you want filled. This shortcut fills down until it finds a blank cell in the column to its left. Any blank cell in that column will end the “fill down” even if there is content just a single row lower. 

There you go…simple as that you have one of the bigger time savers in the Excel shortcut arsenal! 

Rate this blog entry:
0
 

Leave your comments

  STOP ask yourself do you do your follow up calls or thank you cards?!?!?!?  By Jolene Sopalski Leasing Specialist WRH Realty Services If you answered no to that question then I want you to hold up your right hand and pledge the following “ I will  start following up with my prospects no prospect will go un-followed up”. Good now if you are one of the ones that said yes I do my follow up calls and thank you cards I want to give you a big hug so just picture me giving&...
If you have shopped enough apartment communities, you will find some leasing consultants who take a "self service" attitude to showing the model apartment to a prospect.  They open the door, announce that "this is the apartment", and then just watch the prospect as he or she walks from room to room.  They expect the apartment to sell the prospect, not themselves, and it often leaves the tour feeling flat and uninspiring. Conversely, today I went to one of my favorite Starbucks, and sa...
How much impact does word choice have in your ability to lease your apartments to prospective residents? Or should I say, "How much impact does word choice have in your abililty to lease your apartment homes to your prospective tenants?Now, if you're like me, the word "tenants" was like fingernails on a chalkboard to you just now. But there seems to be a real controversy in our industry on whether or not you should call an 'apartment' an 'apartment home'. Here's my take (yes,...