View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
LesleyS LesleyS is offline
external usenet poster
 
Posts: 2
Default Placement of autofilter drop down menu?

Hi
When I apply autofilter (Excel 2003) it doesn't always place the autofilter
drop down menu in the header row - the placements appears to be random and
doesn't always extend to all columns. Why is this?

Also, sometimes the following message appears when applying autofilter -
"The command could not be completed by using the range specified. Select a
single cell within the range and try the command again" - despite having
selected a single cell within the data range. Does anyone know why this is
happening?