Hi,

I'm working on a big excel table with 11000 lines
in my job. For a better overview I 'grouped' (hope
thats the right translation) some lines.

If I am now enter a function in a cell and try to
drag this function down to copy the function to all
the cells which are in the grouped lines, I
have the problem that excel will write also
in all the cells which are between the grouped lines.

So here's a sketch, maybe this makes things clearer:

v <-- normal line
x <-- the grouped lines, contains the normal lines 'v'

so could be like this:

Ungrouped:
v
v
v
v
x
v
v
v
x

grouped:

x
x

If I now write in the first x a function and drag it to the x line below,
excel writes also the function in the 3 v lines between the x's the same function.

This is a big problem for me. Is it possibly only to copy
the functions in the grouped lines?
By hand is a extrem time-consuming procedure, because
there are 700 grouped lines and several functions.
I would be really thankful if somebody can help me.

Greets from Germany

Toby