Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Grouping Rows - Want Top Row to Show

9,078 views
Skip to first unread message

sfark...@gmail.com

unread,
Aug 20, 2007, 9:24:14 PM8/20/07
to
I want to use the group and outline functionality to group sets of
rows, but instead of the bottom row of the group showing when I
collapse the group, I want the top row to show. This is because each
of the items below the top row are the elements of the group and the
top row is the header.

Can this be done with the Excel grouping functionality?

Thanks.

Dave Peterson

unread,
Aug 20, 2007, 10:10:52 PM8/20/07
to
Data|Group and Outline|Settings
Uncheck that Summary Rows below detail

--

Dave Peterson

sfark...@gmail.com

unread,
Aug 20, 2007, 11:06:02 PM8/20/07
to
On Aug 20, 7:10 pm, Dave Peterson <peter...@verizonXSPAM.net> wrote:
> Data|Group and Outline|Settings
> Uncheck that Summary Rows below detail
>
> sfarkas2...@gmail.com wrote:
>
> > I want to use the group and outline functionality to group sets of
> > rows, but instead of the bottom row of the group showing when I
> > collapse the group, I want the top row to show. This is because each
> > of the items below the top row are the elements of the group and the
> > top row is the header.
>
> > Can this be done with the Excel grouping functionality?
>
> > Thanks.
>
> --
>
> Dave Peterson

Thanks Dave!

13c...@gmail.com

unread,
Oct 7, 2015, 9:28:43 AM10/7/15
to
helped a lot!!!!

abdul69...@gmail.com

unread,
Sep 8, 2016, 10:21:17 AM9/8/16
to
Thank you Dave !!

jayat...@gmail.com

unread,
Feb 4, 2019, 1:22:13 PM2/4/19
to
Can this be done in Google Sheets also?
-Jay

GS

unread,
Feb 5, 2019, 12:47:43 AM2/5/19
to
> Can this be done in Google Sheets also?
> -Jay

What does the GoogleSheets online help reveal?
--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

irin...@gmail.com

unread,
Jun 19, 2020, 5:50:34 AM6/19/20
to
On Monday, February 4, 2019 at 1:22:13 PM UTC-5, jayat...@gmail.com wrote:
> Can this be done in Google Sheets also?
> -Jay

When you already grouped rows in the Google Sheets, press right mouse button near +/- button and in the context menu select [Move +/- button in the top/bottom].

-Irina

Calvin

unread,
Nov 22, 2023, 2:37:38 PM11/22/23
to
It works! Thanks Irina!
0 new messages