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