To be more specific, well, this dropdown shows each range users currently have that, when clicked, will display all of the coordinates contained in that range. About the “Manage named ranges” option, it will help users create new ranges so easily and fastly, as well as manage the current ones. It is a simple but very feature for any Google Sheet user.