how do I invoke formula pattern copying?
 

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.

how do I invoke formula pattern copying?
 

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

"Bob" wrote:

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.

how do I invoke formula pattern copying?
 

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

--
Rick (MVP - Excel)


"Bob" wrote in message
...
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.

how do I invoke formula pattern copying?
 

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.



"Bob" wrote:

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.

how do I invoke formula pattern copying?
 

Turn on Automatic Calculation under ToolsOptionsCalculation.


Gord Dibben MS Excel MVP

On Sat, 6 Dec 2008 08:53:01 -0800, Bob
wrote:

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.