MrExcel Publishing
Your One Stop for Excel Tips & Solutions


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 ?

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.

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

Thanks Juan, It saves a lot of time