View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default button to go to specific tab

Group all the sheets together by right-clicking on a sheet tab and
clicking Group All Sheets. Then in H1, say, you can enter this
formula:

=HYPERLINK("#Sheet1!A1","First page")

Then ungroup the sheets by right-clicking on a sheet tab and clicking
Ungroup.

This will put a clickable hyperlink in cell H1 on every sheet, showing
"First page" - just click on it to get there.

Hope this helps.

Pete

On Dec 7, 5:16*pm, vdmbqb wrote:
I have an excel 2003 spread sheet with 309 sheets. I want to create a button
on each sheet that when clicked will bring me back to sheet 1.

Thank you so much in advance.
--
bob