A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

How to return to the previous active sheet after hyperlink?



 
 
Thread Tools Display Modes
  #1  
Old March 17th, 2010, 02:07 PM posted to microsoft.public.excel.worksheet.functions
terry
external usenet poster
 
Posts: 622
Default How to return to the previous active sheet after hyperlink?

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!
  #2  
Old March 17th, 2010, 04:45 PM posted to microsoft.public.excel.worksheet.functions
Luke M[_4_]
external usenet poster
 
Posts: 451
Default How to return to the previous active sheet after hyperlink?

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" wrote in message
...
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!



  #3  
Old March 17th, 2010, 11:58 PM posted to microsoft.public.excel.worksheet.functions
Ashish Mathur[_2_]
external usenet poster
 
Posts: 1,764
Default How to return to the previous active sheet after hyperlink?

Hi,

F5 Enter will take you back the sheet you came from

--
Regards,

Ashish Mathur
Microsoft Excel MVP

"Terry" wrote in message
...
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!


  #4  
Old March 20th, 2010, 04:47 AM posted to microsoft.public.excel.worksheet.functions
terry
external usenet poster
 
Posts: 622
Default How to return to the previous active sheet after hyperlink?

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" wrote in message
...
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!


  #5  
Old March 21st, 2010, 12:48 AM posted to microsoft.public.excel.worksheet.functions
terry
external usenet poster
 
Posts: 622
Default How to return to the previous active sheet after hyperlink?

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" wrote in message
...
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!


  #6  
Old March 21st, 2010, 02:53 AM posted to microsoft.public.excel.worksheet.functions
Ashish Mathur[_2_]
external usenet poster
 
Posts: 1,764
Default How to return to the previous active sheet after hyperlink?

You are welcome

--
Regards,

Ashish Mathur
Microsoft Excel MVP

"Terry" wrote in message
...
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" wrote in message
...
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!


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:55 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.