Error with equals function creates a spill instead of summing all the numbers

Occasional Visitor

I moved onto a Mac and I downloaded Office 365. 

Before when I used Windows I could simply select a cell and type = and then select the cells I wanted to sum. It would sum automatically. 

Now on my mac when I type = and select the cells I want to add it just copies and pastes the cells as a I copied them. 

Like when you select a cell and say = then select another cell. The one cells data is equal to the one you selected.

In the pictures you can see I have attached showing the formulas and then what the solutions are. 


Screenshot 2021-05-24 at 13.33.07.pngScreenshot 2021-05-24 at 13.34.05.png 


1 Reply


I have been using Excel for Windows for more than 25 years now. Typing = and then pointing to a range of cells have never resulted in a sum for me. For example, if I point to J100:K100, Excel creates the formula =J100:K100, just like you describe on the Mac...

But if I enter numbers in J100:K100, then select J100:K100 and press Alt+=, Excel inserts the formula =SUM(J100:K100) in the cell to the right, L100. The same happens if I select L100 and press Al+=