![]() To solve the problem, you can create a temporary formula, in cell D2, with an absolute reference to cell B2, and use that for the Paste Special. Instead of pasting a reference to cell B2, the Paste Special command pastes the formula that’s in cell B2 (green highlighting below).īecause the pasted formula has a relative reference, the results in row 6 aren’t correct. For example, if you copy cell B2, and use it to multiply in the Paste Special command, the results might not be what you need. However, pasting formulas is a little trickier than pasting values. ![]() Fortunately, you can use the Paste Special command to modify all the formulas at once. ![]() In the worksheet shown below, the formulas in row 6 calculate an adjusted rate.Ī new factor - Discount - has been added to the workbook, and it needs to be included in the adjusted rates.Įach formula in row 6 is slightly different, so you can’t just change one formula and copy it across. Copy Number From Worksheet CellĪfter using the Paste Special command, each value in B2:B5 is increased by $1.50, as expected.Įxcel Paste Special works well with values, and you can also use it to paste and modify formulas. This screen shot shows a cell that has been copied, and is ready for the Paste Special command.įor example, in the screenshot below, you could copy cell D2, and use the Paste Special, Add, command to add that amount to cells B2:B5. Today, you’ll see how to update multiple Excel formula cells in one step. You’ve probably used the Excel Paste Special command to multiply cells by a specific percentage, or to add the same amount to a group of cells.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |