where is the search/replace command located

H

Harlan Grove

Jim Thomlinson wrote...
Try Ctrl + H (Find and Replace) or Ctrl + F (Find) ....
Click to expand...

Alternatively, in Excel 2003 (and presumably also Excel 2004 on Macs)
and prior, Find and Replace are in the Edit menu. In Excel 2007's oh so
wonderful ribbon, it's in the Home tab, in the Editing section under
Find & Select. These particular commands seem to be much harder to find
in the oh so wonderful new interface than they were in the old menu.
 
D

docdon

Harlan Grove said:
Jim Thomlinson wrote...

Alternatively, in Excel 2003 (and presumably also Excel 2004 on Macs)
and prior, Find and Replace are in the Edit menu. In Excel 2007's oh so
wonderful ribbon, it's in the Home tab, in the Editing section under
Find & Select. These particular commands seem to be much harder to find
in the oh so wonderful new interface than they were in the old menu.

Yes! I found it and thank you very much. "the ribbon" is really a job to work with. Hunt and Hopefully find. Thanx , again.
Click to expand...
 
D

docdon

Jim Thomlinson said:
Try Ctrl + H (Find and Replace) or Ctrl + F (Find)
Click to expand...

Thank you very much. Why didn't I think of that? oh well. . .one of these
days. . .
 
G

Gord Dibben

Normally reside on the "Edit" menu.

If not there, perhaps you need to reset your menu bar.

Tools>Customize>Toolbars.

Select Worksheet Menu Bar and "reset".

Note: this will wipe out any customizations you may have made.

Alternate method...........

Tools>Customize>Commands>Buit-in menus.

Select the Edit menu and drag to your menubar.

Remove the faulty one.


Gord Dibben MS Excel MVP
 
Top