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?
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?
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?
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.
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
The Format button is in the "Cells" section, on the right-hand side of the Home tab of the ribbon.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks