Click Find & Select in the Editing group.Ħ. Note: in this example we are replacing the old stock values with the revised stock values, therefore, we have selected range (C3:C8).Ĥ. Select the filtered range that you want to paste over. Note: in this example we are filtering for Bread, Milk, Apples and Bananas given we are replacing the old stock with the revised stock for only these four products.Ģ. Filter for the values that you want to replace. This image shows the starting point without any adjustments.ġ. In this example we will be replacing the old stock with the revised stock only for Bread, Milk, Apples and Bananas. Select filtered range in which to paste > Select the Home tab > Editing group > Click Find & Select > Click Go to Special > Select Visible cells only > Click OK > Enter the first cell reference of data to copy > Press Ctrl + Enter keys simultaneously
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |