ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Interrupt find and replace (https://www.excelbanter.com/excel-worksheet-functions/50837-interrupt-find-replace.html)

Richard

Interrupt find and replace
 
When using the find and replace feature for an entire sheet, does anyone know
if there is a way to interrupt the process? I made a mistake in the replace
value and now I have to either crash my excel or hit the "ESC" key after
Excel attempts to replace each entry.

Jerry W. Lewis

Interrupt find and replace
 
AFAIK your only other option is to kill the Excel session (assuming that
you have saved recently enough for this to be a time savings). This
extremely unfriendly aspect of the interface has been pointed out to the
design team by more than one MVP. Perhaps a future version will handle
the situation more gracefully.

Jerry

Richard wrote:

When using the find and replace feature for an entire sheet, does anyone know
if there is a way to interrupt the process? I made a mistake in the replace
value and now I have to either crash my excel or hit the "ESC" key after
Excel attempts to replace each entry.




All times are GMT +1. The time now is 08:39 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com