My feedback

1. Include Median in Pivot Table Value Field Settings

   268 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   25 comments  ·  Excel for Windows (Desktop Application) » PivotTables and Power Pivot  ·  Flag idea as inappropriate…Flag idea as inappropriate…  ·  Delete…  ·  Admin →
   Accepting Votes  ·  AdminExcel Team [MSFT] (Product Owner, Office.com) responded

   We’ve just merged two items that were both requests for the Median function in PivotTables. One had been for Windows, the other for Mac. When we get to this, we should actually make the addition on all platforms including Windows, Mac, Web, and others.

   An error occurred while saving the comment
   Yazan Hlayel commented  ·  Jan 23, 2021  ·  Edit…  ·  Delete…

   It would even be better to get PERCENTILE functions as it covers more than just MEDIAN.
   There's a list of functions that can improve the usability of pivot tables in Data Science such as QUARTILE & IQR.

   Save Submitting...
   Yazan Hlayel supported this idea  ·  Jan 23, 2021

2. Percentile added to pivot table functions

   5 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   1 comment  ·  Excel for Windows (Desktop Application) » PivotTables and Power Pivot  ·  Flag idea as inappropriate…Flag idea as inappropriate…  ·  Delete…  ·  Admin →
   Yazan Hlayel supported this idea  ·  Jan 23, 2021

3. Add the ability to run percentiles in pivot tables

   9 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   1 comment  ·  Excel for Windows (Desktop Application) » PivotTables and Power Pivot  ·  Flag idea as inappropriate…Flag idea as inappropriate…  ·  Delete…  ·  Admin →
   Yazan Hlayel supported this idea  ·  Jan 23, 2021

4. Conditional formatting - Apply to named ranges

   999 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   260 comments  ·  Excel for Windows (Desktop Application) » Formatting  ·  Flag idea as inappropriate…Flag idea as inappropriate…  ·  Delete…  ·  Admin →
   not at this time  ·  AdminExcel Team [MSFT] (Product Owner, Office.com) responded

   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.

   An error occurred while saving the comment
   Yazan Hlayel commented  ·  Sep 9, 2020  ·  Edit…  ·  Delete…

   Is it also as difficult to implement on dynamic ranges (using # operator)?

   Save Submitting...
   Yazan Hlayel supported this idea  ·  Aug 29, 2020

5. Intellisense for User Defined Functions

   298 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   11 comments  ·  Excel for Windows (Desktop Application) » Macros and Add-ins  ·  Flag idea as inappropriate…Flag idea as inappropriate…  ·  Delete…  ·  Admin →
   Accepting Votes  ·  AdminExcel Team [MSFT] (Product Owner, Office.com) responded

   Thanks for the suggestion Nick. We’ve got some related work we’re looking at soon, and we’ll be sure to carefully consider if we can get a fix in for this then. As always, more votes helps – so keep voting for the things you care about most.

   Thanks,
   John [MS XL]

   Yazan Hlayel supported this idea  ·  Aug 29, 2020

6. Be able to protect Power Query with password

   350 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   26 comments  ·  Excel for Windows (Desktop Application) » Data Import  ·  Flag idea as inappropriate…Flag idea as inappropriate…  ·  Delete…  ·  Admin →
   not at this time  ·  AdminExcel Team [MSFT] (Product Owner, Office.com) responded

   Thank you for taking your time to suggest and vote for being able to protect Power Query with a password. This is a good idea, but we don’t think we’ll be able to support this in the near future. We’ll continue tracking votes for it.

   Guy Hunkin
   Excel Team

   Yazan Hlayel supported this idea  ·  Aug 29, 2020

7. Allow interaction with Excel while in Power Query

   627 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   43 comments  ·  Excel for Windows (Desktop Application) » Data Import  ·  Flag idea as inappropriate…Flag idea as inappropriate…  ·  Delete…  ·  Admin →
   not at this time  ·  AdminExcel Team [MSFT] (Product Owner, Office.com) responded

   Thank you for taking your time to suggest and vote for allowing interaction with Excel while in Power Query Editor window. We do think that this suggestion has merit but we don’t think that we’ll be able to devote time to it in the near future. We’ll continue tracking votes for it.

   Guy Hunkin
   Excel Team

   Yazan Hlayel supported this idea  ·  Aug 29, 2020

8. Built-in RegEx / Regular Expressions Functions to Search, Extract, and Replace

   649 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   39 comments  ·  Excel for Windows (Desktop Application) » Formulas and Functions  ·  Flag idea as inappropriate…Flag idea as inappropriate…  ·  Delete…  ·  Admin →
   Accepting Votes  ·  AdminExcel Team [MSFT] (Product Owner, Office.com) responded

   Thanks for the suggestion! We’re fans of Regex and its ability to parse text too.

   If you’d like to see Regex support in Excel, please keep the votes rolling in.

   - JoeMcD [MS XL]

   Yazan Hlayel supported this idea  ·  Aug 29, 2020

9. Make Undo stacks track per workbook instead of globally

   1,130 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   228 comments  ·  Excel for Windows (Desktop Application) » Editing  ·  Flag idea as inappropriate…Flag idea as inappropriate…  ·  Delete…  ·  Admin →
   not at this time  ·  AdminExcel Team [MSFT] (Product Owner, Office.com) responded

   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 same rows of column B. You change the formula by switching last parameter from “Yes” to “No”. Then you insert a row in workbook B which causes the references in workbook A to adjust accordingly to refer to rows 2-11 rather than 1-10. The formula would be =SUMIFS. If you then undo the formula change in workbook A, the references would again refer to rows 1-10, which would give an unwanted result, since it would not take into account that you inserted the row.

   Step-by-step, the formula would be as below:
   =SUMIFS

   Change “Yes” to “No”:
   =SUMIFS

   Insert row 1 in WorkbookB, and Excel adjusts the range reference accordingly:
   =SUMIFS

   Undo in WorkbookA – the range references would then be incorrect, because the inserted row would still exist in WorkbookB:
   =SUMIFS

   You would expect the formula to keep the references and only change “No” back to “Yes”, like this:
   =SUMIFS

   There are a number of other challenges and tradeoffs to consider between the current behavior and the requested behavior. We wanted to let you know it would be significant undertaking to make this change. Your votes and suggestions help us plan and prioritize, and we sincerely appreciate all the interest. Even though we don’t have plans to address this soon, we’ll continue to monitor the votes.

   Thanks,
   Steve K [Microsoft Excel]

   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… more

   Yazan Hlayel supported this idea  ·  Aug 29, 2020

10. Export power query or Table to CSV

    23 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    4 comments  ·  Excel for Windows (Desktop Application) » Other  ·  Flag idea as inappropriate…Flag idea as inappropriate…  ·  Delete…  ·  Admin →
    Yazan Hlayel supported this idea  ·  Aug 29, 2020

11. Allow loading sequence in Power Query

    6 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    0 comments  ·  Excel for Windows (Desktop Application) » Other  ·  Flag idea as inappropriate…Flag idea as inappropriate…  ·  Delete…  ·  Admin →
    Yazan Hlayel supported this idea  ·  Aug 29, 2020

12. Add a Split dynamic array function

    •  

    290 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    30 comments  ·  Excel for Windows (Desktop Application) » Formulas and Functions  ·  Flag idea as inappropriate…Flag idea as inappropriate…  ·  Delete…  ·  Admin →
    Yazan Hlayel supported this idea  ·  Aug 29, 2020

13. Named spilled arrays

    4 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    0 comments  ·  Excel for Windows (Desktop Application) » Formulas and Functions  ·  Flag idea as inappropriate…Flag idea as inappropriate…  ·  Delete…  ·  Admin →
    Yazan Hlayel supported this idea  ·  Aug 29, 2020

14. Dynamic Arrays, Spill range format

    29 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    5 comments  ·  Excel for Windows (Desktop Application) » Formatting  ·  Flag idea as inappropriate…Flag idea as inappropriate…  ·  Delete…  ·  Admin →
    Yazan Hlayel supported this idea  ·  Aug 29, 2020

15. Allow conditional formatting for spilled array formulas

    13 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    0 comments  ·  Excel for Windows (Desktop Application) » Formatting  ·  Flag idea as inappropriate…Flag idea as inappropriate…  ·  Delete…  ·  Admin →
    Yazan Hlayel supported this idea  ·  Aug 29, 2020

16. Allow UNIQUE() to operate on a rectangular range, returning all unique values

    •  

    101 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    4 comments  ·  Excel for Windows (Desktop Application) » Formulas and Functions  ·  Flag idea as inappropriate…Flag idea as inappropriate…  ·  Delete…  ·  Admin →
    Yazan Hlayel supported this idea  ·  Mar 23, 2020

17. Pick color in Excel Like at Powerpoint

    •  

    1,139 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    108 comments  ·  Excel for Windows (Desktop Application) » Formatting  ·  Flag idea as inappropriate…Flag idea as inappropriate…  ·  Delete…  ·  Admin →
    Accepting Votes  ·  AdminExcel Team [MSFT] (Product Owner, Office.com) responded

    Thanks for this suggestion. If you’d like to see the eye-dropper tool to pick a color in Excel like you can in PowerPoint, please vote for this idea.

    Steve [Microsoft Excel]

    Yazan Hlayel supported this idea  ·  Mar 23, 2020

18. Format cell as a checkbox (TRUE, FALSE)

    242 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    36 comments  ·  Excel for Windows (Desktop Application) » Formatting  ·  Flag idea as inappropriate…Flag idea as inappropriate…  ·  Delete…  ·  Admin →
    not at this time  ·  AdminExcel Team [MSFT] (Product Owner, Office.com) responded

    Thanks for the idea! We think formatting cells as a checkbox is an interesting suggestion, but we won’t be able to address it in the near future. We’ll continue tracking votes for it.

    Yazan Hlayel supported this idea  ·  Mar 23, 2020

19. Add a zoom feature to charts

    71 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    14 comments  ·  Excel for Windows (Desktop Application) » Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…Flag idea as inappropriate…  ·  Delete…  ·  Admin →
    Accepting Votes  ·  Scott Ruble (PM MSFT) responded

    This is great feedback. We are looking into the details of this. Please continue to vote on feature ideas which will increase their likelihood of getting in the product.

    Thanks,
    Scott [MSFT]

    Yazan Hlayel supported this idea  ·  Jan 9, 2020

20. Do not chart null values

    73 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    Accepting Votes  ·  11 comments  ·  Excel for Windows (Desktop Application) » Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…Flag idea as inappropriate…  ·  Delete…  ·  Admin →
    Yazan Hlayel supported this idea  ·  Jan 9, 2020