Feedback by UserVoice

Excel for Windows (Desktop Application)

Welcome to the Excel for Windows (Desktop Application) feedback forum! This is the place for users to send us suggestions and ideas on how to improve. If you think you have found a bug, please send us feedback in-app instead! To do so, please click “File”, then “Feedback”, then “Send a Frown” in Excel. This way, we will get detailed information that will help us better diagnose the problem.

To help us build the best version of Excel ever, we have partnered with UserVoice, a third-party service, to create this site to hear your suggestions and ideas for the next version of Excel. Your use of the portal and your submission is subject to the UserVoice Terms of Service & Privacy Policy, including the license terms. Please do not send any novel or patentable ideas, copyrighted materials, samples or demos for which you do not want to grant a license to Microsoft.

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. VLOOKUP function for multiple criteria

    There should be a *VLOOKUPS function (or you name it) alongside VLOOKUP to find data based on multiple criteria. I know there are workarounds like INDEX and MATCH but they are unnecessarily complicated considering COUNTIFS and SUMIFS functions do a neat job at counting and adding multiple criteria. And please make it so it works with unsorted data.

    345 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    14 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →

    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]

  2. Allow users to control the order of items in the sunburst chart.

    I'm using a sunburst chart to convey status, and visually it would be nice to have the chart in the same order as the items I want to talk about them, so the discussion flows clockwise around the wheel. Having an option for the layout to follow the order in the excel list would be wonderful

    144 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    26 comments  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →

    Thanks for the feedback. This is an interesting idea. We’ll consider it in our next round of planning. Please continue to vote on this feature idea.

    Thanks,
    Scott [MSFT]

  3. IP Address as a datatype.

    I would love to see IP Addresses added as a format option and functions added for validation of the IP addresses..

    For instance InSubnet(Network as IP,Netmask as Integer,address as IP) to determine if an IP is within a Subnet;

    Being able to do addition/subtraction on the field would be awesome as well!

    271 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    36 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →

    Thanks for the suggestion Alex, and thanks to those that making their vote heard. This is a pretty interesting ask – take a look at the comment I made. I’d like us to understand a few related things. And as always, please keep voting for the things you care about most.

    Cheers,
    John [MS XL]

  4. Linking chart title to a cell on waterfall charts.

    How can I link a cell as Chart Title for waterfall charts.

    31 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    6 comments  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →

    This capability is not currently supported on any of our new chart types in O16. However, we are working on plans to support this functionality in the future.

    Thanks,
    Scott [MSFT]

  5. Allow PowerQuery to Extract Data from PDF tables

    Allow PowerQuery to import tables of data from PDF files.

    58 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →

    Thanks for logging this suggestion, Terry. This is a frequently asked requests, as evidenced by the number of votes on the article Ken linked to on the Power BI user voice site.

    We’re looking at this one, and in the meantime more votes would help us prioritize this work higher.

    thanks

    Ashvini Sharma
    Lead Program Manager
    Excel

  6. Allow us to turn off automatic conversion to date

    Search for "make excel stop converting numbers to dates" and you will see the user demand for this feature. Please for the love of all that is holy let this be at least an advanced user setting.

    301 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    54 comments  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →

    Thanks for the suggestion Jessica. We’ve got a few other suggestions on the site that are similar with scientific notation, etc. We’ll take a look at this area, and pay special attention to any cases that get a lot of votes. So please keep the votes coming to help us do a good job at prioritizing asks like this!

    Cheers,
    John [MS XL]

  7. Create DAX calculated measures in Excel for SSAS Tabular

    Enable writing measures in DAX in a pivot table connected to Tabular or Power Pivot.
    In practice, it would be enough to enable a choice between MDX and DAX in the "New Calculated Measure" dialog box and use the following syntax for creating a DAX measure instead of an MDX member in measures…

    CREATE SESSION MEASURE [Model].Sales[My Sales 2] = SUMX ( Sales, Sales[Quantity] * Sales[Unit Price] /5 )

    I received this requests from several enterprise customers, but I think it's useful to any data analyst accessing tabular models (but you should be able to write DAX measures also for…

    157 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    7 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  8. Embed 3D maps in worksheets

    Add the ability to embed 3D maps within an excel sheet. If you are making an excel-based dashboard, it would be great to have the capability to showcase the map right within the sheet instead of as a pop-out visual.

    61 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    6 comments  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →

    Thanks for the input. We’ll consider this in our future planning efforts. Please continue to vote on this idea.

    Thanks,
    Scott [MSFT]

  9. Intellisense for User Defined Functions

    Currently User Defined Functions (UDFs) in Excel will not show intellisense to tell the user what arguments need to be supplied. This makes them very difficult to use.

    There's a discussion here:
    http://stackoverflow.com/questions/16903587/the-quest-for-the-excel-custom-function-tooltip

    Whether the future of UDFs is in VBA or something else, the ability to define intellisense is vital.

    254 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    11 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →

    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]

  10. Workbook level calculation

    We need the ability to calculate a single workbook when multiple workbooks are open.
    When working with multiple large slow workbooks which are often not even linked together (think multiple versions of the same workbook or a large mostly static workbook being referenced by a smaller rapidly changing workbook) you want to make changes and recalculate without globally recalculating all open workbooks.
    This should be implemented as
    a) New calculation setting (persistent) - Calculate Active Workbook Only - works for Automatic and Manual F9, but Ctrl/Alt/F9 would full calculate all open workbooks regardless of the setting.
    Automatic Calc in Active…

    190 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    11 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →

    Thanks for the post Charles, and for the in person conversation at the latest MVP conference. We definitely understand the ask and will keep our eye on it – it looks like it’s moving up the vote charts pretty quickly. As always, keep upvoting the things you are about most.

    Best,
    John [MS XL]

  11. Two new =if's

    Just like =IFERROR(), could we also get =IFBLANK() and =IFZERO(). I would use these on a regular basis, and it would cut in half the size of large formulas where I just want something specific to happen where the result is either blank or zero

    185 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    11 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  12. Built-in RegEx / Regular Expressions Functions to Search, Extract, and Replace

    I've constantly found myself installing and re-installing add-ins that add RegEx Functions to Excel. Everyone I introduce them too finds them extremely useful. There's over half a million results in google for the query ["excel" ("regular expression" OR "regex")].

    426 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    28 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  13. Better compatiity with the Surface Pen

    With the surface pen, users should be able to write in any cell on a spreadsheet and excel will automatically convert the handwriting to digital numbers or letters when the user starts writing in a different cell (or maybe after users draw a special characters like a check mark or something like that to signal to excel that the user is done writing in that cell.)

    22 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    4 comments  ·  Graphics  ·  Flag idea as inappropriate…  ·  Admin →

    Cool idea. We have been exploring a number of pen ideas like this for Excel. We’ll definitely consider this one in our next round of planning. Please continue to vote on this feature idea.

    Thanks,
    Scott [MSFT]

  14. R in Excel (RRO + MKL as scripting language in Excel)

    Microsoft recently acquired Revolution Analytics:

    http://revolutionanalytics.com/

    Revolution R Open with MKL is an open source derivative of R (RRO + MKL). Adding-in RRO to Excel is a natural fit and will extend the scripting utility of .xlsx in Enterprise environment. The package developments alone are worth considering this integration.

    145 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Accepting Votes  ·  21 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  15. Conditional formatting in charts

    Add Conditional formatting in charts to control the colour of e.g. a bar or line, depending on the value or content of the data labels. Green if appels, Yellow if bananas and so on.

    135 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

  16. Rotate sunburst chart (& other controls)

    LOVE THE NEW SUNBURST. Great work, guys - please keep it up. Would like ability to rotate the sunburst chart (just like we can with the regular pie chart) and have much more control over the final product, such as: ability to turn visibility on or off for any segment (sometimes really important segments are not labelled because they are relatively small - please give us control), more control over colors of segments and sub-segments, better font size & text rotation of labels, more data label options such as pop-out / data callout and other options found on pie chart.

    66 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    11 comments  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →

    Good feedback. We’ll consider this in our next planning round. In the meantime, please continue to vote on this feature idea.

    Thanks,
    Scott [MSFT]

  17. Remember the chart type, chart formatting (and template) on Pivot Charts

    When you're charting a pivot table and have a combo chart - say stacked bar chart with a line chart - and you filter your pivot table so that one of the stacked bar elements disappears, the chart replaces the missing element from the line chart. Remove the filter and your line chart is still part of the stacked bar chart.

    I'd like the pivot chart elements to remain in their place even when there's nothing to show because of the filter.

    Additionally, any formatting applied via Chart Templates to Pivot Charts is lost on Pivoting, etc. - this formatting…

    115 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    28 comments  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →

    Thanks for the feedback. This is a known issue which we have concrete plans to fix. However, please continue to vote on this issue.

    Thanks,
    Scott [MSFT]

  18. Use F4 key to lock reference in a table

    When you create formula with the named range of a table, you can't easily block the reference of your column.

    For instance, if you used the fill-handle to copy to the right, the reference of your column will change :( The only way to avoid that is to write [[column1]:[column1]] for all your reference (very annoying)

    So my suggestion to block the reference of a named range is to use the F4 key.
    Your formula is =SUM(table1[column1]) and after pressing F4 it becomes =SUM(table1[[column1]:[column1]])

    140 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    15 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →

    Good suggestion Frederic – thanks for taking the time to post it. We’ll take a look at the F4 loop and including other functionality like this as soon as we can. We’ll be spending more time on the things with more votes – so folks that really want to see this should keep voting it up.

    Best,
    John [MS XL]

  19. Excel 2016 Waterfall Chart ...Enable Save as Template setting

    Enable the Save chart changes (e.g. Colurs on Waterfall) as Template for Waterfall. This is enabled for other Chart Types but not for Waterfall.

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

    We’ll send you updates on this idea

    5 comments  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →

    Thanks for your input. This limitation is true for all of the new chart types released in Office 2016; e.g. waterfall, histogram, treemap, etc. This is functionality we are assessing to enable for the new chart types. Please continue to vote on this feature idea.

    Thanks,
    Scott [MSFT]

  20. Tighter integration with MS Access

    Tighter integration with MS Access - improve (expand) object model to provide more powerful and transparent integration between Access, Excel and Word. Make it easier to create visual models using flexibility of Excel column / Row structure using MS Access datasets and VBA code.

    18 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →

    Thanks for the feedback. We’ll consider this in our future planning. Please continue to vote on this idea.

    Thanks,
    Scott [MSFT]

  • Don't see your idea?

Feedback and Knowledge Base