Excel 2010: Search function - Write over last searched term after search is completed

Dafuq

New Member
Joined
Apr 15, 2015
Messages
8
When using the search/replace function, I find it extremely annoying that I have to delete the last searched term every time before entering the next. In a lot of other programs, the last searched term is automatically marked/"blackened" once the search is terminated, and you can then simply write over it, but not in Excel.

Is there any way (hidden option, extension, whatever...) to get Excel to do this?

Here's a picture to clarify what I mean:

 

Some videos you may like

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

Watch MrExcel Video

Forum statistics

Threads
1,109,132
Messages
5,527,029
Members
409,737
Latest member
shanghity

This Week's Hot Topics

Top