Forum Discussion
SUM!?
I'm also not a Mac user. Base on this thread Just click individual cells to sum in Excel (microsoft.com) such functionality on Mac disappeared with introduction of 2016.
cornucopia wrote: ``I've merely inserted = and then clicked on each above cell which highlights in a different color.``
I am not familiar with Excel for Mac. But I am quite sure that Excel for Windows has never behaved exactly that way. I suspect that you forgot some details.
In any case, in my version of Excel (Excel 2010 for Windows), the following works as you describe for my example: select E5; click AutoSum (upper right) -- no need to type "="; press and hold Ctrl, then click each cell; release Ctrl and press Enter. Caveat: AutoSum might be in a different position of the toolbar in your version.
Note: The image assumes that you selected the option "Allow editing directly in cells". In my version of Excel, click File > Options > Advanced. Otherwise, the colored cell names appear in the Formula Bar.
- Even that way its necessary to type the delimiter (comma). Because when A1 is selected and then you select B1, without delimiter it using comma, the last click will be the range for the formula.
Juliano-Petrukio wrote: ``Even that way its necessary to type the delimiter (comma).``
No. But I made a critical error when I typed the description. I edited the posting with the correction. Reread and try again. Sorry.
