When we clear the filter you can see that only the old stock for the filtered products was replaced, the rest remained unchanged. Press Ctrl + Enter keys simultaneously to copy over the remained of the selection. Note: in this example we reference cell D3 given it is the cell that relates to the cell C3 that we want to copy over.ĩ. Enter the first cell reference of the data you want to copy by typing the = sign in the formula bar and selecting the relevant cell. Select Visible cells only in the Go To Special window.Ĩ. 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: it´s not possible paste especial with DDE Link option in Writer. paste in your target document, for example, another sheet or a RTF text table. 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.Ģ. insted the simple copy button, click on Copy only visible cells button (or Edit -> Copy only visible cells menu) 6. 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
