group and outline

I have a spreadsheet that have pay period dates, that run from V5 to AT5. We have the past pay months within 1 month grouped together and the future months within 1 month grouped together. For instance this month is August, so all the columns with dates in July, August, and September are not...

I have 2 different Groups of columns. Is it possible to quickly select a Grouped Columns at once. Thanks for reading. Please reply.

Hi, When you group rows/columns you get a summary within the grey side-bar at the top/left of the screen. I find this summary very annoying as it takes up too much of the screen. Is there a way rto remove the summary or to make it only one level? If you don't know what I mean I put a picture...

Hi All, I am running a filter with a bunch of groups for my PnL. The challenge is that I have a column that lets me know that a particular row has no values and to reflect "H" (Hide) or "K" (Keep). So when I use the filter it hides the empty rows for that particular PnL. Its a template so these...

Hi all, I was just looking up on Group and Ungroup functions of the Outline tools in Excel, and I wondered if the Pivot Table is able to do what both of them do. So my question is: What is the main difference of the two? What can one do and the other cannot? In what circumstance would you use...

Hi I am trying to find a way to automatically outline a hierarchy in Excel (group rows) I cannot find a code to do that either For example: <tbody> Code Item Rollup 1 A Title 1.1 B Subtitle Level 1 1.1.1 C Compare 1.2 D Subtitle Level 1 1.2.1 E Subtitle Level 2 1.2.1.1 F Compare...

Hi all, How do I sort within an outline group? I have a set of data grouped by country, and would like to sort both levels of data by the same column. Using a regular sort function just sorts the country level, and doesn't sort items within. How would I do this without using VBA? Seems like...

Hi, I have a document which redirects users from a "front sheet" to the sheets behind that via hyperlinked objects. The place they are hyperlinked to are hidden grouped empty data sheets. When the user clicks on a hyperlinked object to go to a data sheet, I want the sheet to automatically show...

Hello,Is it possible to show the "+" and "-" signs WITHIN the main cell(of the worksheet, not a pivot table) rather than the signs showing in a bar to the left of the column when grouped?

I have Excel 2013. When I group columns together, I don't see the "+" sign at the top to expand/collapse the grouping. What's going on?

I am hoping some can help me with code to create a group/outline structure to show the different levels (parent/child relationship) on a Bill of Material. I am able to do this manually, but it is rather time consuming when there are 1000's of items in the Bill of Material. The list I am working...

I have a very large spreadsheet with several groups of rows. The level 1 row in each group contains location data for a cable. The level 2 children rows contain details for that cable. When I filter the spreadsheet based on a location, all of the cables that have that location are visible but...

I want to group columns in excel with the main column to the left, not right (as is the default). According to other posts, this can be done through the Outline Dialog Box Launcher... but mine is greyed out Dialog Box Launchers seem to work just fine everywhere else they appear in the standard...

I have a workbook with 12 worksheets. The sheets already have a few grouped columns and rows I want to write a macro that will group/ungroup only certain columns (ex. columns T-V and rows 5-8) but not all of the rest of the grouped columsn/rows. Lastly, I want this macro to repeat this command...

Hi Friends, Basically, I am looking for a macro code which would help me to group the rows based on the cell content in the column A. I have a spreadsheet which have country names in column A and data in others columns, I want to group all the countries based on its sub areas. I have to repeat...