ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Using "Find" function in Excel 2000, edit data without closing Fin (https://www.excelbanter.com/excel-discussion-misc-queries/106216-using-find-function-excel-2000-edit-data-without-closing-fin.html)

rkgpihw

Using "Find" function in Excel 2000, edit data without closing Fin
 
I need to know if there is a way to use the Find function from the edit menu
in Excel 2000 and not have to close it to edit the data cell it finds. This
would be useful when editing large spreadsheets with similar data spread
throughout. I know Excel 2003 does this, but my company is not ready to
upgrade yet.

Dave Peterson

Using "Find" function in Excel 2000, edit data without closing Fin
 
xl2002 does it, too.

But if you're using the builtin edit|Find dialog, I think you're out of luck.

You may want to try Jan Karel Pieterse's FlexFind:
http://www.oaltd.co.uk/MVP/



rkgpihw wrote:

I need to know if there is a way to use the Find function from the edit menu
in Excel 2000 and not have to close it to edit the data cell it finds. This
would be useful when editing large spreadsheets with similar data spread
throughout. I know Excel 2003 does this, but my company is not ready to
upgrade yet.


--

Dave Peterson


All times are GMT +1. The time now is 09:06 AM.

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