Alphabetical Grouping

[Guest]

I have a list that is sorted alphabetically. Is it possible in Excel to make
an outline where you have A-Z tabs instead of 1, 2, 3... so that you can just
see the first company beginning with A and not the next 10 and then first
company beginning with B etc. Thanks.

 

[Bryan Hessey]

Assuming your names start in A2, with a header row etc.
You could insert a 1 character wide column before the names, and in
(the new) cell A2 insert the formula

=IF(LEFT(B2,1)=LEFT(B1,1),"","F")

Make the column font white-on-white to hide the data, and Data, Filter,
Auto-Filter. Selecting 'F' will give you the first of a group.

Note, if you have no header row you will either have to inser one or
type the letter 'F' into A1.

--