Where is the Autosum Button in OpenOffice.org Spreadsheet (Calc)

by Phil Oakley on February 12, 2009

Some of the smallest problems are sometimes the most annoying. I had a call from a new OpenOffice.org user today who could not find the AutoSum button.

I know how he feels, we sometimes get so used to a certain interfaces that we can struggle with even the smallest change. OpenOffice 3 and its earlier versions have a classic spreadsheet layout and most Excel users (version 2003 and prior) will find the interface instantly recognisable BUT where is, our old favourite, the Autosum button. In Excel this was the Sigma sign normally to be found on the standard toolbar at the top.

With OpenOffice.org Autosum is still the Sigma sign but is on the Formula Bar (when you are clicked in a cell) and of course just with Excel you can type straight into a cell e.g. “=sum(cellref1:cellref2)”

Screenshot below shows the AutoSum button in OpenOffice.org:

Autosum Button on OO.o

Autosum Button on OO.o

{ 2 comments… read them below or add one }

delawarenewhomes December 2, 2009 at 3:39 pm

Thank you! You just saved me from hours of frustration. This site came up #1 on Google for the search term Where is auto sum in Open Office.

Thanks again!

Reply

Phil Oakley December 2, 2009 at 5:57 pm

No problem. Glad I could help. Hopefully this post will help others who are looking for the autosum button in Open office.

Reply

Leave a Comment

Previous post:

Next post: