Archive of Mr Excel Message Board

Back to Hyperlinks in Excel archive index
Back to archive home

tabs

Posted by WDF on December 08, 2001 4:32 PM

using office 2000 can someone tell me how to go to any other sheet by clicking on a cell on the front rollup sheet ?

Re: tabs

Posted by Juan Pablo G. on December 08, 2001 5:58 PM

Try using Hyperlinks. Select the cell you want to click on, go to Insert - Hypherlink. One there, choose on the left "In this document", and select the "destiny" sheet. Excel will select A1 as default (Leave that unless you want to change it to a specific cell) and also will "suggest" something like "Sheet1!A1" for Text. You can change this if you want to. Click Ok.

Now, you're ready to click away.

Juan Pablo G.

Re: tabs

Posted by WDF on December 10, 2001 3:19 PM

Thanks Juan, It saves a lot of time

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.