Results 1 to 5 of 5

Thread: How can i go to Specific tab in Excel on Windows Vista

  1. #1
    Join Date
    Apr 2009
    Posts
    97

    How can i go to Specific tab in Excel on Windows Vista

    I'm running Windows Vista along with Microsoft Office 2003 on my pc. I'm having a 309 sheets on my pc. So. i would like to know that how do i create a button on each sheet, in order to bring back to sheet 1 when i try to click on it. Is it possible for me to do so? Kindly provide me the solution for the above issue. Any kind of help on teh above issue would eb appreciated.

  2. #2
    Join Date
    May 2008
    Posts
    4,834

    Re: How can i go to Specific tab in Excel on Windows Vista

    For tha you need to right-click the sheet navigation buttons which you can see it on the left of the sheet tabs. If there are more worksheets than can comfortably fit in the list, then one of the options is "More Sheets." Select that option, and you end up with a dialog box that lists all the worksheets and you can make your selection.

  3. #3
    Join Date
    Apr 2008
    Posts
    4,089

    Re: How can i go to Specific tab in Excel on Windows Vista

    You need to set the Value property of the multipage on your excel sheet. You need to know that the page number are zero based. Following is the code, might help you out.

    Private Sub UserForm_Initialize()

    MultiPage1.Value = 1 ' tab 2

    End Sub

  4. #4
    Join Date
    Jan 2008
    Posts
    3,758

    Re: How can i go to Specific tab in Excel on Windows Vista

    You can also try out the following steps.

    1. You need to Press F5 key. Then Excel will displays a dialog box on your desktop screen.
    2. Then on the Reference box, you need to enter any sheet number, let say for example Sheet83!A1. ( Try to replace "Sheet83" with the name of the worksheet that you want to jump to.)
    3. And last you need to click on OK tab.

  5. #5
    Join Date
    Mar 2011
    Posts
    1

    Re: How can i go to Specific tab in Excel on Windows Vista

    Sam.D is correct, except for when you're naming your tabs with more than one word. For example, if you're tab is named "Worksheet Number One", press F5 and type in 'Worksheet Number One'!A1. One-word tab names don't require an apostrophe ('), but two word tabs must have them!!

Similar Threads

  1. Is there a Excel add-in to open specific number of file
    By Ichabod in forum MS Office Support
    Replies: 2
    Last Post: 27-01-2012, 07:06 PM
  2. Formula to count the occurrences of specific letter in excel
    By Mithun Seth in forum Windows Software
    Replies: 5
    Last Post: 09-01-2010, 12:03 PM
  3. Excel Password Issue on Windows Vista
    By Sori in forum Windows Software
    Replies: 4
    Last Post: 04-01-2010, 12:44 PM
  4. How to create excel graph data for a month in Windows Vista
    By AK_Chopra in forum Windows Software
    Replies: 2
    Last Post: 04-06-2009, 07:58 PM
  5. Uninstall Microsoft Excel 97 from Windows Vista
    By dj928 in forum Operating Systems
    Replies: 6
    Last Post: 16-03-2009, 10:48 AM

Posting Permissions

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