Paste Special in Excel: Quickly add, subtract, multiply, divide to/from a cell series in-place

Поделиться
HTML-код
  • Опубликовано: 11 сен 2024
  • Paste Special in Excel allows you to quickly add, subtract, multiply, divide to and from a cell series in-place without having to create a new cell series and write a formula.
    If you would like to quickly add, subtract, multiply, divide to and from a cell series in-place without creating a new cell series, here's how can do so in Excel with Paste Special.
    Copy the cell or cell series that you would like to add, subtract, multiply or divide from another series. Then select the series that would like to perform any of the above arithmetic operations onto.
    Right click and select Paste Special. Then select Paste Special again at the bottom of the right click menu. Then go to the Operation section and select add, subtract, multiply or divide, depending on the arithmetic operation that you would like to perform and you are good to go.
    That's it. You are done. With Paste Special you are able to add, subtract, multiply or divide cells in excel with just a few clicks right in-place and fast.
    Keep in mind that if one of the cells that you are adding to, subtracting from or multiplying or dividing with is blank Paste Special will treat as zero and still perform the operation (for division you will simply get zero).
    Comment, like, share.
    Thanks for watching. Any questions? Let me know in the comments.

Комментарии •