Paste formula from a row into multiple selected rows?

[max3732]

I have a basic income statement with from multiple companies as well as the total of all companies and want to put the % each contributes to each category below the actual number.

The formula is very simple, which is taking the value from each company and dividing it by the total, which I did for the first category. Now I'm trying to figure out how to do that with the rest of the values, which are blank cells in the area that has the values. If I do down the line and do it one by one it works, but would take forever.

To try to do in one fell swoop I tried copying the first row with the formula, then selected the range with the values and blank cells. Then I did "Go to special" and "blanks", which highlights all the blank cells. Now that I'm trying paste the formula there it won't work because it says the size doesn't match. I tried it with paste formula only and it still don't work.

Aside from using VBA is there a simple way to tell excel I want to take the formula with the row I'm copying and put it into the blank cells?

Please see the attached sample sheet.

[mehmetcik]

Select The range starting with the cell with the formula.

Click on the formula in the formula box at the top of excel

Press ctrl and keep it pressed then press enter.

[max3732]

Select The range starting with the cell with the formula.

Click on the formula in the formula box at the top of excel

Press ctrl and keep it pressed then press enter.

Thank you! I was highlighting a blank area in addition to the ones listed and didn't realize it.