Forum Discussion
Error with equals function creates a spill instead of summing all the numbers
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...
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+=