Fill Down Excluding First Row

  • Thread starter Thread starter bodhisoma
  • Start date Start date
B

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
 
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
 
Back
Top