Go to cell by input address
Focus on address field, and input “E10”, then press enter:
The cell “E10” will be selected:
Define a named range
Select a range on spreadsheet:
Focus inside the address field:
Input “myrange” as name, then press enter, the name will be added into the name list.
Select a named range
Click the arrow on the right side of address field, select a name from the list:
A range which is attached to the name will be selected on spreadsheet automatically.