How do I select ranges by typing in the range value in Google Spreadsheets?
I need to be able to select, say, d3:d1000, by typing in “d3:d1000” somewhere. In other words, what F5 does in Excel. I have discovered named ranges; however, it is very cumbersome to create a single-use named range every time I want to select a one-off range. In Excel, I hit F5, type the range value, hit return, and it’s selected. What’s Google Spreadsheets’ equivalent?
Ranges can be entered fine in various places, including as arguments to functions such as SUM, or when applying conditional formatting via the modal dialog, so it seems very strange not to be able to enter them to perform simple selection.