moving from one sheet to another from a cell of a sheet

M

mah1608

how to create the reference in one sheet so as to move clicking on the cell
of the sheet it could move to another sheet of the excel file
 
J

Jacob Skaria

Right Click-->Hyperlink-->Select 'Place in this document'--> Select the
target sheet name-->Type the target cell reference -->Click OK
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cell data entering slow! 0
Bugs in Office 2019 0
Update several ppt documents from a single excel file 0
External cell reference between two excel worksheets both in One Drive 0
Match and delete rows on two different sheets from reference numbers 4
VBA for Dependents shortcut menu 0
how to copy and paste value from one sheet to another 4
Combining two sheets of data into one and sorting by value - using macros 5

Top