#### Michaelwhli

##### New Member

- Joined
- Jan 15, 2005

- Messages
- 13

I was wondering if someone with a little more excel knowledge could be able to help me out with an excel file I am working on.

Basically I need to propgate a formula over 12 months (colums), and over 2000 different rows. The problem arises because I do not want to absolute reference the formula over the 2000 rows, just the 12 months.

The only way I can think of doing this is by propogating the formula down over the 2000 rows, then adding the absolute reference manually, then propogating it over the 12 months. This is very time consuming because I have two seperate cells that need to be absolute referenced in each row.

Is there any way that I can make excel absolute reference the same portion of the formula over the entire 2000 rows, or am I going to be forced to manually add the reference to each individual formula?

I hope this makes sense, it barely does to me and I may not have clearly expressed my problem.

Any help would be greatly appreciated, Thanks!