Navigating among worksheets within a workbook.

J

Jay King

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?
 
B

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)

Jay King said:
I have a workbook with many worksheets. Is it possible to link from one
Click to expand...
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?
 
D

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


Jay King said:
I have a workbook with many worksheets. Is it possible to link from one worksheet to another with a shortcut? My first worksheet
Click to expand...
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?
 
Top