excel ? on automatic calculations

[nilizandr]

Hi,
I use a lot of spreadsheets where I'll enter one data item into, sa
for example cell A1, and then I'll enter several formulas tha
reference the data in A1 (also formulas indirectly referencing A1, b
referencing another formula that's related to A1) .
I know how to select and drag down the formulas to perform the sam
operations on data that is entered in cell A2, A3, etc. But due to th
nature of my work, this leads to A LOT of dragging.

I've noticed that for certain formulas (but only a few), when I ente
new data in a new row, Excel will automatically drag down the adjacen
formula for me, and fill in the one or two adjacent columns, without m
having to do anything.

I wonder whether you know why the program would be doing this for onl
some formulas and not others, and how I can get the program to do thi
on a regular basis?
Thanks a million

 

[Guest]

If there are >=5 rows with consistent formatting, formulas, etc, then Excel will automatically copy formatting & formulas to additional rows.