software

I have a workbook that has 15 sheets. Is there a quicker way of moving from
Sheet one to Sheet 15 without using the mouse or Ctrl Page Down ten times??
Something like the quot;Go Toquot; feature (i.e. Ctrl G) for working within one
sheet????
--
Carolan

One way would be to create a Rangename in cell A1 of each of your sheets,
called _Sh1, _Sh2, _Sh3, etc

Then do F5 and select which sheet you want to go to........
The underscores in the above RangeNames is to make them appear at the
beginning of your list of rangenames if you have many.....not needed if you
only have a few rangenames.

hth
Vaya con Dios,
Chuck, CABGx3
quot;Carolanquot; wrote:

gt; I have a workbook that has 15 sheets. Is there a quicker way of moving from
gt; Sheet one to Sheet 15 without using the mouse or Ctrl Page Down ten times??
gt; Something like the quot;Go Toquot; feature (i.e. Ctrl G) for working within one
gt; sheet????
gt; --
gt; Carolan

Hi

If you right-click on the 'forward sheet'/'back a sheet' buttons to the left
of the sheet tabs, Excel displays a list of sheets which you can click to go
to directly.

Andy.

quot;CLRquot; gt; wrote in message
...
gt; One way would be to create a Rangename in cell A1 of each of your sheets,
gt; called _Sh1, _Sh2, _Sh3, etc
gt;
gt; Then do F5 and select which sheet you want to go to........
gt; The underscores in the above RangeNames is to make them appear at the
gt; beginning of your list of rangenames if you have many.....not needed if
gt; you
gt; only have a few rangenames.
gt;
gt; hth
gt; Vaya con Dios,
gt; Chuck, CABGx3
gt;
gt;
gt;
gt; quot;Carolanquot; wrote:
gt;
gt;gt; I have a workbook that has 15 sheets. Is there a quicker way of moving
gt;gt; from
gt;gt; Sheet one to Sheet 15 without using the mouse or Ctrl Page Down ten
gt;gt; times??
gt;gt; Something like the quot;Go Toquot; feature (i.e. Ctrl G) for working within
gt;gt; one
gt;gt; sheet????
gt;gt; --
gt;gt; Carolan
You can right click on the tab names to get a list of sheets in the book amp;
click on the one you want

quot;Carolanquot; wrote:

gt; I have a workbook that has 15 sheets. Is there a quicker way of moving from
gt; Sheet one to Sheet 15 without using the mouse or Ctrl Page Down ten times??
gt; Something like the quot;Go Toquot; feature (i.e. Ctrl G) for working within one
gt; sheet????
gt; --
gt; Carolan

Oops - don't right click on the tab names, but on the VCR buttons to the left
of the tab namesquot;Carolanquot; wrote:

gt; I have a workbook that has 15 sheets. Is there a quicker way of moving from
gt; Sheet one to Sheet 15 without using the mouse or Ctrl Page Down ten times??
gt; Something like the quot;Go Toquot; feature (i.e. Ctrl G) for working within one
gt; sheet????
gt; --
gt; Carolan