How to expand and collapse columns in Excel

[Asaph]

hie,

Is there a way to expand and collapse the columns in Microsoft Excel ? If possible then how ? Please somebody give the relevant information or ideas about this feature....

thanks

[Glenny]

Use the following code according to your needs and check whether you can implement the required feature.

Sub HideG_UnhideG()  
  
If Columns("c:j").EntireColumn.Hidden = True Then  
   Columns("c:j").EntireColumn.Hidden = False  
   ActiveSheet.Shapes("toggleit").TextFrame.Characters.Text = _  "HIDE"  
Else  
  Columns("c:j").EntireColumn.Hidden = True  
  ActiveSheet.Shapes("Toggleit").TextFrame.Characters.Text = _  "SHOW"  
End If  
  
 'can use =not if only ONE change.....  
 'Columns("g").EntireColumn.Hidden = Not Columns("g").EntireColumn.Hidden  
  
End Sub

[JonathanD]

You don't need VBA at all for this. You just need to use an Excel function called Group and Outline facility.
You can find this facility in the Data menu.

[Macarenas]

Try this :
- Select the columns you want to be expanded/collapsed
- Data > Group and Outline > Group

[pracash]

hi

can any one guide me how to solve the date format in csv file.

in excel 2010-08-30 or 2010/08/30 suppots but when i converting into csv file it won't accepts.

in csv 2010-08-30 not supports. can any one solve my problem

i am looking for solution.

[Abenaki]

Microsoft has released a hot fix for that. This is a common issue with most of the user where you date format changes when you export or import data in csv. This issue is applicable to Microsoft Excel. For that go to below link and read some fixing solutions. This might help you or else you can download the hotfix and install the same. This is a vba issue.
CSV Hotfix