auto hide unhide in grey rows above how did I manage this

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have 2 grey lines above the grid which if you click on the minus auto hides
columns.
If you click on the plus it auto unhides them.

I did this accidentally how did I do it and how do I undo it
 
1. Click on + to unhide the columns.
2. Select all the columns in the "group"
3. Data->Group and Outline->Ungroup
4. Select "Columns" in the dialog that pops up
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hiding/Unhiding Rows Automatically 1
Automatically hide/unhide rows 5
toolbar "button" for hiding/unhiding sheets 2
Hide Unhide option 1
Hide Rows If Condition True 2
Hide / Unhide each row from StartRow to LastRow for multiple conditions 6
Hide/Unhide with cell double click 4
How do you hide/un-hide the grid lines 3

Back
Top