Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 9
Default Filter drop-down is not visible

Why does it disappear when I leave the cell (a1, b1, etc.) And how can I
resolve this?
  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 22,906
Default Filter drop-down is not visible

Are you sure the arrows are Autofilter arrows?

Maybe they are Data Validation dropdowns which only show when you select the
cell with the DV dropdown.

If the latter you cannot resolve it.

Color the cells with DV lists or overlay the cell with a small drawing object to
make it visually findable.

If Autofilter dropdown arrows, I cannot replicate the problem.


Gord Dibben MS Excel MVP

On Thu, 16 Aug 2007 18:11:32 -0700, Determined07
wrote:

Why does it disappear when I leave the cell (a1, b1, etc.) And how can I
resolve this?


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sumif for Visible range when using filter anshu[_2_] Excel Discussion (Misc queries) 4 July 20th 07 08:15 AM
how do i make all choices in a drop down box visible taidoggy Excel Discussion (Misc queries) 1 October 11th 06 02:48 PM
No. of rows selected from auto filter not visible on toolbar? Asif Akbar Excel Discussion (Misc queries) 2 September 22nd 06 01:05 PM
how do i select all the visible cells only when using auto filter shaurabh Excel Discussion (Misc queries) 4 June 25th 06 07:32 AM
Return the first visible cell below filter labels REDQUAD Excel Worksheet Functions 0 February 13th 06 03:11 PM


All times are GMT +1. The time now is 02:36 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"