HI

I have a worksheet of 650 rows.

Certain of the rows are highlighted in green.

How can I group the highlighted rows at the top of the sheet?


Grateful for any advice.



Best Wishes

In an adjacent column you can add a code (like G for green) against
each of those highlighted cells. Then if you want to filter it (which
is what your heading suggested) you can apply a filter to this helper
column. If you want to group those highlighted cells together, then
you can sort the data plus the helper column, using the helper column
as the sort key, and then all the G's will be bunched together, with
the blank cells below.

Hope this helps.

Pete

On Sep 25, 1:06*am, Colin Hayes <Co...@chayes.demon.co.uk> wrote:
> HI
>
> I have a worksheet of 650 rows.
>
> Certain of the rows are highlighted in green.
>
> How can I group the highlighted rows at the top of the sheet?
>
> Grateful for any advice.
>
> Best Wishes

Check this out:
http://www.cpearson.com/excel/SortByColor.htm

regards,
Ryan--


--
RyGuy


"Pete_UK" wrote:

> In an adjacent column you can add a code (like G for green) against
> each of those highlighted cells. Then if you want to filter it (which
> is what your heading suggested) you can apply a filter to this helper
> column. If you want to group those highlighted cells together, then
> you can sort the data plus the helper column, using the helper column
> as the sort key, and then all the G's will be bunched together, with
> the blank cells below.
>
> Hope this helps.
>
> Pete
>
> On Sep 25, 1:06 am, Colin Hayes <Co...@chayes.demon.co.uk> wrote:
> > HI
> >
> > I have a worksheet of 650 rows.
> >
> > Certain of the rows are highlighted in green.
> >
> > How can I group the highlighted rows at the top of the sheet?
> >
> > Grateful for any advice.
> >
> > Best Wishes
>
>

Also Excel 2007 has that ability using autofilter


--


Regards,


Peo Sjoblom



"ryguy7272" <(E-Mail Removed)> wrote in message
news:00B7DEEF-7BC1-4089-AF92-(E-Mail Removed)...
> Check this out:
> http://www.cpearson.com/excel/SortByColor.htm
>
> regards,
> Ryan--
>
>
> --
> RyGuy
>
>
> "Pete_UK" wrote:
>
>> In an adjacent column you can add a code (like G for green) against
>> each of those highlighted cells. Then if you want to filter it (which
>> is what your heading suggested) you can apply a filter to this helper
>> column. If you want to group those highlighted cells together, then
>> you can sort the data plus the helper column, using the helper column
>> as the sort key, and then all the G's will be bunched together, with
>> the blank cells below.
>>
>> Hope this helps.
>>
>> Pete
>>
>> On Sep 25, 1:06 am, Colin Hayes <Co...@chayes.demon.co.uk> wrote:
>> > HI
>> >
>> > I have a worksheet of 650 rows.
>> >
>> > Certain of the rows are highlighted in green.
>> >
>> > How can I group the highlighted rows at the top of the sheet?
>> >
>> > Grateful for any advice.
>> >
>> > Best Wishes
>>
>>

As well as using Sort.

Bob Umlas

"Peo Sjoblom" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Also Excel 2007 has that ability using autofilter
>
>
> --
>
>
> Regards,
>
>
> Peo Sjoblom
>
>
>
> "ryguy7272" <(E-Mail Removed)> wrote in message
> news:00B7DEEF-7BC1-4089-AF92-(E-Mail Removed)...
>> Check this out:
>> http://www.cpearson.com/excel/SortByColor.htm
>>
>> regards,
>> Ryan--
>>
>>
>> --
>> RyGuy
>>
>>
>> "Pete_UK" wrote:
>>
>>> In an adjacent column you can add a code (like G for green) against
>>> each of those highlighted cells. Then if you want to filter it (which
>>> is what your heading suggested) you can apply a filter to this helper
>>> column. If you want to group those highlighted cells together, then
>>> you can sort the data plus the helper column, using the helper column
>>> as the sort key, and then all the G's will be bunched together, with
>>> the blank cells below.
>>>
>>> Hope this helps.
>>>
>>> Pete
>>>
>>> On Sep 25, 1:06 am, Colin Hayes <Co...@chayes.demon.co.uk> wrote:
>>> > HI
>>> >
>>> > I have a worksheet of 650 rows.
>>> >
>>> > Certain of the rows are highlighted in green.
>>> >
>>> > How can I group the highlighted rows at the top of the sheet?
>>> >
>>> > Grateful for any advice.
>>> >
>>> > Best Wishes
>>>
>>>
>
>