Debora Cass wrote:
I am using version 2.1 of Openoffice.org. My problem is that I can not get the
auto sum function to work. I put numbers in a column and then highlight the
numbers to be totaled by click on the sum icon. All it does is put =sum() on
my first row in the column. I also went to Edit - Fill and the sub-menu is
greyed out so, I can not select anything from that list.
How do I get this to work.
Debora Cass
Library Senior
TNT Division
(928)692-5715
Ext:5715
Deborah:
To use Autosum, do not highlight the cells you want to sum. Click in a
cell below the column of numbers that you want to sum, and click the
Autosum button, then it will select the range of numbers in the column,
as long as they are contiguous.
If there is a gap within the numbers, it will only select numbers up to
the gap. If that's the case, it's easy to correct. Once you've clicked
in the cell where you want the sum to be placed, and click Autosum, just
click and drag through the range that you want summed, even if
OpenOffice has "guessed" a different range.
As far as the Edit > Fill function, I'm not sure how you tried to get it
to work, but here is what I just tried and it worked fine. I entered a
number in a cell. I clicked and that cell and dragged down to 10 more
cells. Then I selected Edit > Fill > Down, and the number I entered in
the first cell was copied down into the subsequent cells below it.
Please respond to [email protected] if you have additional questions.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
