SOLVED

collapsed cells

Copper Contributor

In creating a financial analysis spreadsheet, I grouped the Income Statement, Assumptions, and Analysis each into its own group.  On the left side, I have the + sign and at the top of the column I have the 1 and 2 buttons.  In the development of the spreadsheet, the + sign and - sign were working to collapse and uncollapse the groupings as were the 1 and 2 buttons.  Now, neither the + sign, -sign, or 1 or 2 buttons work.  The groups are currently collapsed.  How do I get them to uncollapsed?  The cells are not locked.  Any assistance would be greatly appreciated.  Thank you!

1 Reply
best response confirmed by Selina (Copper Contributor)
Solution

@Selina 

Select all cells.  Then: Format, Column, Unhide and then Format, Row, Unhide. That should bring everything back.

 

1 best response

Accepted Solutions
best response confirmed by Selina (Copper Contributor)
Solution

@Selina 

Select all cells.  Then: Format, Column, Unhide and then Format, Row, Unhide. That should bring everything back.

 

View solution in original post