When autocomplete results are available use up and down arrows to review and enter to select. Touch device users, explore by touch or with swipe gestures.
makeuseof.com
Named Ranges in Excel Make Spreadsheets Easier to Manage—Here's How
Turn your messy cell references into easily identifiable labels.
