On Thu, 2006-01-19 at 16:25 +0200, Bashar Maree wrote: > I see. It toggled between G4, $G4 and $G$4 which is quite neat. Where do > you guys learn these tricks? >
Often from http://documentation.openoffice.org and from Help. Try the doc pages for manuals, HOW-TOs et cetera. > 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 -- PLEASE KEEP MESSAGES ON THE LIST. OpenOffice.org Documentation Co-Lead http://documentation.openoffice.org/ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
