Excel should let user change Find default to 'By Columns'.

[baobob]

But it doesn't.

At least, Excel 2002 doesn't.

(For those involved in the numerous posts on this issue, what I mean
by "change the default" is change it permanently, so that it survives
into the next Excel session.)

If Microsoft is reading this, I wish you guyz would implement this
capability, say in Tools / Options. Or at least give us a Registry
tweak.

It is a fundamental mis-implementation of Excel not to permit this.

You are treating Excel as if it were a word processor.

Only in a word processor would searches most often be line-by-line.

It stands to reason that because spreadsheet software has columns,
users need to SEARCH by columns. How is it that software company no. 1
hasn't grasped that?

So what do we have to do now? Create some stupid startup macro kludge
that executes a search, just to set the paradigm for the rest of the
session. Not acceptable.

The analogy is having to have pilot lights running on your stove for
the purpose of turning on a flame to BEGIN with.

I've searched the Registry for some setting, but offhand can't find
any. So if there is one, I apologize & retract, and I'd sure like to
know about it.

Or, if you have in fact added this capability after Excel 2002, I
wholeheartedly retract as well.

Kirk out.

***

 

[Tyro]

If you have a range of A1:C100, i.e. 300 cells. What difference does it make
if you search by rows or columns? You still have to search 300 cells.

Tyro