Finding replacing Data Summary

Excel 2007 worksheets can contain more than 1 million of row and data.
you can also find data or also replacing any worksheet. they are different ways to replace dialog box.the dialog box have controls functions.For example Replace with field , options button etc...