When you copy a formula across cells it changes the oringinal cells in a forumla in respect to how far you have moved it to keep the formula constant across cells... right.
so =(C20+L20+U20)/AK31 moved across by one cell becomes =(D20+M20+V20)/AL31
So all the reference cells move by one.
My question is
how can you configure it so some reference cells move, and some stays the same? so for above it would be
=(C20+L20+U20)/AK31 moved across by one cell becomes =(D20+M20+V20)/AK31
so the AK31 bit is constant still
help please.... x
noocentric
was intentional
Is there something in the "paste special" settings
that will allow you to copy a formula without changing the cell values within the formula?
I just re-read it and realised that I'm probably not much help
sorry :S
$
It's all about the dollar. Copy $A1 across and you'll get $A1,$A2... etc.
I think you need $AK$31
You can get this by pressing f4
when you have the value you want to remain constant selected.
Also you can keep either the letter or the number constant as well dependent on where you put the dollars and how many you use.
^5
large up you two
thank you very much, saves an awful of pointless clicking.
isn't that what you do all day on DiS anyway?
I know I do!