Feedback by UserVoice

GraniteStateColin

My feedback

  1. 223 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    GraniteStateColin commented  · 

    Another Microsoft thread with 24 pages of comments on this issue: https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_win10/theres-a-problem-with-the-clipboard-but-you-can/6720299f-1084-4104-93cc-abee9dcf7469?page=21

    I love the suggestion by the original poster: just block the pop-up message. Even if there really were a Clipboard problem, we don't need that error message, and the annoyance level vastly exceeds the value of the message (which is always wrong in my case).

    An error occurred while saving the comment
    GraniteStateColin commented  · 

    I only see the message on Drag and Drop within Excel, so maybe that's a different problem, but like others here, there is no actual error, just the annoying message. After hitting OK, the drop of cells works fine. I can copy and paste between Excel and other apps, so the message is not even correct. I even tried dragging from Excel to Word, to see if there was indeed a problem with the Clipboard outside of the workbook limited to Drag and Drop (because that's the only action that causes the error message for me) -- nope, that worked perfectly too.

    This same problem occurs for me across multiple computers, none exhibiting any other app problems aside from this bug in Excel.

    But for those who are complaining that MS still hasn't fixed, get more people to vote for this issue. Based on the numbers, it looks like there aren't very many of us with this problem, so it's understandable MS is prioritizing other issues over this. Also vote in the MS Feedback Hub that's built into Windows 10.

    GraniteStateColin supported this idea  · 
  2. 3 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    GraniteStateColin supported this idea  · 
  3. 9 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    GraniteStateColin commented  · 

    This has been my personally biggest desire in Excel for years. Finally decided to add it to UserVoice and see it's already in the list, but doesn't have a lot of votes. I'm surprised there aren't more of us who find this a problem (maybe there's another way to do it, and I just don't know how to find it?).

    I frequently want to clone a bunch of cells, including their references to other cells. I don't want to move/delete the original. Right now, if I paste the copy, it loses its values, because of the references to other cells. It's fine if I use absoluter references, but there are times when that doesn't make sense.

    Yes, please add an option to the Past options that is something like "Paste preserving references".

    GraniteStateColin supported this idea  · 
  4. 4 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    GraniteStateColin commented  · 

    In other Office apps, it's the active or selected block that moves with Shift-Alt + arrows. I'd suggest this be preserved in Excel. So don't move the whole row, just the cell that's active or cells that are selected. Maybe adding Ctrl would move the whole row or column, where up and down arrows would move the row up or down and left and right arrows would move the column.

    GraniteStateColin supported this idea  · 
  5. 1,070 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thanks again for all the passion on this issue – we hear you and we’ll get someone on the team to dig in to the issue. I’ve seen a few related sub-issues while scanning over the comment section for this one, so we may reach out to a few of you for clarifications. Thanks again for all the votes, and keep them coming for the issues you care about!

    John, Excel

    An error occurred while saving the comment
    GraniteStateColin commented  · 

    This is really atrocious the way it works now, but I understand the history -- previous versions of Excel required launching a whole separate instance of Excel (no shared clipboard or anything) if you wanted a fully separate window, as opposed to child windows trapped inside an Excel parent window. We all wanted true separate windows in the same Excel session so we could copy and paste between them. In providing this, because they're the same session, the clipboard AND THE UNDO HISTORY are shared between all windows in the same Excel session. So they fixed one big problem and replaced it (or left in place) one that's almost as bad.

    GraniteStateColin supported this idea  · 
    An error occurred while saving the comment
    GraniteStateColin commented  · 

    @Omid Nikfar and @AB -- opening separate instance of Excel for multiple workbooks was an abomination that is charitably finally fixed. I did this frequently as a work-around, but it's very poor solution. It made copy and pasting formulae between workbooks impossible and it also meant that if you did open in the same session it used the horrible and Windows 3.0-era MDI (Multiple Document Interface), with child windows inside parent windows. This also made it impossible to look at multiple windows at the same time unless you first extended the parent window to be large enough to hold all the child windows, which also covered a lot of other windows you might want to see that could have been visible without the rectangular parent window.

    Now Microsoft needs to fix the global-shared Undo, which is still a throwback to the old MDI approach. From my perspective, this is the single most important outstanding feature request.

    An error occurred while saving the comment
    GraniteStateColin commented  · 

    I think it is a HUGE improvement that Excel no longer uses the child windows as it did in the past. Now each workbook opens in its own window but the clipboard is shared. For those who say that you could always open multiple windows -- yes, but each was a separate session completely separated from the others, so you couldn't copy formatted text or ranges of cells between them. Now Excel works like a Word and PowerPoint have for a long time. Much better.

    However, now that it works this way, it really highlights the need for also keeping the Undo tied to the workbook, not global, exactly as this request states. Again, this would bring Excel better in line with Word and PowerPoint, which already work that way.

  6. 11 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    GraniteStateColin supported this idea  · 
    An error occurred while saving the comment
    GraniteStateColin commented  · 

    I like all of the elements of this suggestion. The ability to turn on the red underlining for misspelled words would be the most helpful for me. Having to click on a "Spell check" button has become so alien because all other applications show spelling errors as you type. We've literally been conditioned to not use the Check Spelling option.

    Please give us at least an option to turn on a "Highlight spelling errors in text cells as you type"

  7. 2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    GraniteStateColin commented  · 

    Perhaps he means to provide an option to paste a range of cells without using the relative position change to change the content of the formulae. This would be hugely useful for actually COPYING a range. Currently in Excel you can move a range and everything is preserved, but if you copy it, when you paste it, all of the references have moved because of the relative position change. Often this is great and what the user would want, but there are times when it would be extremely useful to be able to have a "Paste and preserve absolute references" so that the copied range has the same values as the original range.

Feedback and Knowledge Base