If you have multiple non-adjacent cells and you need to make a change the contents in the cells at once, there is an easy way to do this without copying and pasting the new data. In this example the name of one of the products has changed, we are going to change the name in multiple cells at the same time.  This will work the same in Excel 2010, Excel 2007 and Excel 2003.