Forum Discussion
Excel . (dots) in formula not automatically changes to : when selecting multiple adjacent cells
Hello, Earlier: Eg. Sum A1:A10 in cell B10 Go to cell B10 and type =sum(, using arrow key go to a1 or a10, type . using arrow key select the full range and press enter Now: typing . as...
Yes, dot in a range with SUM doesn't work any more. It was discussed some ago here.
- But I used it till last week....
We shall be ready to what some undocumented feature will be broken one day. This one is not the only which eventually stops to work.
