Feedback by UserVoice

Omar Khan

My feedback

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

    We’ll send you updates on this idea

    Omar Khan commented  · 
    Omar Khan supported this idea  · 
  2. 105 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Omar Khan supported this idea  · 
  3. 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)

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

    We’ll send you updates on this idea

    Thanks for the suggestion Levi! We’ll be taking a look at this along with some other asks around conditional formatting. It’s a big help to see the things with the most votes, particularly within areas like formatting. So please keep the votes coming for things you want us to do sooner!

    Thanks,
    John [MS XL]

    Omar Khan supported this idea  · 
    Omar Khan commented  · 

    Another comment about "breeding" or "fragmenting" rules - if the same rule is applied to contiguous ranges, it would be nice if they could be auto-merged. So if I have a rule applied to A1:B10 and due to copy/ paste it is applied to C1:D10, it could auto-merge the ranges to have a single rule applied to A1:D10. Alternatively/ Additionally, there could be a check box on the CF window to "auto extend during copy/ paste" to enable/ disable the breeding; ideally this would be controlled at the rule level and not globally at the worksheet or workbook level.

    And like Excel Help said on Aug 31, 2017 - can we get an update? Or at least more detail into what "under review" means?

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

    We’ll send you updates on this idea

    Omar Khan commented  · 

    I like this idea and would use it a lot assuming it worked like =IFERROR() where the first term is whatever function and the second term is what to do/ display if the function returns a value of zero.

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

    We’ll send you updates on this idea

    Omar Khan commented  · 

    Hi Jennifer. Are you saying that in your attached example, you want Rows 1-7 and Column A to be frozen so they always display while the rest of the sheet scrolls? If so, Excel already supports that, although it may be difficult to tell. The top option in that Freeze Panes dialog ("Freeze Panes") will freeze both above and to the left of the cell you have selected. So if I am right in my assumption, you can simply select cell B8 and then select Freeze Panes and you should be good to go!

  7. 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]

    Omar Khan commented  · 

    Another idea related to conditional formatting that can hopefully be considered as well - check box to apply or not apply formula once it is written: https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/10671168-conditional-formatting-check-box-on-off

  8. 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

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

    We’ll send you updates on this idea

    Omar Khan commented  · 

    I understand the issue you are point out Kenneth, but I think a textjoinif would be very useful nonetheless. If I have a table of data with city, state, and rounded populated (e.g., 100-250k, 250-500k) and need to summarize it to create a concatenated list of all cities in one state with a certain population, textjoinif should be able to handle this. To your point, if I resort the list the value my textjoinif displays would change (with the same data, but reordered), but that is something the function help can call out for users.

    Omar Khan supported this idea  · 
  10. 1,249 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Hi all,

    We have been working on this, and wanted to get your feedback on how you see this feature fitting into your workflow. We have a quick one question survey for you to give us your thoughts on the look and keyboard shortcuts we have at this time. Please see here for more: aka.ms/datePickerSurvey

    Thanks!
    Blake, Excel Product Team

    Omar Khan commented  · 

    This would be helpful if form controls and ActiveX controls are embedded within cells. I often find myself creating forms in a table in Word rather than Excel, though I would prefer Excel, because the controls float.

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

    We’ll send you updates on this idea

    Omar Khan supported this idea  · 
    Omar Khan commented  · 

    Kenneth - I'm not sure that is really related. I read Anna-Karin's idea as a way to manage whether or not the rule is applied, not whether there is one or not. With this idea, you can write all your conditional formatting rules and configure them as needed, but then go in and un-check a box to turn off application of that rule (while leaving it intact) to view the spreadsheet.

  12. 4 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Omar Khan commented  · 

    For a lot of things in Excel (e.g., applying formatting, inserting a row/ column), you can use CTRL+Y to "redo" your last action. You can't "redo" multiple actions at once (e.g., if you've applied a border and a fill to a cell, CTRL+Y doesn't "redo" both, but whatever the last action was).

    Beyond formatting where you can use CTRL+Y/ format painter and operations like inserting a row, what else would you want the ability to redo?

  13. 3 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    We’ll send you updates on this idea

    Omar Khan commented  · 

    I think the comment from Anonymous is what Wouter was getting at. Elsewhere I've seen you guys (MS guys) saying you want to have functions be as short as meaningfully possible, perhaps this would function better as a wrapper for another function. For example:

    =Frequency(array,freq,function)

    So for Anonymous's example,

    =Frequency(A:XYZ,2,SUM(A:XYZ)) and that would sum every other column in that array. And what if it could be something like =Frequency(A:C,2,SUM(A:E)) which would sum columns A,C,D, and E since the range of the sum goes beyond the range the frequency covers?

  15. 39 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Omar Khan supported this idea  · 
  16. 346 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thanks for the feedback! We’re seeing a number of different posts about lookup functions – we’ll be taking a close look at this area and thinking it through. We’ll prioritize the asks according to votes along with other requests on the site. So I encourage people to keep voting if it’s something they really want to see the priority raised on.

    Best,
    John [MS XL]

    Omar Khan supported this idea  · 
  17. 11 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Omar Khan shared this idea  · 
  18. 44 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Omar Khan supported this idea  · 

Feedback and Knowledge Base