Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
GO TO LAST SHEET
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 "Go To" feature (i.e. Ctrl + G) for working within one sheet???? -- Carolan |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
GO TO LAST SHEET
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 "Carolan" wrote: 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 "Go To" feature (i.e. Ctrl + G) for working within one sheet???? -- Carolan |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
GO TO LAST SHEET
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. "CLR" wrote in message ... 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 "Carolan" wrote: 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 "Go To" feature (i.e. Ctrl + G) for working within one sheet???? -- Carolan |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
GO TO LAST SHEET
You can right click on the tab names to get a list of sheets in the book &
click on the one you want "Carolan" wrote: 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 "Go To" feature (i.e. Ctrl + G) for working within one sheet???? -- Carolan |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
GO TO LAST SHEET
Oops - don't right click on the tab names, but on the VCR buttons to the left
of the tab names "Carolan" wrote: 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 "Go To" feature (i.e. Ctrl + G) for working within one sheet???? -- Carolan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
lock tab in sheet 2 until cell in sheet one is completed | Excel Worksheet Functions | |||
Clicking Cell Link Changes Cell on Another Sheet | Excel Discussion (Misc queries) | |||
Using a relative SHEET reference for source data in a chart | Charts and Charting in Excel | |||
linking multiple sheets to a summary sheet | Excel Discussion (Misc queries) | |||
Function to automatically insert a new sheet as a result of data entry? | Excel Worksheet Functions |