Press Ctrl + Enter keys simultaneously to copy over the remained of the selection. Recently, it has become clear that some members (especially newer members) have been confused by 'mixed messages' coming from non-Moderators. Now follow the instructions at the top of that screen. 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.ĩ. Just before posting, scroll down to GO ADVANCED, click, and then scroll down to MANAGE ATTACHMENTS and click again. 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: 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 kommentar(er)
