the $ in a cell reference makes either the row, column or the complete cell
absolute. So E$5 makes the row absolute so if you use the fill handle a fill
the formula across rows the column will change but the row number is fixed at
5
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)


"Dmitrii" wrote:

Hello.

Please tell me what is the difference for example E$5 from E5?

In the document i need to understand there is a line - 'Pro Forma
I.S.'!I$5*'Pro Forma B.S.'!H69

i understand that we I5 from Pro Forma I.S. * H69 from Pro Forma B.S.

but i still cant undertstand why user who made this model used I$5?
I used this option in my test exell document and didnot saw the difference.
Please tell me it.
In help there are no coments about $ :(