+ Reply to Thread
Results 1 to 3 of 3

Excel 2007 : Navigating Worksheets

  1. #1
    Registered User
    Join Date
    08-19-2008
    Location
    Auckland, NZ
    MS-Off Ver
    2016
    Posts
    67

    Navigating Worksheets

    Hi, I have a workbook with a lot of data spread over three worksheets. I want to direct users of my workbook to specific cells, possibly on different worksheets - how do I do this? For example if a user is on cell c7 and I want to get them straight to cell AG84 or to Sheet2, cell R205 - how can I do this please? Many thanks in advance.
    Last edited by whitepaw; 05-12-2011 at 06:58 AM.

  2. #2
    Forum Expert tigeravatar's Avatar
    Join Date
    03-25-2011
    Location
    Colorado, USA
    MS-Off Ver
    Excel 2003 - 2013
    Posts
    5,361

    Re: Navigating Worksheets

    whitepaw,

    To jump to specific sheets/cells within the same workbook, you can use hyperlinks.

    Hope that helps,
    ~tigeravatar

  3. #3
    Registered User
    Join Date
    08-19-2008
    Location
    Auckland, NZ
    MS-Off Ver
    2016
    Posts
    67

    Re: Navigating Worksheets

    Many thanks - that has fixed my problem.

+ 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