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. Translate XLOOKUP and XMATCH to PROCX and CORRESPX in Portuguese

    That's it: PROCX and CORRESPX in Portuguese versions of Excel to keep the same standard of the other functions.

    🇧🇷🇵🇹🇦🇴🇲🇿🇨🇻

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

    We’ll send you updates on this idea

    25 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  2. Add an If_NA optional sixth argument to XLOOKUP

    The new XLOOKUP function introduced on August 28 2019 is awesome - exact match by default, the ability to return several columns at once, and search from bottom of data. But one thing would make it better - an optional sixth If_NA argument to provide an answer in case nothing is found.
    One of the benefits of XLOOKUP is to eliminate the need to nest MATCH inside of INDEX. If you are trying to reduce the number of functions this would be a low-impact way of eliminating nesting XLOOKUP inside of IFNA.
    For me, the main argument is that the…

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

    We’ll send you updates on this idea

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

    Thanks for the suggestions folks! We will be adding [if_not_found] as the 6th argument to XLOOKUP. The thinking is as follows:

    • It’s a reasonably common use case
    • The ISNA XLOOKUP approach cannot distinguish a “not found” from a #N/A returned from a valid match.

    - Joe McDaid [Excel]

  3. When copying tabs, somtimes we have to cycle through 100s of "Yes" or "No" to the "Name already exists warning" Can we add Yes to All option

    This is a major productivity killer for power users such as finance teams, and current UX does not help exit this state efficiently.

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

    We’ll send you updates on this idea

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

    Good news! We have released a few fixes to Insiders to address this issue. If you are on Insiders, please let us know if the fix has worked for you.

    The fixes should be in build 11809.10000 and onwards.

    -Joe McDaid [Excel Team]

  4. Pull Current Stock Prices and Historical Data Into Excel

    Now that our ability to use Yahoo! Finance's API to pull in stock information via the WEBSERVICE() function and import historical information is officially dead (thanks Verizon!), the only viable option currently is to use Google sheets to pull in stock information.

    It would be awesome if Excel could import data from MSN Money so us users can continue to use spreadsheets to monitor our portfolios.

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

    We’ll send you updates on this idea

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

    Hi everyone,
    Stock data types are now available to all Windows Office 365 subscribers with an English editing language installed (our data is only available in English at this time). You can find some instructions on how to use the feature here: https://support.office.com/en-us/article/get-a-stock-quote-e5af3212-e024-4d4c-bea0-623cf07fbc54. The feature will also be appearing in Excel for Mac and Excel Online in early 2019 – as usual, Office Insiders will see the feature before the general population. See http://aka.ms/officeinsider for more info.

    One pro tip to locate instruments on a different exchange is to include an ISO country code alongside the symbol, for instance MX MSFT will tell Excel to grab Microsoft from the Mexican stock exchange instead of Nasdaq. We’ll be publishing more thorough documentation in the near future.

    We also acknowledge that this is only half of the requested feature in this suggestion – the current stock prices piece. The ability to…

  5. Bring back Notes from the previous build.

    I don't understand why the old Note system was entirely removed. It functioned perfectly as a simplified system of comments. I just need to leave a small amount of additional data which can be viewed quickly by mousing over the cell. The new comment system is cumbersome by comparison, and adds no value for my purposes.

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

    We’ll send you updates on this idea

    1 comment  ·  Collaboration and Sharing  ·  Flag idea as inappropriate…  ·  Admin →
  6. 1,221 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    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

  7. Make a simple safer version of VLOOKUP and INDEX MATCH

    The majority of Excel users use VLOOKUP to get exact matches from a row or column, It would be good if they all used INDEX MATCH but it's more complex so how about this simpler version for the masses.

    =GETMATCH(ReferenceToMatch, MatchColumn/Row, GetColumn/Row, Optional Value if no match)

    If seen a few other references to updating VLOOKUPS and there are lots of opportunities, but it would be good to address the simple most widely used issue first.

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

    We’ll send you updates on this idea

    124 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  8. Stop Excel from changing large "numbers" (actually text values) to scientific notation.

    Prevent Excel from changing large "numbers" (actually text values) to scientific notation.

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

    We’ll send you updates on this idea

    564 comments  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
  9. Maintain leading zeroes when entering values in cells

    There should be an application setting OR paste recovery option OR cell format to retain leading zeroes when entering values in cells (either manually or through another means like CSV import).

    (2015-11-05 Dan [MS] Updated idea title and description to broaden this issue from maintaining leading zeros on CSV data import to maintaining them on any cell entry.)

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

    We’ll send you updates on this idea

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

    Thanks very much for your votes. And to those who took the time to fill in the survey, thank you! This is a brief update to let y’all know that we’ve started work on this feature request along with the one on changing numbers to scientific notation.

    - Urmi [Msft]

  10. Increase the 218 character filename length limit to open files in excel

    Excel can't open files with full path lengths greater than 218 characters as documented in https://support.microsoft.com/en-us/kb/213983. This is still a problem in Office 2016. It seems crazy that Excel can't open a valid file that the filesystem allows. People have been complaining about this since Office 2000. The thread below has over 11 thousand views and there are plenty others. Please fix this. http://answers.microsoft.com/en-us/office/forum/office_2013_release-excel/sorry-unable-to-find/595333d0-1463-499f-967e-4da8ac2e2047

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

    We’ll send you updates on this idea

    202 comments  ·  Opening and Saving Files  ·  Flag idea as inappropriate…  ·  Admin →

    Hello,

    Thank you for your continued feedback! We are happy to let you know that the work to enable this feature has started. We’ll share more details as we make progress.

    Thanks,
    David [Microsoft Excel Team]

  11. QAT Spacing

    The QAT spacing on the 2016 version is impossible to work with and forcing me to look at creating a new tab. I liked the spacing on 2013 which allowed me to view all my written macros and buttons. The new spacing pushed 5 of my buttons to a drop down. Please correct this spacing issue. The spacing does not need to be this large when you don't have a touch screen. I am one of 35 employees in my company that this effects. We have a customized QAT that all employees use.

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

    We’ll send you updates on this idea

    36 comments  ·  Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…  ·  Admin →
  12. Add User Voice Button to Excel interface

    To add a button to reach this page directly when there is a new idea to work on ... Ideas will come more fresh and easier to describe..

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

    We’ll send you updates on this idea

    3 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
    started  ·  Dan Battagin [MS XL] responded

    Great news – we’ve started work on this.

    The plan is to have a button under the File menu (something like File > Feedback > Submit Ideas for Excel) that will bring users here to UserVoice.

    Cheers,
    Dan [MS]

  13. Restore the pasting of tab separated text into columns from an HTML <pre> block and web data feed that has been removed from v16.0.7927.1020

    When using data/from web or pasting a table from word or pasting an HTML <pre> block from a web page the tab separated data used to get automatically placed into columns. With v16.0.7927.1020 this has stopped - all the data goes into one column. There remains the option (checked by default) to do this when ingesting data from the web, but it no longer happens. When ingesting data from a web feed, you can't use the "paste as text" option to achieve this effect, so this change in behaviour has effectively broken our application's reporting facility. It still works in…

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

    We’ll send you updates on this idea

    11 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?

Feedback and Knowledge Base