Forum Discussion
perhaps a stupid question on setting ranges in Excel 2019, Office or Microsoft 365
Perhaps my memory is faulty - i'm getting on in years (57) so it's a possibility. I believe that I used to set the start of a range by pressing the '.' key. i would then use arrow keys to move the c...
As for the dot - I could be wrong, that feature never was documented. But used for years as compatibility with Lotus 1-2-3. In modern Excel it doesn't work any more, I guess due to introduction of new data types where the dot is used for other purposes.
Navigation - you may type =sum( after that move cursor on the cell and Ctrl+Shift+Arrow to select entire range, Enter.