You can search this topic in Excel Help by typing "About cell and range
references". There is a complete description of using Fixed References.

Fixed Reference means when you will copy the formula fill down or fill
across the formula reference will not change.

For Exmaple:

A B C
------------------------------------------------------------
1 Pentium 4 Fixed Price Qty Amount
2 27.50 2 =sum($a$2*b2),
will be (27.50*2)

when you will copy this formula, see what will happen:

3 5 =sum($a$2*b3)
will be (27.50*5)
4 3 =sum($a$2*b4)
will be (27.50*3)
5 5 =sum($a$2*b5)
will be (27.50*5)


you can also use fixed reference on any range like: =sum($a$2*$b$2)

Hope, this is what you are looking for. Let us know, if it works for you.

"bob135" wrote:


I have items B2 through Q2 and B17 through Q17 on six sheets. I want to
create references on a new sheet with these two sets of rows listed as
two columns, A1 through A96 and B1 through B96. Is there a way to set
this up so I only have to enter a few forumulas and then fill down?

Usually when you fill down, it changes the row, and when you fill
accross, it changes the column. Is there a way to temporarily flip this
so I don't have to manually enter all 96 references?


--
bob135
------------------------------------------------------------------------
bob135's Profile: http://www.excelforum.com/member.php...o&userid=33388
View this thread: http://www.excelforum.com/showthread...hreadid=532136