I assume from your exasperated tone that you're dealing with Excel 2007? :-)

Go to the Page Layout tab and then in the [Sheet Options] group, click on
the drop down arrow in the lower right corner of the group. You'll find a
familiar looking worksheet setup dialog hiding in there.


"mjb" wrote:

I have set up an inventory of the chemicals we keep on an excel
spreadsheet... What I want to be able to do is to double-click on a chemical
(ie double-click in a cell) and be referred to new cell that lists the
synonym of that chemical.

In other words, when I double- click on 'salt' the spreadsheet moves me to
cell that says 'NaCl'... and thus, all of the pertinent information for NaCl.