Feedback by UserVoice

Omar Khan

My feedback

  1. 10 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
    Omar Khan commented  · 

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

  2. 109 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  · 
    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. 749 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Good news. We are in the planning stages for improving the Unhide Sheet dialog box so that you can select multiple sheets and unhide them at the same time.

    Thanks for supporting this suggestion.
    Steve K [Excel]

    An error occurred while saving the comment
    Omar Khan commented  · 
    Omar Khan supported this idea  · 
  4. 123 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  · 
  5. 953 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thanks for supporting this feature. We won’t be able to 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 since named ranges can be dynamic, meaning that the range is calculated when the workbook is calculated.

    We’ll continue tracking votes for this suggestion.

    Omar Khan supported this idea  · 
  6. 484 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    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

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

  9. 1,087 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    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  · 
  10. 11 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
    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  · 
  11. 1,753 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

    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.

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

  13. 5 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
    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?

  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 shared this idea  · 
  15. 3 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
    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?

  16. 41 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  · 
  17. 378 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  · 
  18. 12 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  · 
  19. 45 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