Coming soon
Search
-
QuestionHow do I reverse the grouping so that the total is at the top line and the collapsed lines fall below?
Community AnswerClick the "Data" tab, then come to the "Outline" section, then click the small arrow on the right bottom corner to "Show the Outline Dialog Box". From the settings, unclick "Summary Rows Below Detail." -
QuestionMy data is grouped, but I cannot see the outline symbols along the left side of my spreadsheet. What can I do?
Community AnswerWhile the document is open, go to "File," "Options," "Advanced," "Display options for this worksheet." Make sure "Show outline symbols if an outline is applied" is selected. This is necessary for every sheet where there are outlines/groupings applied. -
QuestionHow do I group Rows 23 through 31 and then group Rows 32 through 36? When I do it, Excel groups Rows 23 thru 36.
Community AnswerYou need an empty row between your two groups. Otherwise Excel will automatically merge them.
-
QuestionHow do I add two columns in Excel?
Community AnswerSelect the heading letters of two columns and right-click on one of them. Then select "Insert" from the right-click options. The new columns will be added to the left of the selected columns.
-
QuestionHow do I collapse or expand only those groups in Excel that have a certain characteristic in one of their rows? (Example: Expand or collapse all groups with a red row).
Community AnswerWrite a macro that determines if the cell color is red. Then place an asterisk or other sortable value into an extra column. Sort that column, then collapse based on that sort.
Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit
