How to find and replace multiple values at once in Excel? Please create your conditions that you want to use which contain the original values and new values. Then press F5 key to run this code, in the popped out prompt box, please specify the data range that you want to be replaced the values with new values.