![]() ![]() 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 |