![]() In our original example column B & C contain some blank cells. Only Reverse the Sign in the Non-blank Cells The result is that the signs will be reversed for each cell value. Click the “Multiply” radio button in the Operation section of the Paste Special menu.Īll of the values in the selected cells will be multiplied by -1.Open the Paste Special menu: Right-click > Paste Special… (Alt,E,S).Select the cell(s) that contain the numbers you want to reverse.Select the cells that contains the -1 and copy it.Type -1 in a blank cell on the worksheet.I explain this in more detail in the video above, but here are the steps to reverse the number sign using Paste Special: Here is a quick screen cast animation that shows how to perform the Paste Special operation. This will perform the multiplication on the selected cells that we paste to. We will copy a cell that contains a -1, then use the Multiply operation on the Paste Special menu. We might want to just change the existing values in columns B & C instead. The first solution with the formula works great, but is forces us to create new columns of data that contain formulas. Method #2 – Paste Special Multiply Operation ![]() We can then copy/paste the formula to get the results for all the cells in columns B & C. Or negative numbers will be converted to positive numbers.Positive numbers will be converted to negative numbers.This works on cells that contain either positive or negative numbers. We can write a formula to multiply the cell's value by negative 1 (-1). Watch on YouTube & Subscribe to our Channel Method #1 – Multiply by Negative 1 with a Formula
0 Comments
Leave a Reply. |