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...
It was really a nice trick!
We've discussed this issue before in this link.
Bottom line: this feature is broken or overwritten in recent Office 365 updates due to the new Excel data types (https://support.office.com/en-us/article/excel-data-types-stocks-and-geography-61a33056-9935-484f-8ac8-f1a89e210877) that came with the new error type https://support.office.com/en-us/article/-field-error-66b3a5db-1904-41aa-9913-51ded9dd15f2
Haytham Amairah
Thanks for thinking this to be a trick. As already mentioned by Jaydee2325 in the link mentioned by you its an old Lotus123 command.
However, I thank PRAY00 for raising this with the Excel Team as this was a very nice "trick" to be fast in excel.
Regards,
Siddhartha
Thanks for thinking this to be a trick. As already mentioned by Jaydee2325 in the link mentioned by you its an old Lotus123 command.
However, I thank PRAY00 for raising this with the Excel Team as this was a very nice "trick" to be fast in excel.
Regards,
Siddhartha