Re: "Insert Function" pop-up in Excel 2003, has anyone figured out

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

A tiny bit of one-off preparation:

Right-click the menu bar. Choose Customize.
Choose the Command tab. In the left box, select "Insert", in the right box,
choose the "=" sign and drag it to your menu bar.

Now you have a "=" button which does what the old one used to do.

--
Kind regards,

Niek Otten


"Incoherent" <Incoherent@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:E8FE42D3-3762-4EC8-B8ED-A9CEED009025@xxxxxxxxxxxxxxxx
>I know that.
> It is not what I want.
> I want to be able to e.g. click "=", click the cell I want to reference,
> enter, double click the lower right corner to drag down the whole 4096 row
> column, done.
> The only keyboard entry being <Enter>, 2cm from my right index finger.
>
> I am not looking for other ways to do things, I am looking for the way to
> do
> things the fastest way I can. When I do this hundreds of times a day those
> extra two keyboard clicks I need to manually enter "=" slow me down and
> disrupt the flow.
> Of course I can get used to it but I don't think that's the point.
> Something
> in the software has changed, it slows me down and I don't like it. :(
>
> :)
>
> The pivot table thing is even worse. It requires that I manually enter
> "=",
> find the cell I want and enter it's coordinates. Or drag so it references
> a
> range eg A3:A4 (not subject to the GETPIVOTDATA curse) and manually remove
> the ":A4" from "=A3:A4" that is now there. This has me thumping the
> keyboard
> in utter frustration everytime it occurs, very often with what I am doing.
>
> So. Can I change this behaviour? Or must I change mine?
>
>
>
>
> "Niek Otten" wrote:
>
>> Instead of clicking the Insert function button, just type "=" and the
>> rest
>> of your formula, like you did in Excel2K
>>
>> --
>> Kind regards,
>>
>> Niek Otten
>>
>> "Incoherent" <Incoherent@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:1B1471B0-042D-48A3-AF27-5FC91D328AED@xxxxxxxxxxxxxxxx
>> > ...how to disable this yet?
>> > Also when I try to reference a single pivot table cell it is defaulting
>> > to
>> > something like
>> > =GETPIVOTDATA("Gradient",$A$3,"Focus",100,"col",2,"row",2,"xpos",7680,"ypos",7800)
>> > instead of a the simple relative reference =A3. This is ludicrous and
>> > is
>> > driving me nuts. Can I change it?
>> >
>> > Most of the other features are fine, some even really good. But when
>> > they
>> > muck around with the fundamental interface (removing the "=" and
>> > replacing
>> > it
>> > with a clumsy "for idiots" popup) I get pretty pissed off and want to
>> > go
>> > back
>> > to 2000.
>> > It slows me down.
>>
>>
>>


.

Quantcast