Google has added a simple, but useful feature to Sheets: a range name box. If you click to the left of the formula bar, the new dropdown shows your current ranges in the sheet, as well as an option to manage new ranges.

Read More