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.

 

MultiplybySameCell

Subscribe to my mailing list.

Leave a Reply

%d bloggers like this: