Prev: vlookup + if formula help!
Next: z-order of various lines and bars in an Excel 2007 chart
From: Gord Dibben on 2 Apr 2010 14:32
I agree.

The extra click needed to "de-select" all is a pain.

I don't know of a way to change that default.


Gord

On Fri, 2 Apr 2010 10:41:01 -0700, Bermie <Bermie(a)discussions.microsoft.com>
wrote:

>I hadn't noticed the ? before, thanks.
>
>The problem is, even if it's an autofilter, it still increases the steps
>needed to filter/select certain criteria by at least one step--
>previously, i could select variable X to display only those values, then
>variable Y to display only those, etc...
>Now, I have to de-select select all, then I have to select variable X, then
>I have to de-select variable X and select variable Y. Is there a way to
>select variables quickler, like before? (In excel 2003, there were no
>checkboxes, you only selected a variable from the list).
>
>"Gord Dibben" wrote:
>
>> After all the ranting you get to the part where you have your functions
>> mixed up.
>>
>> > in Excel 2003, I could easily do
>> >this by selecting data validation and "list," it would generate a drop-down
>> >of items below, with the options in the drop-down being "sort ascending, sort
>> >descending, top 10, custom, x, y, z, etc, etc, etc"
>>
>>
>> You are describing Data>Filter>Autofilter.
>>
>> NOT a Data Validation dropdown list.
>>
>> 2007 has exactly the same function.
>>
>> Look under Data Tab and hit "Filter"
>>
>> As far as Help goes, do you not see the question mark(?) in the blue circle
>> at top right of Ribbon?
>>
>>
>> Gord Dibben MS Excel MVP
>>
>> On Fri, 2 Apr 2010 09:13:01 -0700, Bermie <Bermie(a)discussions.microsoft.com>
>> wrote:
>>
>>
>> .
>>

First  |  Prev  | 
Pages: 1 2
Prev: vlookup + if formula help!
Next: z-order of various lines and bars in an Excel 2007 chart