mouse over

H

hurstead

I hope you bear with me as I only use excel for shopping lists :)

I want to link a specific row in worksheet 1 to the same in worksheet 2
so that if I mouse over in sheet 1 it shows the row from sheet 2

How do I do this
 
D

Dave Peterson

Excel doesn't work like this.

You could put anything you want in a comment to get the mouse over effect or you
can link one cell to another with a formula (and one cell "sends" the value to
the "receiving" cell--it's not a two way street).

='sheet2'!a1
or
=if('sheet2'!a1="","",'sheet2'!a1)
 
Top