Prev: i can't get this formula to work
Next: Replace Cells with Column names in functions?
From: Terry on 17 Mar 2010 10:07
I have many sheets have hyperlinked into 1 common worksheet.
How can I return back to the original sheet after click the hyperlink and
navigated to the common work sheet?
Thanks for advise!
From: Luke M on 17 Mar 2010 12:45
Under view - toolsbars - Web. Note the back/forward buttons. You can either
leave the whole toolbar open, or move these buttons to a different toolbar,
and then use them to go back to previously active sheet.

--
Best Regards,

Luke M
"Terry" <Terry(a)discussions.microsoft.com> wrote in message
news:64E84AFB-F3CF-4D60-8B31-2C0EC10807D0(a)microsoft.com...
>I have many sheets have hyperlinked into 1 common worksheet.
> How can I return back to the original sheet after click the hyperlink and
> navigated to the common work sheet?
> Thanks for advise!


From: Ashish Mathur on 17 Mar 2010 19:58
Hi,

F5 > Enter will take you back the sheet you came from

--
Regards,

Ashish Mathur
Microsoft Excel MVP

"Terry" <Terry(a)discussions.microsoft.com> wrote in message
news:64E84AFB-F3CF-4D60-8B31-2C0EC10807D0(a)microsoft.com...
> I have many sheets have hyperlinked into 1 common worksheet.
> How can I return back to the original sheet after click the hyperlink and
> navigated to the common work sheet?
> Thanks for advise!

From: Terry on 20 Mar 2010 00:47
Thanks a lot for your advise! Brilliant!
I used the back button in the tool bar in Excel 2003.
However, I can't find the button in the Excel 2007 tool bar.
Is there any navigating backward button provided in Excel 2007?

"Ashish Mathur" wrote:

> Hi,
>
> F5 > Enter will take you back the sheet you came from
>
> --
> Regards,
>
> Ashish Mathur
> Microsoft Excel MVP
>
> "Terry" <Terry(a)discussions.microsoft.com> wrote in message
> news:64E84AFB-F3CF-4D60-8B31-2C0EC10807D0(a)microsoft.com...
> > I have many sheets have hyperlinked into 1 common worksheet.
> > How can I return back to the original sheet after click the hyperlink and
> > navigated to the common work sheet?
> > Thanks for advise!
>
From: Terry on 20 Mar 2010 20:48
I found it in the list. Thanks for all of the help!

"Terry" wrote:

> Thanks a lot for your advise! Brilliant!
> I used the back button in the tool bar in Excel 2003.
> However, I can't find the button in the Excel 2007 tool bar.
> Is there any navigating backward button provided in Excel 2007?
>
> "Ashish Mathur" wrote:
>
> > Hi,
> >
> > F5 > Enter will take you back the sheet you came from
> >
> > --
> > Regards,
> >
> > Ashish Mathur
> > Microsoft Excel MVP
> >
> > "Terry" <Terry(a)discussions.microsoft.com> wrote in message
> > news:64E84AFB-F3CF-4D60-8B31-2C0EC10807D0(a)microsoft.com...
> > > I have many sheets have hyperlinked into 1 common worksheet.
> > > How can I return back to the original sheet after click the hyperlink and
> > > navigated to the common work sheet?
> > > Thanks for advise!
> >
 |  Next  |  Last
Pages: 1 2
Prev: i can't get this formula to work
Next: Replace Cells with Column names in functions?