---
title: "how to collapse and expand rows in excel 2010"  
description: "how to collapse and expand rows in excel 2010"  
author: "Anonymous User"  
published: 2013-04-01  
updated: 2013-04-01  
canonical: https://www.mindstick.com/forum/686/how-to-collapse-and-expand-rows-in-excel-2010  
category: "ms access"  
tags: ["ms access"]  
reading_time: 1 minute  

---

# how to collapse and expand rows in excel 2010

Hi Everyone!

I have working on [Excel sheet](https://www.mindstick.com/forum/23040/to-import-excel-sheet-into-sql-database) 2010 with [large data](https://www.mindstick.com/interview/872/how-do-you-load-large-data-to-the-sqlserver-database). I want to collapse and [expand](https://www.mindstick.com/articles/13054/here-s-how-crm-can-help-you-expand-your-business) rows for making stylish work sheet.\
Please help me!

Thank in [advance](https://www.mindstick.com/blog/33258/jee-mains-and-jee-advance-exams)?

## Replies

### Reply by AVADHESH PATEL

Hi Ezra!

Select the row and go to **"Group"** option with row selection under **"Data Menu" option.**


---

Original Source: https://www.mindstick.com/forum/686/how-to-collapse-and-expand-rows-in-excel-2010

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.