![]() Using this simple technique you can also subtract, multiple, and divide large ranges of values by the same value. What you might not know is that you can copy multiple values to the Clipboard. For instance, let’s suppose you want to add the values 1, 2, and 3 to all the corresponding values in columns A, B, and C, respectively. Click OK and Excel adds 1 to the selected values in column A, 2 to the selected values in column B, and 3 to the selected values in column C.In the resulting Paste Special dialog, select Add.(In Excel 2003, choose Paste Special from the Edit menu.) Click the Home tab and choose Paste Special from the Paste option in the Clipboard group.Select the cells you want to copy to the Clipboard (A4:C4) and press +C.Using Paste Special, you can turn a rather tedious task into a few clicks! First, you enter the values you want to copy to the Clipboard, that’s values 1, 2, and 3. You can subtract, multiply, and divide using the same technique. Just be sure to specify the appropriate operator in step 3.įurthermore, Excel doesn’t complain when the two range dimensions don’t match. For instance, you can copy two rows of values to the Clipboard to alternate the applied values. Or, you can copy four columns of values to the Clipboard even if you’re changing only three columns. Excel will simply copy the extra value to the adjacent cell, relative to its position. For instance, if you enter 4 into D4, and select A1:C2, Excel will copy the value 4 to D1 (but not D2). ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |