I use the =sum formula while holding down the control button and use the
mouse to select the cells I want added, the end result will look like
=SUM(a1,a3,a5 etc) This is "handy" when trying to add non adjacent cells.

"sneal" wrote in message
...
I just converted from Office 2004 for Mac to Office 2007 on a PC. On the
Mac, + signs would automatically be entered as I clicked cells after
entering
= (ie. =A1+A3+A5+A9.....). Now in 2007, it simply changes the first cell
information after the = sign is entered and the cells are clicked
(=A1....=A3.....etc.). I'm curious as to whether or not there is a
setting
for this so entering the + sign can be avoided when adding non-bunched
cells.
I know this may seem asinine, but this truly is a time saver in my
day-to-day operations.