Use a $ (dollar sign) infront of the row or column you do not wat to
change.

"Dmitry Kopnichev" wrote in message
...
Hello
How to use cells (located in a column) in formulas in a row automatically?
I
cannot copy the formula to other cells in the row because the coping moves
the selection to another column, not to a another row in the same column.