View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
BoniM BoniM is offline
external usenet poster
 
Posts: 353
Default Auto Filter in EXCEL 2007

Not that I know of... which doesn't mean there isn't one... however, just
FYI, when you first open the list, while everything is still checked,
clicking the select all option will uncheck everything - making it easier to
select the one you want instead of having to uncheck all the ones you don't.

"Pramod Mehta" wrote:

hi all,
as in excel 2003 while using auto filter in a particular column we get the
drop down list box and the user has the choice of selecting and one from teh
whole list, but in excel 2007 while using auto filter option we get the drop
down list box with a checkbox prior to it allowing the user to select
multiple rows in the filter.

can the auto filter in teh excel 2007 can be modiifed to display teh data as
in the form of excel 2003 (ie without the check boxes in front of the list)