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. 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,751 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

    499 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

  2. 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,532 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

    222 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

  3. Pick color in Excel Like at Powerpoint

    In Powerpoint there is a color picker tool to bring custom colors to the pallete.

    Many times we need to do it using PowerPoint to get the RGB combination to be used in Excel.

    Could you replicate this color picker into Excel in the same way it exists in PowerPoint?

    Portuguese:

    Conta-gotas PowerPoint

    No Powerpoint existe uma ferramenta para pegar as cores e retornar para a paleta, o conta-gotas.

    Vocês podem fazer o mesmo no Excel?

    Porque muitas vezes nós precisamos fazer isso usando o PowerPoint para pegar o RGB e colocar no Excel.

    1,142 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

    109 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  4. 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…

    890 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

    107 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  5. 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.

    876 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

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

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

    649 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

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

    600 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

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

    Thanks for all your support of this request. We are taking a close look at this along with the related requests about maintaining leading zeros when entering values in cells, and to stop changing values to scientific notation.

    We know these are important issues, so thanks for all the comments and votes.

    Steve [Microsoft Excel]

  8. Improve the Conditional Formatting Manager

    So that we can easily manage conditional formatting. While we're at it, the way conditional formatting is treated when cutting / copying and pasting etc could be reconsidered.

    [Following examples added by the Excel team for clarity]
    * name rules
    * add a comment to rules
    * more easily see what rules apply to what range
    * see which rules can be consolidated b/c they are similar
    * have an option to LOCK THE RANGES so they never change no matter what cells in the sheet get moved or copied or deleted, either manually or by adjusting pivot tables
    *…

    517 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

    101 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →

    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]

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

    485 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

    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]

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

    389 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

    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]

  11. Make it easier to find external links

    Not just break them - help us to find where they are. It's time consuming to look in charts, data validation, conditional formatting, data and shapes.

    357 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

    33 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  12. Add Power BI Dataflows as a data source in "Get & Transform Data"

    Please add Power BI Dataflows as a data source so that I can import data from a Dataflow into the local spreadsheet/data model.

    https://docs.microsoft.com/en-us/power-bi/service-dataflows-create-use

    349 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

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

    Thanks everyone for showing a lot of passion about Dataflows data connector in Excel! We’re evaluating our future investments and your votes help us to prioritize. Please keep voting if you like this idea.

    Guy Hunkin
    Principal Program Manager
    Excel Team

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

    318 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

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

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

    298 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

    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]

  15. Improve Data Validation (make it AutoComplete based on typed characters)

    Data Validation needs an auto complete in the List Option
    It also needs to support Table Structured references directly in the List option without having to wrap it in a Name

    287 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

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

    Hi all – thanks for your support for this suggestion.

    Improving data validation drop down lists by adding autocomplete is a great idea, as well as supporting structured table references in the data validation Source range.

    Steve – Microsoft Excel

  16. Invert Filter Selection

    I'd like to see an option to invert filter selections. For example: If i apply a filter in a table i can select some boxes with a tickmark, but if i want to invert my selection i need to unmark selected itens before and mark the others.

    In resume, i'd like to invert itens selected in a filter for the others unmarked.

    285 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

    51 comments  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
  17. Include Median in Pivot Table Value Field Settings

    Current summarization options include count, sum, average, min, max, etc., but median is not available.

    268 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

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

    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.

  18. Auto resizing of formula bar

    Give us an easily accessible option to have the formula bar resize automatically if a formula spans across multiple rows in the formula bar so the whole formula will be visible.

    257 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

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

    Thanks for the suggestion. I think I’ve seen some related requests, I’ll look at merging them to make sure the votes properly reflect the ask. We’ll prioritize this into the execution pipe appropriately based on the number of votes.

    Cheers,
    John [MS XL]

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

    240 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

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

    216 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

    12 comments  ·  Performance  ·  Flag idea as inappropriate…  ·  Admin →

    Thanks for the post Charles! And thanx to folks for voting. Much appreciated. We definitely understand the ask and are keeping a close eye on this as it is moving up the vote charts .

    As always, please keep upvoting the things you are about most.

    Thanx,
    Prash [MS XL]

← Previous 1 3 4 5 6 7 8
  • Don't see your idea?

Feedback and Knowledge Base