It worked the same way in Excel, except that Excel used F4 instead of
Shift+F4, as far as I remember... ;D
Johnny
Den 2006-01-19 15:25:33 skrev Bashar Maree <[EMAIL PROTECTED]>:
I see. It toggled between G4, $G4 and $G$4 which is quite neat. Where
do
you guys learn these tricks?
On 1/19/06, Johnny Andersson <[EMAIL PROTECTED]> wrote:
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
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]