Using the (Edit > GoTo) dialog box
When you select Find & Select > GoTo all the named ranges are displayed in alphabetical order.
This dialog box can provide a very quick way to move around worksheets and workbooks.
The GoTo dialog box remembers the last four cells or ranges of cells you visited. Your previous cell range will automatically appear in the Reference box when the dialog box is displayed.
The F5 key is a shortcut key for displaying the (Edit > GoTo) dialog box.
© 2020 Better Solutions Limited. All Rights Reserved. © 2020 Better Solutions Limited TopPrevNext