I have one table to put in one scpreadsheet.
Because it has 3 different categories, for visual purpose, I put one empty
columns between them.
After I put empty columns to seperate them the auto filter dropdown box
works individually which does not synchronize other 2 categories.
Are there any workaround for this?
Does Excel auto filter support in different categories in one spreadsheet?
Your information is great appreicated,
Stefi - 23 Jan 2008 14:26 GMT
If you have a header in row 1, enter a header text also in the empty columns!
Regards,
Stefi
„Souris” ezt írta:
> I have one table to put in one scpreadsheet.
> Because it has 3 different categories, for visual purpose, I put one empty
[quoted text clipped - 7 lines]
>
> Your information is great appreicated,