In this first example we will try to link the cell to a website ... In the Type the cell reference enter the cell or tab you want to access. Press Ok to validate.

How to create an Excel drop down list from another tab Your email has been sent The data you want to use in an Excel drop down list usually won’t be in the same sheet as the drop down.

You could create something more sophisticated with LOOKUP functions, but they were a huge hassle to set up. Not anymore: Excel 2013’s table tools include features that make it easy to link ...