+ Reply to Thread
Results 1 to 5 of 5

Need help - Finding hidden formulas

  1. #1
    Registered User
    Join Date
    10-03-2011
    Location
    West of Laramie
    MS-Off Ver
    Excel 2007
    Posts
    12

    Need help - Finding hidden formulas

    In a spreadsheet I have one of the cells that is calculating something only shows the following when I select it:

    =Formulas!AA8

    How do I find that formula? And how do I hide formulas if needed?

  2. #2
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: Need help - Finding hidden formulas

    Regarding: =Formulas!AA8

    That formula is referencing cell AA8 on a sheet named Formulas.
    If you can't see the "Formulas" tab, it is hidden.
    Try this to see it:
    • Home.Format.Hide&Unhide.Unhide_sheet...Select: Formulas

    Does that help?
    Ron
    Former Microsoft MVP - Excel (2006 - 2015)
    Click here to see the Forum Rules

  3. #3
    Registered User
    Join Date
    10-03-2011
    Location
    West of Laramie
    MS-Off Ver
    Excel 2007
    Posts
    12

    Re: Need help - Finding hidden formulas

    I think I know what you mean by 'Home'...but when I select that tab I don't see a 'Format' option.

    When I am on the 'View' tab there is a Hide or Unhide option but the unhide option is greyed out.

  4. #4
    Registered User
    Join Date
    10-03-2011
    Location
    West of Laramie
    MS-Off Ver
    Excel 2007
    Posts
    12

    Re: Need help - Finding hidden formulas

    Woops...I replied too soon. I just found the 'Format' in the 'Cells' group. Then following your instructions I was able to unhide that sheet.

    Thanks! Problem solved

  5. #5
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: Need help - Finding hidden formulas

    The Format button is in the "Cells" section, on the right-hand side of the Home tab of the ribbon.

+ 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