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

    We’ll send you updates on this idea

    483 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. Have Excel scroll better when there are large cells.

    If there's a really tall or wide cell, Excel jumps to the edge of the cell when scrolling past that area. This is a big pain when, for example:
    - trying to position a shape
    - Trying to grab the edge of the row or column in order to resize it.

    Excel should just scroll normally without jumping.

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

    We’ll send you updates on this idea

    838 comments  ·  Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…  ·  Admin →

    Thanks everyone for all of the passion about this suggestion! The number of votes has increased greatly in the last couple months and we’re taking notice! We’ve got a bunch of other Excel endpoints behaving this way already and we’re evaluating getting it done in the Windows versions sooner based on the number of votes it gets – so keep the votes coming!

    Eric Patterson (Program Manager – MSFT)

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

    We’ll send you updates on this idea

    625 comments  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
  4. 1,616 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1128 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

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

    We’ll send you updates on this idea

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

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

    We’ll send you updates on this idea

    209 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

  7. Restore MDI file handling (open all files in one window); Kill SDI (each spreadsheet opens in a seperate window)

    In the good versions of Excel (prior to 2007) one could open multiple workbooks in the same window. Now, one has multiple instances of Excel (and every other Office app) whenever one opens more than one document / spreadsheet.

    Again, here are the issues:


    1. Stability - I experience ~3X Excel crashes in 2016 (SDI) as compared to 2010 (MDI)

    2. Screen Space / Real Estate - Drastically reduced screen space when each workbook requires its own Ribbon, Quick Access Toolbar and Formula Bar

    3. Toolbar to Workbook Confusion - One Ribbon + Quick Access Toolbar + Formula Bar to control all workbooks…
    1,260 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    960 comments  ·  Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…  ·  Admin →

    Thanks for all of the votes – the team has definitely taken notice of the activity around this issue. We moved to SDI as a result of customer requests, but it looks like we’ve got work to do to really nail the use cases people care about. From a read over the comments, I see a number of cases that we will want to investigate further as we think through MDI vs SDI. We’ll get someone from the team to take a deeper look, and we may reach out to some of you for more clarification as we go. Thanks again for all the voting and passion here!

    John, Excel

  8. Link the min and max values of a chart axis to cell value

    It would be nice to be able to link the min and/or max value of an chart axis to a cell reference instead of manual enter the value or the auto function.

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

    We’ll send you updates on this idea

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

    We’ll send you updates on this idea

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

  10. Make Undo stacks track per workbook instead of globally

    Undo stacks are currently global between all workbooks that are open at a given time, so pressing undo on one workbook might undo a change in a different workbook. As someone who frequently has multiple workbooks open at a time, it would be much more helpful to be able to step through the edits made on each individual workbook.

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

    We’ll send you updates on this idea

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

    Thanks again for all the passion on this issue – we hear you and we’ll get someone on the team to dig in to the issue. I’ve seen a few related sub-issues while scanning over the comment section for this one, so we may reach out to a few of you for clarifications. Thanks again for all the votes, and keep them coming for the issues you care about!

    John, Excel

  11. Conditional formatting - Apply to named ranges

    Currently if you apply conditional formatting to a named range (i.e.. a range named via the Name Manager or a table style named-range), the value in the "Applies to" column of the Condidtional Formatting Rules Manger will revert the named range to its absolute cell reference.

    eg. "Applies to: =Table1[Column3]" becomes "Applies to: =$C$2:$C$7".

    Apart from being more difficult to read, it creates other complexities. e.g. if I happen to copy/paste a cell into this range, it creates a mess in the rules manager, creating a new rule for each cell pasted.

    e.g. if my named range is 'Table1[Column3]' which…

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

    We’ll send you updates on this idea

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

    Thanks to Graham for starting this conversation. If you would also like Excel to maintain named range references and structured table references in the “applies to” field for Conditional Formatting rules, please add your comments and vote this one up. We will prioritize accordingly.

    Thanks,
    Steve (MS Excel)

  12. Give us a proper NULL() worksheet function.

    This would make calculations and charts treat a cell containing a formula as a blank cell, not as a cell with a text string ("") or as a zero.

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

    We’ll send you updates on this idea

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

    Great suggestion – thanks again for taking the time to put it on this site and for the thoughtful followup comments. This is pretty related to some other work we’ve got going and already has a fair number of votes, so we’ll work on getting plans in place now and hope to get started on this soon.

    Thanks,
    John [MS XL]

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

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

    We’ll send you updates on this idea

    96 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  14. Filtering Needs to Work in Co-Authoring

    Say that several people are editing the same workbook. If Tom filters to show only his records, then the other people will only see Tom's records. We need to be able to have each person apply a different filter and see only their records.
    Note that it is fine to require that the workbook can not have SUBTOTAL or AGGREGATE functions in order for independent filtering to work. If you allow these functions, then everyone will have different calculation results which would be problematic.
    It is more important to us to be able to have each person apply a local…

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

    We’ll send you updates on this idea

    76 comments  ·  Collaboration and Sharing  ·  Flag idea as inappropriate…  ·  Admin →
  15. Unhide multiple worksheets at once

    We can hide several worksheets at once, but we can only show them individually.

    Although the VBA can solve this issue with some lines of code, but it would be a great improvement if you add this capability to Excel as a build in feature.

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

    We’ll send you updates on this idea

    65 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  16. 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.

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

    We’ll send you updates on this idea

    210 comments  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
  17. Visually show which cells are selected even when another application has focus

    Currently, when I select one or more cells and then switch to another application, the boundary box and shading for the selected cells are not shown. Other Office applications exhibit this behavior as well--selection highlighting is only displayed when the program has focus. Many (most?) non-Office applications show the highlighting at all times.

    It would be far more useful to be able to glance at the spreadsheet and see which cells are selected, even when working in another program.

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

    We’ll send you updates on this idea

    51 comments  ·  Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…  ·  Admin →
  18. 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")].

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

    We’ll send you updates on this idea

    32 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  19. Number format thousand separator and no decimals

    Every time (many days a year) I train people in Excel, someone ask why there is no button or shortcut to obtain a number format with "thousand separator and no decimals". At least - in northern Europe - this is the most common used number format. If "button-solution" not possible for Microsoft in order to have common buttons world-wide, at least a shortcut for this has been much appreciated. (Note that the current button for thousand separator and two decimals could not be used, though the alignment in that format are not disired/good and two decimals used).
    Today I teach…

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

    We’ll send you updates on this idea

    106 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  20. Allow interaction with Excel while in Power Query

    Please make the Power Query editor window (Get Data) non-model. When building complex queries, we often need to go back to Excel to change a worksheet and look at data. Right now, the Power Query editor window takes control over the application, preventing interaction with Excel.

    The current behaviour makes it very difficult to do things like the following:
    -Mid query, go back and check a worksheet to see exactly what a cell value may be that you want to refer to
    -When we have a static table in Excel and are trying to build a query that lands an…

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

    We’ll send you updates on this idea

    39 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
← Previous 1 3 4 5 345 346
  • Don't see your idea?

Feedback and Knowledge Base