Fill Down Excluding First Row

[bodhisoma]

Greetings,

I have a spreadsheet where the first row (1) consists of labels that
describe the column located below each label. For example, I have
calories, fat, carbs, etc. It is desirable to have some of these
columns filled in automatically. For example one row might be
"calories from fat," "calories from carbs," etc, and so I'm doing a
"fill down" on those columns.

Unfortunately, the fill downs are completing the columns with the
labels. So I'm wondering if it's possible to:

(a) Exclude the label row (row 1) from the fill down or, better yet;

(b) Somehow cordon off the first row so that equations to the sheet do
not include them.

Thanks much in advance,
Jason

 

[Bernie Deitrick]

Jason,

Perhaps.... Insert a new row 2, and keep it entirely blank, and that will "break" the autofill link
from the first row.

HTH,
Bernie
MS Excel MVP