Having an issue, I had a search function in Excel and now it is gone. The function would search my workbook and find by name, but now I lost the option function on the search box. How can I restore it? I know I can click on the tab and select all but that takes to long. The function also showed a drop down box with other names that were the same.
Share
That is the key sequence to bring up the Find and Replace dialog box.
If it has really disappeared from the Edit menu, try this:
1 – Tools…Customize…Commands tab
2 – Under Categories, select Edit
3 – On the Commands side, scroll down to Find…
4 – Click on Find…, hold the mouse button down and Drag it over the word Edit on the toolbar.
5 – When the Edit menu opens, drag the Find button to wherever you want it and release the mouse.
6 – If Replace is also missing, drag that button up also.