Copy vertical the same as horizantal.

[Ipsl]

So let me first sat this. Im using excel 07.

So hello everyone

I have 6000+ cells I need to formulate. Now when I fill one cell and pull the cell to the left, it reads the proper corisponding cells. A simple example would be like a multiplicaiton table. Now when I pull down:

Please Login or Register  to view this content.

it wil copy

Please Login or Register  to view this content.

I would like it to copy

Please Login or Register  to view this content.

This example was way simplified than my formulas but the same problem still happens. The thing that stumps me is when I pull the forlmula left. It will still read the cell to the right of the original cell. I hope that made sinnce and Im sorry I cant transfer my file to an oldr version, but Im guessing its something simple that I just don't know.

[mikerickson]

Try dragging =B1*A$2

The way I think of it, the dollar sign means "always"

A$2: always row 2, no matter where it is drug.

$A2: always Column A

$A$2: always A, always 2

[Ipsl]

Thanks. Yah kno you just taught me what I was wondering for a while... $ signs in formulas. Thanks bro