Data Filter

[Jenn]

Is there any way that in Data Filter to have only the alphabet? So when you
click on the arrow and the little screen pops up and shows everything, is
there any way that it only shows A to Z. That way if you click on A only the
company's that start with A will show up and so forth?

[Dave Peterson]

Maybe you could add another column:

=left(a2,1)
and drag down.

then filter by that column.

Jenn wrote:
>
> Is there any way that in Data Filter to have only the alphabet? So when you
> click on the arrow and the little screen pops up and shows everything, is
> there any way that it only shows A to Z. That way if you click on A only the
> company's that start with A will show up and so forth?

--

Dave Peterson

[Jenn]

Thank you, now is there an easier way then doing it one by one. I have the
whole alphabet, and say 20 per letter, now is there a faster way to input the
example: =left(b8) or do i have to do it one by one


"Dave Peterson" wrote:

> Maybe you could add another column:
>
> =left(a2,1)
> and drag down.
>
> then filter by that column.
>
> Jenn wrote:
> >
> > Is there any way that in Data Filter to have only the alphabet? So when you
> > click on the arrow and the little screen pops up and shows everything, is
> > there any way that it only shows A to Z. That way if you click on A only the
> > company's that start with A will show up and so forth?
>
> --
>
> Dave Peterson
>

[Dave Peterson]

You can use the little autofill button on the selected cell outline (bottom
right corner) and drag it as far down the column as you need.

Debra Dalgleish has some instructions with pictures at:
http://contextures.com/xlDataEntry01.html#Mouse

Jenn wrote:
>
> Thank you, now is there an easier way then doing it one by one. I have the
> whole alphabet, and say 20 per letter, now is there a faster way to input the
> example: =left(b8) or do i have to do it one by one
>
> "Dave Peterson" wrote:
>
> > Maybe you could add another column:
> >
> > =left(a2,1)
> > and drag down.
> >
> > then filter by that column.
> >
> > Jenn wrote:
> > >
> > > Is there any way that in Data Filter to have only the alphabet? So when you
> > > click on the arrow and the little screen pops up and shows everything, is
> > > there any way that it only shows A to Z. That way if you click on A only the
> > > company's that start with A will show up and so forth?
> >
> > --
> >
> > Dave Peterson
> >

--

Dave Peterson