How To Use Hyperlinks And Data Validation To Navigate In Excel

Using Data Validation in conjunction with Hyperlinks can give you a great and efficient tool to navigate around a large workbook that has many worksheets. Let’s see how it works…..

Related links:

Hyperlink blogpost – http://www.excel-bytes.com/2013315how-do-i-hyperlink/
Data Validation Lists blogpost – http://www.excel-bytes.com/2013324data-validation-part-1-the-list/

Free Download!

Subscribe to Download Your FREE Copy of
"My 70+ Favorite Excel Keyboard Shortcuts" Today!

Trackbacks/Pingbacks

  1. How To Create Drop Down Lists Three Different Ways In Excel | Excel Bytes - July 21, 2015

    […] Circle Invalid Data Limiting Survey Choices With Data Validation Dynamic Data Validation Lists Hyperlinks Using Data Validation Data Validation With Limiting Choices Data Validation With Tables & […]

  2. How To Use The Circle Invalid Data Option With Data Validation in Excel | Excel Bytes - July 21, 2015

    […] Hyperlinks Using Data Validation […]

Leave a Reply