Download ArticleDownload ArticleThis article was co-authored by How.com.vn staff writer, Nicole Levine, MFA. Nicole Levine is a Technology Writer and Editor for How.com.vn. She has more than 20 years of experience creating technical documentation and leading support teams at major web hosting and software companies. Nicole also holds an MFA in Creative Writing from Portland State University and teaches composition, fiction-writing, and zine-making at various institutions.
This article has been fact-checked, ensuring the accuracy of any cited facts and confirming the authority of its sources.
This article has been viewed 237,542 times.
Learn more...
This How.com.vn teaches you how to collapse multiple columns in your Microsoft Excel spreadsheet using the “Group” tool.
Steps
Download Article
Open your spreadsheet in Microsoft Excel. You can do this on your Mac or PC by double-clicking the file.[1]
Select the columns you want to collapse. To do this, click the letter above the first column, then drag the mouse to include the second column. Both columns should now be highlighted.[2]- If you don’t want to collapse two entire columns, just select the cells you want to collapse (rather than selecting the column letters).
Advertisement
Click the Data tab. It’s at the top of Excel.
Click Group. It’s near the top-right corner of the screen in the “Outline” group.[3]
Select Columns in the “Group” pop-up and click OK. If you don’t see a “Group” pop-up, just skip to the next step.[4]
Click - to collapse the columns. It’s on the left side of the gray bar above your spreadsheet. The columns will collapse and “-“ will turn to a “+.”
Click + to restore the columns.[5]
Expert Q&A
Video
Tips
References
- ↑ https://support.microsoft.com/en-us/office/open-files-from-the-file-menu-97f087d8-3136-4485-8e86-c5b12a8c4176
- ↑ https://support.microsoft.com/en-au/office/select-cell-contents-in-excel-23f64223-2b6b-453a-8688-248355f10fa9
- ↑ https://support.microsoft.com/en-us/topic/group-or-ungroup-shapes-pictures-or-other-objects-a7374c35-20fe-4e0a-9637-7de7d844724b
- ↑ https://support.microsoft.com/en-au/office/outline-group-data-in-a-worksheet-08ce98c4-0063-4d42-8ac7-8278c49e9aff
- ↑ https://support.microsoft.com/en-au/office/outline-group-data-in-a-worksheet-08ce98c4-0063-4d42-8ac7-8278c49e9aff
About This Article
1.Open your spreadsheet.
2.Select the columns.
3.Click the Data tab.
4.Click Group.
5.Select Columns and click OK.
6.Click – to collapse.
7.Click + to uncollapse.
Is this article up to date?
⚠️ Disclaimer:
Content from Wiki How English language website. Text is available under the Creative Commons Attribution-Share Alike License; additional terms may apply.
Wiki How does not encourage the violation of any laws, and cannot be responsible for any violations of such laws, should you link to this domain, or use, reproduce, or republish the information contained herein.
- - A few of these subjects are frequently censored by educational, governmental, corporate, parental and other filtering schemes.
- - Some articles may contain names, images, artworks or descriptions of events that some cultures restrict access to
- - Please note: Wiki How does not give you opinion about the law, or advice about medical. If you need specific advice (for example, medical, legal, financial or risk management), please seek a professional who is licensed or knowledgeable in that area.
- - Readers should not judge the importance of topics based on their coverage on Wiki How, nor think a topic is important just because it is the subject of a Wiki article.
