Linking issue

[t]

Hi, I want to link the entire row that has data in sheet 1 to a cell in sheet
2.
Is this possible and if so how do you do it? Stuck on this issue.
-Version:Excel XP.

 

[vttotal]

Yes you can,

It is very simple. Just select on the cells that you want to insert a
hyperlink to and then click on the "Insert" Tab and then click on the
"Hyperlink" button. The hyperlink window will appear with different
properties and it will be pretty much straight forward from that point.

Hope this helps,

Vicente.

 

[t]

I chose the wrong name 'link', What I really want is to copy all the data on
sheet 1 (cell range a100-ac100) to sheet 2 cell b1. I don't want to do this
manually as I have over 500 rows. Is this possible? If so, please share an
example. Thanks.

 

[Gord Dibben]

Select A100:AC100 and Copy.

Switch to Sheet2 and select B1

Paste Special>Paste Links>OK>Esc

To do 500 rows, select the 500 and paste links all at once.


Gord Dibben MS Excel MVP