If you have a bunch of rows or columns in Excel that need to be updated with a math operation, instead of applying a formula or editing each cell, save some time by using Paste Special.
The GuidingTech blog shows us this power user trick, using the example of adding 50 to a number of cells all at once. Basically, you copy a cell that contains the value you want to adjust the other cells by (in this case, 50), then select the cells you want to change, and in the paste special window, choose your math operation (e.g., add).
You can add, subtract, multiply, and divide with the copied value. Another example: If you're running a promotion and want to decrease all the numbers by 10%, copy 0.90 from one cell and use the multiple paste special operation.
This simple trick is handy if you don't need to keep the old data around, of course, and it works with complex spreadsheets containing a lot of cells.
How to Quickly Do Calculations Using Paste Special on MS Excel | GuidingTech
via Lifehacker http://lifehacker.com/use-paste-special-to-perform-batch-calculations-in-exce-496166703
No comments:
Post a Comment