Autofill Formula Across Locked Cells

[WJordan]

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?

[TMS]

Locking cells is usually to prevent people from inadvertently corrupting the data/formulae, not to prevent the author from maintaining it. Locked cells only have an effect if the worksheet is protected. So, unprotected the sheet, make your changes and protect the sheet again.

Regards, TMS

[WJordan]

Thanks for the response. Unfortunately, I want to make sure that the labels stay in place. If I drag the formula over the entire table, it will eliminate all the labels. Is there a way to autofill an entire table without disrupting those labels?

[TMS]

I'm not sure what you mean by "labels".

Please post a sample workbook.

Regards, TMS

[WJordan]

Here is the sample. Basically, I want to input a new formula and drag it into all other blanks with numbers in them. However, I want all the labels (any cell with text) to remain the same. All the blanks also need to remain blank. Is there a quick way to do this?