Feedback by UserVoice

Omar Khan

My feedback

  1. 10 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Omar Khan commented  · 

    Would love to see this as an advanced option within the option menu

  2. 111 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    Agree with comments below - it would be really helpful to be able to select multiple cells of text and quickly toggle case, like in PPT. Would be useful if I am making a Gantt Chart, RAID Log, RACI Matrix, etc. Would at least like to see Sentence Case and Capitalize Each Word.

  3. 133 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Omar Khan supported this idea  · 
  4. 1,037 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thanks for supporting this feature. We won’t be able to offer this in the near future, but we understand that it would be a nice improvement. Even though it seems like a straightforward idea, it is quite complex. Old versions of Excel will not support the new behavior, so there would need to be some hybrid approach that will be suitable for old and new versions. Also, named ranges can be dynamic, meaning that the range might change and conditional formatting rules would have to be adjusted when the workbook is calculated. There are lots of cases to consider and deal with properly.

    We’ll continue tracking votes for this suggestion.

    Omar Khan supported this idea  · 
  5. 534 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thanks for your support of this suggestion and all the great ideas in the comments. We have at least one improvement planned (resizing the dialogs – see link in the description), and we’re looking at some additional improvements.

    If you have specific ideas that aren’t already listed, please add them in a comment.

    Steve [Microsoft Excel]

    Omar Khan supported this idea  · 
    An error occurred while saving the comment
    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?

    An error occurred while saving the comment
    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

  6. 7 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    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  · 
  7. 4 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    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!

  8. 1,160 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thanks to everyone for the votes and discussion about having undo independently in each workbook. Even though this request has been here for a long time, we are listening and we realize that it can be frustrating if you press Undo while you’re in one workbook and it undoes something in another workbook. We’ve been considering the technical challenges to make Undo work “per workbook”, and want to share some details about it with you.

    The undo process relies on the state of all open workbooks being exactly the same after an “undo” as they were before the undone action was taken. One example of how undo “per workbook” is problematic is with linked workbooks. Let’s say you have WorkbookA, with a formula that refers to WorkbookB, such as =SUMIFS. This formula will give the sum of values in WorkbookB in range A1:A10 that have “Yes” in the…

    Omar Khan supported this idea  · 
  9. 11 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    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. 2,571 votes

    We're glad you're here

    Please sign in to leave feedback

    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

    An error occurred while saving the comment
    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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Omar Khan supported this idea  · 
    An error occurred while saving the comment
    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. 5 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Omar Khan shared this idea  · 
  14. 3 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    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. 41 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Omar Khan supported this idea  · 
  16. 394 votes

    We're glad you're here

    Please sign in to leave feedback

    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. 12 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Omar Khan shared this idea  · 
  18. 47 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Omar Khan supported this idea  · 

Feedback and Knowledge Base