Feedback by UserVoice

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

Be able to pastspecial the content (basically the code) of a specific Cell without entering in the cell and select/copy the line

For example if the content in Cell A1=SUM(B1:C1), you should be to paste this content: "=SUM(B1:C1)" where you want, for example in Cell A5, without locking cells. It could be useful when we have to copy and paste formulas from a workbook to another one (without the problem of REF)

2 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Simone De Leonardis shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →
    already supported  ·  Dan Battagin [MS XL] responded  · 

    Hi Simone,

    You can do this in Excel already today. Instead of copying the entire cell (by selecting the cell in the grid), double click on the cell to enter edit mode, select the formula, and copy it.

    Paste that into the destination and it won’t adjust.

    Cheers,
    Dan [MS]

    0 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...

      Feedback and Knowledge Base