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 |