How can we improve Excel for Windows (Desktop Application)?

Paste Special - Add a numeric field when using one operation

Via the Paste Special we can operate on a range of values. However, to do, for instance, a multiplication, we first need to use a cell for it. As an option I would like to see that we can instead add a number to the Paste Special dialog as the attached screen shot shows.

31 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Dennis M WallentinDennis M Wallentin shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    6 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      Submitting...
      • Anonymous commented  ·   ·  Flag as inappropriate

        I use the paste special, Multiply feature all of the time. This would make things so much quicker, and user friendly.

      • Dennis M WallentinDennis M Wallentin commented  ·   ·  Flag as inappropriate

        Kenneth,

        Like many other users, You have not yet discovered this feature.

        Assume You've have a budget that need to be increased with 10 %. The easiest way is to:

        - Enter 10 % in an empty cell
        - Copy
        - Paste Special operation, in this case Multiplying.
        - Done!

        Instead of using a cell in the worksheet a numeric field as per screen shot will make it smoother. Give it a try and You will soon find out its value :-)

      • Kenneth BarberKenneth Barber commented  ·   ·  Flag as inappropriate

        Why use the Paste Special window for this if you have nothing to paste? Why not just suggest for this to be done in its own separate window after right-clicking on your selected range?

        Just use formulas. I'm not even sure why there are Paste Special options for adding and multiplying.

      Feedback and Knowledge Base

      How it works

      • Create a user account if you want to add a new suggestion or vote on existing suggestions.
      • Select one of the feedback forums listed.
      • Check out the ideas others have suggested and vote on your favorites.
      • Be sure to search for your suggestion but if you can’t find something similar enough, you can submit your own.
      • Keep suggestions focused on a single idea per post and limited to 25 words or less.
      • When you post an idea to our forum, others will be able to subscribe to it and make comments.