Carolyn wrote: > First, though I prowled through all the configuration areas I could
">Format >Stylist >Cell Styles >Font" > find anything on the "very difficult" formula C2=D2+E2+F2+G2+H2+I2. In "C2", you simply type (sans quote marks) "= d2+e2+f2+g2+h2+i2" > Then, how do I copy that formula to rows 3, 4, etc.? Copy c2 (or the entire row) and then past on c3, on down. > I also want to add columns and copy that formula to columns C, D, etc. "=sum (c1:c3200) will total up everything in column c. You probably want to change the "1" to the first row in the column to be added, and the "3200" to the last row in the column you want included in the addition. > I've also had a problem with trying to use currency but it insists upon > dropping unnecessary (HA!) zeros to the right of the decimal point. "CTRL F12 >cell Styles >Numbering" and change it to currency. > Is there a section of the help file that covers really simple, basic > information? Yes, but you have to know the exact term, to find what you re looking for, which doesn't help anybody when they don't' know what the term used to describe what they want done is. xan jonathon -- Does your Office Suite conform to ISO Standards? --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
