Solved what-if anaylsis trouble shooting in excel

November 1, 2013 at 15:52:04
Specs: Windows 7
when I select a cell that I want to do a what-if analysis on, the what-if analysis is not 'highlighted' so I can not select it. any reason why?

See More: what-if anaylsis trouble shooting in excel

Report •


#1
November 1, 2013 at 16:22:38
✔ Best Answer
Is the sheet protected?
On the Ribbon select the Review Tab, check to see if the sheet is protected.

Do you have multiple sheets grouped?
On the very top of the work sheet, where the sheet name is located, does it
also say [Group]?
Select the Sheet Tab, Right Click, select Ungroup

MIKE

http://www.skeptic.com/


Report •
Related Solutions


Ask Question