register
 
 
how to

How can I collapse rows in excel?

asked by MattMoss (25)

You have 50 words left!
 
 
related questions

How can I force a hard return in Excel?

How do I merge rows in excel?

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

In Excel, how do I highlight rows containing any of a range of values?

What are "corn rows"?

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

Why using Oracle SQL, how do I delete duplicate rows?

Tags:  how to  software

answers

Using the group function collapse up or down. Highlight rows to collapse, go to Data/Group/Group. It will group assuming total is down unless you uncheck settings in Data/Group/Settings to have it assume total is at top of data set.

reply
posted by Anonymous  
8 votes

Or... selecting the rows then Ctrl + 9 to hide and Ctrl+Shft+9 to expand works too.

reply
posted by iyuilt (9)
6 votes

Keep rows or columns in an Excel file and reduce the information on screen by picking the cell at the top of the column or front of the row and going to the "Window" drop down list and select "Hide". To get the data back in view, select "Unhide".

6 votes

To collapse rows in excel you can the merge function. to use the merge function select the rows you want to collapse the right click on the cells There is a function called format cell in the format window there is atab called Alignment check the merge rows will collapsed

reply
posted by jacky (18)
6 votes

The first step to collapsing rows is to highlight all the rows you want collapsed by clicking on the first row number to be collapsed and dragging to the last. Next, click on Format-Row-Height. In the box that appears, set the value to 0 and click OK.

reply
posted by btw8211 (15)
6 votes

Just use your cursor to highlight the rows you want to collapse. If you are doing multiple rows you will need to hold down your CNTL button and click to highlight them. On your toolbar, go to format, then row, and then hide.

4 votes

Are you trying to group and outline? Select the rows you want to collapse, then Data>Group & Outline>Group. You will have a + or - button dipslayed on the left of the screen where your rows are to toggle your rows.

reply
posted by iyuilt (9)
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