Multiply a Whole Range by the Same Cell

Here’s a feature that takes advantage of the powerful “Paste Special” features in Excel. Say you’ve got a list of sales by employee and week. The sales reps get a 10% commission. You can easily transform your raw data into the commission figures with the below steps.

Subscribe to the newsletter for more Excel tips and tricks.