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. Bring Power Pivot closer to Power BI Desktop Functionality

    Development for Power Pivot for Excel seems to have stopped around 2016. TREATAS got added as a DAX function that works, but it never got added to Intellisense, and that was nearly 3 years ago.

    Today, the two measure editors (still no idea why there are different ones) are a very VERY poor substitute for the fantastic DAX editor in Power BI Desktop. It is a real pain to properly tab and indent in the Excel Measure editor(s).

    In the last year there have been about a dozen new DAX functions and several updated functions per https://docs.microsoft.com/en-us/dax/new-dax-functions but NONE of…

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

    We’ll send you updates on this idea

    5 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  2. Add Center Across Selection to the Merge & Center Drop-down

    Do you hate Merged Cells? Do you believe Merged Cells are evil? Do you curse every time your selection rectangle goes from one column to five columns just because you touched a merged cell? Do you constantly get workbooks from co-workers who continue to merge cells? Tired of not being able to Sort or Paste because someone merged a cell?

    Excel encourages people to use Merge & Center by offering it front-and-center on the Home tab. Thus, few people discover the (superior) Center Across Selection option on the Alignment tab of the Format Cells dialog.

    Currently, the Merge & Center…

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

    We’ll send you updates on this idea

    107 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  3. Add a lock symbol on the protected sheet tab

    A small lock symbol on the protected sheet tab would be a little addition but visually important!

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

    We’ll send you updates on this idea

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

    Hi – due to concerns expressed by people who did not like the way the lock symbol was added to protected sheets, we will stop showing it on sheet tabs in Excel for Windows for the time-being. We may bring it back in the future in some other fashion.

    If you’d like to see a lock symbol or some other visual indicator when a sheet is protected, please add your vote and comment here.

    Here’s the related discussion – https://excel.uservoice.com/forums/304921/suggestions/40858108

    Many Thanks – Steve [Microsoft Excel]

  4. Add support for custom data connectors (Power Query M extensions)

    Custom Data Connectors mechanism is being developed by Power BI Desktop team:

    Excel's Get & Transform engine (Power Query) should have support for .mez/.pqx extensions too.

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

    We’ll send you updates on this idea

    8 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  5. Get Tables working on protected sheets (add rows, sort, filter, etc.)

    I would like to be able to, under the right circumstances, have the ability to add/remove rows of a table which resides on a protected sheet.

    Currently if you protect a sheet you can't insert/delete rows of a table. Even if you unprotect all cells and allow inserting/deleting of rows on sheet protection, it doesn't matter and is completely ignored.

    What I am proposing would have to follow specific rules:


    • Table cells would have to be unprotected

    • Cells below table would have to be unprotected (truly optional † )

    • Insert Rows would have to be specified in sheet protection

    †…

    1,439 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    216 comments  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →

    Thanks for logging this great suggestion, Zack, and to others for voting it up. We’ll prioritize this according to the number of votes, so if there’s more interest, please make sure to register your vote!

    Thanks

    Ashvini Sharma
    Lead Program Manager
    Excel

  6. "Power BI Service" as a data source in "Get & Transform"

    It would be awesome if "Power BI Service" is added as a data source under "Get Data" in "Get & Transform Data" in Excel. Though the source availability is already there with "Power BI Publisher Add-in" but it is buggy and hard to deploy on large number of laptops/desktops. Also, it is practically very difficult to educate down the line users about re-enabling this add-in via COM Add-ins in case it disappears from the ribbon which is very frequent in case of this add-in. We have been struggling with this for a long period of time now.

    Considering "Power BI…

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

    We’ll send you updates on this idea

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

    Hi Deepak,

    Thanks for logging this issue. I agree this would be quite useful, especially as Power BI is emerging as a hub for business data.

    This request is slightly different than what PBI Desktop does. PBI Desktop essentially provides a Live Connect essentially deferring the model to the service and limiting the experience to visualizations so it’s not importing data into the report. So there’re two possible outcomes you could be looking for:
    1. Allow users to import data into Excel as query tables, just like one can from an external store like SQL Server or Oracle. This provides fine grained data retrieval.
    2. Create a new PivotTable that summarizes data on PBI service.

    The PBI Publisher addin performs #2. Is that what you’re looking for? Or would you rather have #1 if you had to choose?

    Others coming new to this suggestion, please be sure to add your…

  7. Make slicers visible "On Demand".

    Allow the user to configure if the slicer is always in view or pops up on-demand. Activation/visibility could be triggered by selecting a visible report filter field or pivot table column header. Alternately, a report filter field could be configured to pop-up a slicer instead of, or in addition to the normal selection box. Another alternate would be to have report filter field style boxes independent of the pivot table range which would pop-up the slicer when selected. Lastly, a slicer selection panel could be added with a list of parameters to choose which would cause the slicer to pop-up

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

    We’ll send you updates on this idea

    4 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →

    Hmm.. interesting thought, and I can see how useful this could be!

    Hmm.. interesting thought, and I can see how useful this could be!Others that haven’t yet registered their vote for the item, please do so to help us understand the relative value of this item vs. the others on our backlog.

    Hmm.. interesting thought, and I can see how useful this could be!Others that haven’t yet registered their vote for the item, please do so to help us understand the relative value of this item vs. the others on our backlog.Thanks for the suggestion & the votes!

    Hmm.. interesting thought, and I can see how useful this could be!Others that haven’t yet registered their vote for the item, please do so to help us understand the relative value of this item vs. the others on our backlog.Thanks for the suggestion & the votes!Ashvini Sharma
    Lead Program Manager
    Excel

  8. Make quick measures like in Power BI available in Excel as well

    In Power BI we can easily create quick measures: https://powerbi.microsoft.com/en-us/blog/quick-measures-preview/
    This makes it so much easier for newbies or occasional users to adopt the new technologies, so please add in Excel as well.

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

    We’ll send you updates on this idea

    1 comment  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →

    Hi Imke & others,

    Thanks for logging this suggestion and voting on it. Yes indeed this would be very useful to make it easier and quicker.

    For those that’d like to get this done, please be sure to register your vote to help us prioritize against out backlog.

    thanks

    Ashvini Sharma
    Lead Program Manager
    Excel

  9. Python as an Excel scripting language

    Let us do scripting with Python! Yay! Not only as an alternative to VBA, but also as an alternative to field functions (=SUM(A1:A2))

    6,641 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    Wow.

    Thank you to all those participated in our survey. What an amazing number of responses, many of them with very deep content. We’re processing the over ten thousand responses(!), and already appreciate the time so many of you took to answer with passion and experience.

    Please know this survey is used to help influence various topics – both on Python as well as other related topics that the comments started to bleed into. Given the passion, I want to be clear this remains an area of exploration for us, without any specific timeline.

    We’ll provide updates as we progress on this feature request.

    Thanks!

    Ashvini Sharma
    Lead Program Manager
    Excel

  10. Add Fiscal Month and Fiscal Year to the Query Editor "Add Column " Date Button

    The Query Editor allows you to easily create Year, Month, Month Name etc, but many people need Fiscal Month Number and Fiscal year

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

    We’ll send you updates on this idea

    4 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  11. provide an option to set Excel's default paste behavior

    When you do an ordinary paste like Ctrl+V, Excel pastes the cell values, formatting, validation, everything. However, many users usually paste only values when working, and the extra handling to paste special is not productive.

    Word and OneNote have a setting that allow the user to choose the default paste type, and that should also be available in Excel.

    I know there are add-ins to workaround that and also the shortcut AppKey+V to paste values, but I think that should be a native Excel setting.

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

    We’ll send you updates on this idea

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

    This is a great suggestion, and we want to keep the interest going. Thanks to everyone who has already voted and commented on the suggestion to have an option for the default paste behavior in Excel.

    Sorry that we’ve been slow to comment and update the status on this one.

    Steve K [Excel]

  12. Adding comment (tool tip) in chart (to various elements of the chart, data points, etc.)

    To be able to add comments to a specific data labels in a chart (can be bar chart, line chart)

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

    We’ll send you updates on this idea

    6 comments  ·  Collaboration and Sharing  ·  Flag idea as inappropriate…  ·  Admin →

    Thanks for the feedback. This is an interesting idea that we’ll consider for a future release. Please continue to vote on this feature idea.

    Thanks,
    Scott [MSFT]

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

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

    We’ll send you updates on this idea

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

  14. Add ability to collapse field areas in PivotTable Field and Area Side by Side view

    With the ability/normal experience of creating many DAX measures in Power Pivot, the Values area of the PivotTable design is now too small to use effectively. Since the Values area only shows about 4 rows it's really difficult to organize fields correctly when try to drag fields around if you've got 10 or more fields in your Values area. (not at all uncommon for Power Pivot users, although certainly not restricted to them.)

    With the introduction of slicers, however, we also tend to use the Report Filter area less, and don't usually add as many fields to the row/column areas.

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

    We’ll send you updates on this idea

    12 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →

    Hi Ken,

    Thanks for logging this one, and thanks to others for voting this up.. We’ve actually had this on our list to get to for some time and have been balancing doing this against other… The more the community helps us rank it higher, the better the signal on overall importance… so, for those that haven’t voted for this but want it, do vote!

    thanks
    ash [MS XL]

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

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

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

    We’ll send you updates on this idea

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

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

    378 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 →

    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]

  17. 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!

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

    We’ll send you updates on this idea

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

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

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

    We’ll send you updates on this idea

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

  19. 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")].

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

    We’ll send you updates on this idea

    39 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  20. 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…

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

    We’ll send you updates on this idea

    6 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
← Previous 1 3 4 5 6 7
  • Don't see your idea?

Feedback and Knowledge Base