click on cell takes you to specific sheet

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

Guest

Sheet 1 is a summary. Each value comes from an underlying sheet.

Is there a way of clicking on the cell and it will jump me to the specific
sheet. With 40 or so sheets it is hard to remember which sheet generates the
value on sheet 1.

Thank you
 
You can make a hyperlink which lets you jump to a specified cell in a
specified worksheet with Insert / Hyperlink.. /Place in This Document .
GL,
Henk
 
=?Utf-8?B? said:
Sheet 1 is a summary. Each value comes from an underlying sheet.

Is there a way of clicking on the cell and it will jump me to the specific
sheet. With 40 or so sheets it is hard to remember which sheet generates the
value on sheet 1.

Thank you
Click to expand...
Check out XL's 'Formula Auditing' Toolbar. The commands on the toolbar are
also available from the Tools | Formula Auditing > submenu.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Back
Top