Navigating among worksheets within a workbook.

[Guest]

I have a workbook with many worksheets. Is it possible to link from one worksheet to another with a shortcut? My first worksheet is a summary of the others. I'd like to be able to navigate from the summary worksheet to each other worksheet (and back) without scrolling. Is there anyway to do this?

 

[Frank Kabel]

Hi Jay

you can insert a hyperlink (goto 'Insert - Hyperlink)


HTH
Frank

 

[Bob Phillips]

Add a hyperlink from the Insert menu.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

I have a workbook with many worksheets. Is it possible to link from one

worksheet to another with a shortcut? My first worksheet is a summary of
the others. I'd like to be able to navigate from the summary worksheet to
each other worksheet (and back) without scrolling. Is there anyway to do
this?

 

[David McRitchie]

Hi Jay,
Two pages may be of interest to you:

Build Table of Contents, similar listings, working with Hyperlinks
http://www.mvps.org/dmcritchie/excel/buildtoc.htm

Build TOC Another Approach
: http://www.mvps.org/dmcritchie/excel/buildtoc2.htm
Summary page with all pages in exactly the same format.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm

I have a workbook with many worksheets. Is it possible to link from one worksheet to another with a shortcut? My first worksheet

is a summary of the others. I'd like to be able to navigate from the summary worksheet to each other worksheet (and back) without
scrolling. Is there anyway to do this?