G$4-F$4 works when copying down or up. $G4-$F4 works right and left. If
you want it to work in all directions, type $G$4-$F$4.
An easier way to do this is to highlight the whole formula or only parts
of it or just place the cursor at the cell reference you want to change,
then press Shift+F4 repeatedly until it looks like... well, just try it
and you will find out how it works, I think.
Good luck.
Johnny
Den 2006-01-19 12:38:47 skrev Bashar Maree <[EMAIL PROTECTED]>:
Thanks, that worked perfectly.
On 1/19/06, Joe Conner <[EMAIL PROTECTED]> wrote:
Put a dollar sign before the numbers.
Example, G$5-F$5 will do it.
Bashar Maree wrote:
>Hi,
>Normally when I copy and paste an equation into a whole column
underneath
it
>the identifiers of the cells within the equation get incremented. For
>example G4-F4 would be pasted underneath as G5-F5 and then G6-F6 and so
on.
>Is there a way to turn off this auto incrementing feature?
>
>--
>
>
>
--
Bashar Maree
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
