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
If you can discern anything at all from her obituary, Antonia Larroux had a non-stop sense of humor. Her paid obituary ran in the New York Times Friday and Saturday, although Larroux lived in Mississippi.
Grey hair may soon be a thing of the past. Scientists have found the cause of greying hair and a clue on how it can be reversed:
