+ Reply to Thread
Results 1 to 2 of 2

Link a cell to a worksheet, same workbook

  1. #1
    Registered User
    Join Date
    09-14-2010
    Location
    Boston
    MS-Off Ver
    Excel 2007
    Posts
    22

    Link a cell to a worksheet, same workbook

    Hi,

    I have a question need you guys help:

    I have a workbook with 6 worksheets name "Master, 1, 2, 3 ,4 ,5"
    In "Master" sheet column A1:A5 have 1 2 3 4 5

    How can i double click on cell A1, it jumps to tab 1, or A2 to tab 2
    Any trick to do so

    Thanks
    Last edited by sweetboy02125; 11-16-2010 at 11:40 AM. Reason: Thanks

  2. #2
    Forum Expert
    Join Date
    10-10-2008
    Location
    Northeast Pennsylvania, USA
    MS-Off Ver
    Excel 2007
    Posts
    2,387

    Re: Link a cell to a worksheet, same workbook

    sweetboy02125,

    With your workbook open, press the F1 key

    type in hyperlink, and press the Enter key

    scroll down and click on Create, select, edit, or delete a hyperlink

    and click on Create a hyperlink to a specific location in a workbook
    Have a great day,
    Stan

    Windows 10, Excel 2007, on a PC.

    If you are satisfied with the solution(s) provided, please mark your thread as Solved by clicking EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1