Thread: table w/ some columns as drop down
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default 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.

Reply With QuoteReply With Quote