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.

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" wrote:

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.

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.

"vttotal" wrote:

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" wrote:

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.

Select A100:AC100 and Copy.

Switch to Sheet2 and select B1

Paste SpecialPaste LinksOKEsc

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


Gord Dibben MS Excel MVP

On Mon, 8 Feb 2010 13:49:02 -0800, t wrote:

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.

"vttotal" wrote:

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" wrote:

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.