How I link 1 sheet to other for sharing text information?

  • Thread starter Excel Information
  • Start date
E

Excel Information

I am working in sheet1, suppose I click any text from sheet 1 then related
sheet suppose sheet4 should open .How to do sheet to sheet linking?
 
R

Ron@Buy

Easiest method is a 'hyperlink'
Click on a cell in sheet1 - go to menu - insert - hyperlink, then complete
with sheet4 and relevant cell reference from sheet4 (or click on tab for
sheet4 and when it opens click on the relevant link cell). Next time you
click on the cell in sheet1 it will automatically take you to the linked cell
in sheet4.
Depends on which version of Excel you're using as to precise method
Hope this helps
 

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

Visio: copy text of a master shape to User-define Cells (Variable) 0
Section and Page numbering 0
External cell reference between two excel worksheets both in One Drive 0
Converting URLs in comments to Markdown-formatted links 2
selecting workbook/sheet 3
Consistent Sheet column header rows 2
Bugs in Office 2019 0
add hyperlink using sheet names and cells(i,j) 3

Top