Feedback by UserVoice

Graham

My feedback

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

    We’ll send you updates on this idea

    Graham supported this idea  · 
    Graham commented  · 

    I can't vote as I've used them all but this feature would save a lot of time! With the usual method if a formula changes you basically need to edit it twice, which is a huge hassle, not to mention the shortened processing time.

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

    We’ll send you updates on this idea

    Graham commented  · 

    Thanks for the suggestions everyone. From the ideas given so far, IMO 'Right-click, V' is a pretty decent solution.

    IMO:
    'ALT, E, S, V' is cumbersome and slow,
    'Ctrl+V, Ctrl, V' is slow, and
    'Right-click (keyboard button), V' isn't great because if you're pasting something, odds are your right hand is on the mouse, so it means you'd need to move it to the keyboard to do this shortcut.

    Ctrl+Shift+V for paste values though would be fantastic!

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

    We’ll send you updates on this idea

    Graham shared this idea  · 
  4. 195 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Graham commented  · 

    Yes and also put #N/A and blanks at the top of the list!

    Graham supported this idea  · 
  5. 8 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Graham commented  · 

    hmmm seems I've been censored, I didn't realise h-e-l-l was a naughty word!

    Graham shared this idea  · 
  6. 256 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Graham supported this idea  · 
  7. 71 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Graham commented  · 

    Yes this would be useful!

  8. 24 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    We’ll send you updates on this idea

    Great suggestion, thanks David! And thanks to other people who took the time to clarify/comment on this one. There’s definitely room to tighten this experience up in a number of places. We’re getting a lot of traffic on the site, so please keep voting for the things you care about most to help us do a great job of prioritizing.

    Best,
    John [MS XL]

    Graham supported this idea  · 
  10. 2,431 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thanks everyone for all of the passion about this suggestion! The number of votes has increased greatly in the last couple months and we’re taking notice! We’ve got a bunch of other Excel endpoints behaving this way already and we’re evaluating getting it done in the Windows versions sooner based on the number of votes it gets – so keep the votes coming!

    Eric Patterson (Program Manager – MSFT)

    Graham supported this idea  · 
  11. 901 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

    Graham supported this idea  · 
  12. 775 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thanks to Graham for starting this conversation. If you would also like Excel to maintain named range references and structured table references in the “applies to” field for Conditional Formatting rules, please add your comments and vote this one up. We will prioritize accordingly.

    Thanks,
    Steve (MS Excel)

    Graham commented  · 

    To clarify as per Scott Sobel's comment: Yes, ideally this would apply to both regular named ranges as well as the structured named ranges from tables.

    Graham shared this idea  · 
  13. 39 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Graham commented  · 

    Yes please! I would especially find this useful when using data validation. If I want a drop down with values from a range used elsewhere in the table I could use this formula to filter out duplicate entries, rather than having to first copy the range elsewhere and filtering out the duplicate values and using THAT range as my conditional list.

    May as well include an ordering option for the final array while we're at it. eg. UNIQUE(array, order option)

    Order options: A-Z, Z-A, smallest-largest, etc.

    Graham supported this idea  · 
  14. 30 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Graham shared this idea  · 
  15. 526 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Great suggestion E Bow. Thanks for taking the time to tell us about changes you’d like to see – we’re listening. We’ll take a look at this one. As always, folks should keep voting for the things they like the most – we’ll generally be prioritizing things according to the number of votes they get.

    Cheers,
    John [MS XL]

    Graham supported this idea  · 

Feedback and Knowledge Base