register
 
 
computer

What control key do you use in Excel to collapse columns?

I need to collapse columns in Excel, everything I have tried has not worked.

asked by thurston81 (70)

You have 50 words left!
 
 
related questions

How can I collapse rows in excel?

How can I convert columns into row in Excel?

How could my car audio be on with no key inside?

How do I separate a CSV file into multiple Excel columns?

How do you make a new line character in a Microsoft Excel cell?

How do you perform remedial repair of rotting wood columns?

How do you set auto width's of your columns in excel?

Tags:  computer  software

answers

1) Select the columns or rows to be hidden, right click on the numbers and hit Hide. 2) Or, after selecting, click Data -> Group.

reply
posted by Benjamin (67)
6 votes

Use Y Control Key (Ctr l + Y) to collapse column;First select the Columns whichever needs to be collapsed , and then use Control Key with Y. The selected columns will be deleted. If you are deleting the columns,other columns automatically shifts up or to the left.

6 votes

on ribbon menus do the double click. select row and column by select data then group and outline then select the column to collapse the press control key with c that is collapse if you press ctrl + x means expand. when the group is expand then click anywhere to collapse.

3 votes

Report a post on this page as inappropriate
 If you have questions about user content, read our liability disclaimer

  
   
Add your own answer in 50 words or less! Add your comment in 50 words or less!

copyright © 2008 - 2010
conjecture corporation

FAQ About Us Contact Us Terms & Conditions Privacy Policy