Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Placement of autofilter drop down menu?
That can depend on a few things. If you have a range selected, the
drop-downs will be in that range. If you have blank columns, the filter drop-downs will not appear across those. If you are in a blank column, you will get the error below... Truly, the easiest thign to do is highlight Row 1 and add your filter that way. This way, you don't get your error, and all filters will appear in Row 1 "LesleyS" wrote: 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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Placement of autofilter drop down menu?
Thanks highlighting row 1 is certainly easier!
The error message still come up though even though cursor is placed in a non balnk column. "Sean Timmons" wrote: That can depend on a few things. If you have a range selected, the drop-downs will be in that range. If you have blank columns, the filter drop-downs will not appear across those. If you are in a blank column, you will get the error below... Truly, the easiest thign to do is highlight Row 1 and add your filter that way. This way, you don't get your error, and all filters will appear in Row 1 "LesleyS" wrote: 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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Placement of autofilter drop down menu?
Really! and you are in a non-blank cell?
"LesleyS" wrote: Thanks highlighting row 1 is certainly easier! The error message still come up though even though cursor is placed in a non balnk column. "Sean Timmons" wrote: That can depend on a few things. If you have a range selected, the drop-downs will be in that range. If you have blank columns, the filter drop-downs will not appear across those. If you are in a blank column, you will get the error below... Truly, the easiest thign to do is highlight Row 1 and add your filter that way. This way, you don't get your error, and all filters will appear in Row 1 "LesleyS" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Placement of cursor in drop dwn menu | New Users to Excel | |||
Drop dwn menu. Formula to count selection frm menu in anoth cell? | Excel Worksheet Functions | |||
filter dropdown menu so 2nd drop menu is customized | Excel Worksheet Functions | |||
Autofilter with drop down menu | Excel Worksheet Functions | |||
Cross-referenced drop-down menu (nested drop-downs?) | Excel Worksheet Functions |