Navigating among worksheets within a workbook.

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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?
 
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?
 
Back
Top