This will subtract a particular value from column D.Ĥ.Select All in the Paste option and select Subtract from Operation and finally, click on ‘ OK’. A Paste Special dialog box will appear.Select Paste Special from the Paste option.Go to the Home tab and click Paste from the Clipboard group.Now, copy column D to column E otherwise Paste Special will rewrite the previous column.It brings a static solution whereas formulas give you a dynamic solution that changes with the alteration of the dataset. You can use Paste Special command to subtract a specific number from the whole column. Subtract a Particular Value from Whole Column Using Paste Special Command On one occasion, there is a negative saving which means expenses are greater than income.ģ. Drag or double-click the Fill Handle icon down the column.
0 kommentar(er)
