Stop Excel Taking me to another cell

[pretenderoui]

Hi all

I have been trying to solve this but i cant find a way i am using Office 2007

i have 2 colums 1 is for my location and the 2nd one is for my Books ISBN. i am searching and replacing them but when i replace a cell it take me to the next active cell with the same ISBN i dont want excel to take me to the next cell when i hit replace button, i want it to stop at the cell i just altered is that possible?

thanks

[peterjuhnke]

Hello; you should be able to right click, remove hyperlink.
If this doesn't help please attach a dummy sheet
regards
Peter

[romperstomper]

I'm afraid not - that's just the way the dialog works.