table w/ some columns as drop down

[purplec0ws]

How can a create a table where only some of the columns have drop down menus
(i have 10 columns but i only want 3 random columns to be able to sort/filter
the table)? I want to make sure the entire rows are rearranged when I
filter, not just the cells in the particular column.

 

[Gord Dibben]

Have a look at Debra Dalgeish's VBA method for hiding filter arrrows on some
columns.

http://www.contextures.on.ca/xlautofilter03.html#Hide

Entire rows are rearranged when you filter on one of the columns with an
arrow.


Gord Dibben MS Excel MVP