I am constructing a document which displays the averages of a number of separate workbook all with identical formatting. A sample of the formatting is as follows:

Percent Baking Supplies 15.0
Percent Total Weight

Wheat Flour 25 1 3/4
White Flour 25 1 3/4

There are hundreds of these boxes. While I've constructed a formula to do the work, I would like to be able to quickly autofill the whole sheet while keeping the labels intact, and so the above doesn't turn out looking like:

#DIV/0! 15 #DIV/0!
#DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0!
#DIV/0! 27 2
#DIV/0! 25 1

When I lock all the cells with labels, Excell 2007 won't let me drag the autofill box over the locked cells, meaning that either way right now I have to input the new formula by row and and drag small sections at a time. Any advice?