Linking to a row or colum, not a cell

Bryan James · Apr 26th, 2002, 07:39 AM

Does anyone know haw to hyperlink to a row in another sheet so that it will highlight the entire row? And on top of that, is it possible to set it up so that when it takes you to that row, it is in the center of the page?

Brian from Maui · Apr 26th, 2002, 10:32 AM

Bryan,

When you click the Hyperlink icon after saving your workbook, you can specify what worksheet and row and column to link to

Bryan James · Apr 26th, 2002, 10:43 AM

Thanks Brian, but when i do that, it asks for the "cell" reference, and i want it to go to the entire row, not just a cell in that row. Any ideas?

Brian from Maui · Apr 26th, 2002, 10:53 AM

Bryan,

Give a range i.e. A1:D1

Bryan James · Apr 26th, 2002, 10:59 AM

That did it, thanks. Hows the weather. I usualy go to Oahu five times a year for business.

Brian from Maui · Apr 26th, 2002, 11:01 AM

Quote:

On 2002-04-26 09:59, Bryan James wrote:
That did it, thanks. Hows the weather. I usualy go to Oahu five times a year for business.

Hot and Sunny

Happy_Dog · Apr 26th, 2002, 11:02 AM

You can just use 10:10 for an entire row.

Apr 26th, 2002, 07:39 AM	#1
Bryan James Board Regular Join Date: Apr 2002 Location: Richardson, TX Posts: 59	Does anyone know haw to hyperlink to a row in another sheet so that it will highlight the entire row? And on top of that, is it possible to set it up so that when it takes you to that row, it is in the center of the page? __________________ Bryan

Apr 26th, 2002, 10:43 AM	#3
Bryan James Board Regular Join Date: Apr 2002 Location: Richardson, TX Posts: 59	Thanks Brian, but when i do that, it asks for the "cell" reference, and i want it to go to the entire row, not just a cell in that row. Any ideas? __________________ Bryan

Apr 26th, 2002, 10:59 AM	#5
Bryan James Board Regular Join Date: Apr 2002 Location: Richardson, TX Posts: 59	That did it, thanks. Hows the weather. I usualy go to Oahu five times a year for business. __________________ Bryan

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 26th, 2002, 10:32 AM	#2
Brian from Maui Board Regular Join Date: Feb 2002 Posts: 7,743	Bryan, When you click the Hyperlink icon after saving your workbook, you can specify what worksheet and row and column to link to

Apr 26th, 2002, 10:53 AM	#4
Brian from Maui Board Regular Join Date: Feb 2002 Posts: 7,743	Bryan, Give a range i.e. A1:D1

Apr 26th, 2002, 11:02 AM	#7
Happy_Dog New Member Join Date: Apr 2002 Posts: 16	You can just use 10:10 for an entire row.