On Sun, 2006-03-05 at 01:38 -0600, Adam Porter wrote: > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > This seems like a dumb question, but I've checked the help and looked on > Google and asked on #openoffice.org and I can't find the answer. In Calc, > how can I give an entire column the same (relative) formula? Isn't there a > better way than dragging down to the very bottom of the (seemingly endless) > spreadsheet? > > I have a simple spreadsheet to keep track of car mileage and gas usage, > prices, etc. I'd like to not have to copy three columns' formulas every > time I enter data in the next row. I must be missing something really > obvious, but I have looked and looked, and I can't find it! > > Thanks for any help.
Easy, follow the method outlined by Help > Contents > Index > Search term > formulas;copying. I think you will find this effective. You might also like to try, some of the techniques in the User Guide ( http://tinyurl.com/5u8bt ). In particular, the subsection entitled "Applying Multiple Operations" which is at or near page 232 to streamline your work. -- 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]
