Excel 2013: Is it possible to collapse rows only in a specific column?

Posted by h7u9i on Super User See other posts from Super User or by h7u9i
Published on 2014-05-28T03:17:29Z Indexed on 2014/05/28 3:33 UTC
Read the original article Hit count: 431

Filed under:

microsoft-excel

|

microsoft-excel-2013

In my spreadsheet, I'm trying to figure out a way to collapse rows in a specific column.

Right now, if I do Data -> Group -> Group... -> Rows, it'll collapse the entire row. I want to collapse rows only in a specific column.

Example:

|---------|----------|
|  hi     |  + data  |
|---------|----------|
|  hello  |  + data2 |
|---------|----------|
|         |          |
|---------|----------|
|         |          |

And opening data 1 would turn into:

|---------|----------|
|  hi     | - data1  |
|---------|----------|
|  hello  | point1   |
|---------|----------|
|         | point2   |
|---------|----------|
|         | + data2  |
|---------|----------|
|         |          |
|---------|----------|
|         |          |

Is this possible to do in Excel?

© Super User or respective owner

Related posts about microsoft-excel

Connecting to Microsoft Excel using Oracle Data Integrator

as seen on Oracle Blogs - Search for 'Oracle Blogs'
The posts in this series assume that you have some level of familiarity with ODI. The concepts of Topology, Data Server, Physical and Logical Architecture are used here assuming that you understand them in the context of ODI. If you need more details on these elements, please refer to the ODI Tutorial… >>> More
Connect Microsoft Excel To SQL Azure Database

as seen on Dot net Slackers - Search for 'Dot net Slackers'
A number of people have found my post about getting started with SQL Azure pretty useful. But, it's all worthless if it doesn't add up to user value. Database are like potential energy in physics-it's a promise that something could be put in motion. Users actually making decisions based on analysis… >>> More
How to code Microsoft Excel "Shift Cells Up" feature in SQL

as seen on Stack Overflow - Search for 'Stack Overflow'
Take a simple table like below: Column Headings: || Agent's Name || Time Logged In || Center || Row 1: Andrew || 12:30 PM || Home Base Row 2: Jeff || 7:00 AM || Virtual Base Row 3: Ryan || 6:30 PM || Test Base Now lets say that a single cell is deleted so the table now looks like this: Column… >>> More
a question on using Microsoft Excel to do data analysis

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello everyone there, Me and my mates have been given an Excel spreasheet,which contains the data of the Census report. The column here corresponds to "Year" (from 2000-2010),the row means "City/Town",the cell is simply the population of a town at a particular year. We are up to doing some analysis… >>> More
Working with PivotTables in Excel

as seen on How to geek - Search for 'How to geek'
PivotTables are one of the most powerful features of Microsoft Excel. They allow large amounts of data to be analyzed and summarized in just a few mouse clicks. In this article, we explore PivotTables, understand what they are, and learn how to create and customize them. Note: This article… >>> More

Related posts about microsoft-excel-2013

How to Add the Windows Calculator to the Quick Access Toolbar in Microsoft Excel 2013

as seen on How to geek - Search for 'How to geek'
Do you use the Windows Calculator to perform quick calculations while building spreadsheets in Excel? You can save time by adding the Calculator to the Quick Access Toolbar in Excel so you don’t have to leave the program to access the Calculator. To do this, click the down arrow on the right side… >>> More
Microsoft Excel 2013

as seen on Super User - Search for 'Super User'
We use a spreadsheet as our timecards. The template is stores on the server with links to it on the individual Desktops. I am trying to figgure out the VB so that wnen the cell for username (B5) is blank, the VB will place next sundays date in (B7). After the user enters thier name in B5, I need… >>> More
How to fill sequence in Excel from ranges given in another sheets?

as seen on Super User - Search for 'Super User'
I have an Excel sheet where two columns (say J and K) among data in sheet1 are as follows: J ------------ K 1 ----------- 25 26 --------- 50 101 ------ 150 Which are some ranges. I have another sheet where I have column (let's say I), which I want to update it to have the values… >>> More
Why is Excel 2010/2013 taking 10 seconds open any file?

as seen on Super User - Search for 'Super User'
I have a fast Windows 7 PC with two SSDs and 16GB of RAM, so I'm used to programs loading very fast. But recently, for no reason I can figure out, Excel has started taking way too long to open Excel files (of any size--even blank files). This is occurring with Excel 2010 and with Excel 2013 after… >>> More
Excel 2013: Is it possible to collapse rows only in a specific column?

as seen on Super User - Search for 'Super User'
In my spreadsheet, I'm trying to figure out a way to collapse rows in a specific column. Right now, if I do Data - Group - Group... - Rows, it'll collapse the entire row. I want to collapse rows only in a specific column. Example: |---------|----------| | hi | + data | |---------|----------| |… >>> More