how do I invoke formula pattern copying?

[Bob]

I find that new formulas that I want to copy to a pattern doesn't work.
Instead of copying the pattern, the formula is copied exactly, so I get the
same responce in the new cell, instead of the pattern, for instance the cell
below in the pattern is not put into place, the initial cell is copied down.

 

[Mike H]

Hi,

Perhaps you mean absolute and relative addressing

=$A$1 Will not increment when dragged
=A$1 The column will increment but the row is locked
=$A1 Column locked row increments
=A1 Both row and column increment.

Mike

 

[Rick Rothstein]

It is always a good idea to show an example of what you mean rather than
relying solely on wording to explain your problem.

 

[xlmate]

Hi Bob

I guess you are refering th absolute referencing.
Take away the $ in front of the column letter and cell number,
such as $A$2 to A2.

The columns and rows will change their cell's address after you
have copied across or down.

HTH
--
======================
Pls click Yes if this has help you
======================

Thank You

cheers,


I may be able to provide you a solution, there would be better solutions
from others.

 

[Gord Dibben]

Turn on Automatic Calculation under Tools>Options>Calculation.


Gord Dibben MS Excel MVP