table w/ some columns as drop down
 

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.

table w/ some columns as drop down
 

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


On Thu, 1 Oct 2009 14:14:13 -0700, purplec0ws
wrote:

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.