Prev: The picture is too large and will be truncated."-excel Warning
Next: Named range error
From: ichirus on 5 Apr 2010 12:57
Once was able to filter by color but option is no longer available on the
drop down menu
From: "David Biddulph" groups [at] on 5 Apr 2010 13:30
Such an ability isn't built in to Excel. If you did it in the past, it must
have been through some add-in or UDF.
--
David Biddulph


"ichirus" <ichirus(a)discussions.microsoft.com> wrote in message
news:D5255095-2BF8-45D7-99D2-7B5F3D67B5C9(a)microsoft.com...
> Once was able to filter by color but option is no longer available on the
> drop down menu


From: Dave Peterson on 5 Apr 2010 14:16
Are you using xl2007?

Maybe you used xl2007 at work/home and a previous version at home/work???

Or maybe you used Ron de Bruin's easyfilter addin?
http://www.rondebruin.nl/easyfilter.htm

ichirus wrote:
>
> Once was able to filter by color but option is no longer available on the
> drop down menu

--

Dave Peterson
From: Gord Dibben on 6 Apr 2010 12:41
Excel 2007 has it built-in David.

Both sort by color and filter by color.


Gord

On Mon, 5 Apr 2010 18:30:04 +0100, "David Biddulph" <groups [at]
biddulph.org.uk> wrote:

>Such an ability isn't built in to Excel. If you did it in the past, it must
>have been through some add-in or UDF.

From: "David Biddulph" groups [at] on 6 Apr 2010 14:45
Well, that emphasises how much I've got to learn about 2007. Thanks for the
enlightenment, Gord.
--
David Biddulph


"Gord Dibben" <gorddibbATshawDOTca> wrote in message
news:qtomr5ptshvv01vtu1s03k7m61boitvgeu(a)4ax.com...
> Excel 2007 has it built-in David.
>
> Both sort by color and filter by color.
>
>
> Gord
>
> On Mon, 5 Apr 2010 18:30:04 +0100, "David Biddulph" <groups [at]
> biddulph.org.uk> wrote:
>
>>Such an ability isn't built in to Excel. If you did it in the past, it
>>must
>>have been through some add-in or UDF.
>

 |  Next  |  Last
Pages: 1 2
Prev: The picture is too large and will be truncated."-excel Warning
Next: Named range error