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.

    🇧🇷🇵🇹🇦🇴🇲🇿🇨🇻

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

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

  3. 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,025 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

  4. 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 →
  5. 1,249 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    991 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

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

    125 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  7. 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,682 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    568 comments  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
  8. 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,408 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

  9. 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/office2013release-excel/sorry-unable-to-find/595333d0-1463-499f-967e-4da8ac2e2047

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

    We’ll send you updates on this idea

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

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

    83 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 →
  11. 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]

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