Excel, in Office 2000

When I go to use Find in Excel, and click on a Column to search for something, it always comes up with Search by Rows. :cry

Unbelievable stupidity by MS.

Any way to have the default altered to sort by Columns in the drop-down box?

Bazza

 

Why do aussies always do things the other way up?

If you highlight just one cell and hit CTRL+F3 (find) and enter the search criterion Excel will search the entire spreadsheet.

If you click on the column header letter(s) the search will be restricted to within that column(s)

If you click on the row number(s) the search will be restricted to within that row(s)

If you drag a range dotted around rows and columns the search will be restricted to that range.

Studio T :cool

 

I think you misunderstand me, or I misunderstand you. confused

Say I highlight column "D", by left clicking on "D".
This highlights all the contents of Column D.
Then if I click on Edit--->Find, or Control-->F, the Find box pops up.
The default (Office 2000), is Search by Rows, even though I have the Column (D) selected.
I'd like to alter the Search by Rows default to Columns, not Rows.
Is that possible? No biggie. Just annoying.

Hope I make myself clear. Bazza

===

 

No I didn't have too much 4X last night. I was trying to say that for most purposes the way the search is done depends on the rangeof cells selected to search in.

Thus clicking on column D and sayin search for 'yeeha' will, of necessity be a search by rows. This is whatever the spinbox says. You can of course change the spin box to columns, but I don't know of any preference settings to reverse the order in the box.



Studio T

 

You're right. I'm wrong. I've misunderstood Excel(and MS) all these years.

I thought I had to alter the Search from Rows to Columns, to get a column searched.
Works either way with a columnar search. Thanks studiot. Bazza

===

 

Maybe it's because we're all intellectuals here, that's why we're so good at cricket!!!!!!!

Glad you have it sorted

Studio T