Feedback by UserVoice

Excel for Windows (Desktop Application)

Update: Microsoft will be moving away from UserVoice sites on a product-by-product basis throughout the 2021 calendar year. We will leverage 1st party solutions for customer feedback. Learn more

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. Mirroring Worksheets

    Sometimes I want to present some information to a client, but not all. Linking doesn't always work due to the possibility of inserting new columns or rows into the data. I would like to clone a worksheet and designate the original as the master worksheet. In the clone, I'd like to change formatting, hide cells, or add information, while mirroring the master data so I can keep my master data and still generate reports for others from the clone.

    3 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

    0 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  2. When altering a graph have an option to see the updated graph only after the settings window you had open is closed.

    For example when adding multiple data series to a scatter plot the graph is updated after each series is added. It can take a long time to add a new series after a few have been added, when using large amounts of data points. I suggest something like what photoshop does which allows you to disable updates until the current settings window is closed.

    I have found a work around. If you place the graph in excel so you can't see it and click "Format-select data" you can plot as many series as you like without lag since it is…

    3 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

    0 comments  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →

    Thanks for the feedback. We’ll consider this for a future release. Please continue to vote on this feature request which will increase its likelihood of getting in the product.

    Thanks,
    Scott [MSFT]

  3. Convert freeform shape to plot via x,y points

    I would like to draw a freeform shape using the drawing tools, and then apply a tool or function that allows me to replicate the shape in an x-y plot. I found some VBA code online that lets me find the vertices of said shape, and I can plot those vertices in an x-y plot, but it comes out as some sort of weird approximation. It reminds me of when you use Google translate for a phrase into one language, and then you translate it back.

    2 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

    0 comments  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →

    Cool idea. We will definitely consider it while planning our next round of features. Please continue to vote on this feature idea.

    Thanks,
    Scott [MSFT]

  4. Touch Gestures

    Introduce more touch/gesture functionality to desktop Excel. For example the rolling list selection (dropdown) like on phones and tablets.
    Example, drag and drop a selection of cells using fingers rather than the multi step thing.
    When touching the screen make user's finger transparent:) IOW show what's under you finger in a hover box.
    Regards
    Brian

    2 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

    0 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  5. Combo box dropdown should mouse scroll

    Currently the combo box for Form and Active X do not allow the mouse scroll feature after selecting the drop down. If you try to use the mouse scroll, it does not scroll through the list items and may even scroll the sheet instead (if mouse hovers out of the list area).

    6 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

    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  6. Custom sort with UDF as Comparer

    When using the standard Sort dialog, it would be extremely useful for the 'Sort on' column to accept custom UDFs to implement the comparison of the values in the selected column.

    So the 'Sort on' values would be:
    * Values
    * Cell Color
    * Font Color
    * Cell Icon
    * UDF...

    Clicking 'UDF...' will bring up a dialog displaying all UDFs implementing the IComparer interface. The user can select which one they want to use.

    This will enable many scenarios such as sorting by IP addresses, MAC address etc. where standard alpha-numeric sorts don't work - they give incorrect sort…

    2 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

    0 comments  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
  7. Add Conditional Formatting for enumerated values

    When a Column or Row contains enumerated string values like ("Large", "Small", "Medium"), or ("Bob", "John", "Anna") it would be useful to automatically assign a color based on the cell contents.
    Currently, this requires to add one rule for every possible value of the type 'equals to "..."'.
    It suggest to add a Conditional Formatting rule that assigns a unique color per unique value (based on some color set)

    2 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

    0 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  8. When loading tab delimited Text

    When loading/opening tab delimited Text document that has fields such as 150:10 200:10 it automatically treats them as date fields and adds a trailing :00 to the end so it would look like 200:10:00, this really disrupts the development of my game and I have to keep the excel documents as the master copy.

    It would be nice to be able to load the text document as is and not have any "formatting" added automatically.

    2 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

    0 comments  ·  Opening and Saving Files  ·  Flag idea as inappropriate…  ·  Admin →
  9. Add a funciton to search in a string from the end (INSTRREV)

    Please add a formula that works like INSTRREV in VBA.

    (2016-03-08 Dan [MS] - updated title to include INSTRREV, when merging in duplicate idea)

    9 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

    3 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  10. From a chart's series to x/y values range with a right click menu option

    Consider adding these options to a selected series' or datapoint context menu:
    . Go to the X values range
    . Go to the Y values range
    . Go to the series name range
    . Extend/contract series range by n cells.

    I've actually implemented all of this for my own use in VBA, with keyboard shortcuts. So Alt+Right extends every range one cell, Alt+Shift+Right extends every range 20 cells, Ctrl+i in a chart takes me to the X values range (or cell, if a single data point is selected). HUGE time saver.

    2 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

    0 comments  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →

    These are interesting ideas. Thanks for the feedback. We’ll consider this for a future release. Please continue to vote on this feature request which will increase its likelihood of getting in the product.

    Thanks,
    Scott [MSFT]

  11. Spellcheck should include text in linked pictures from other sheets

    My clients produce master spreadsheets containing sections of text as linked pictures from other sheets in the same files. After processing the master spreadsheet, I do a spellcheck, which tells me "Spellcheck complete. You're good to go." But I'm not really, because spellcheck doesn't look at those linked pictures. I only just discovered this. Now I have to spellcheck each sheet separately. Either make spellcheck work properly, or at least provide a warning of what hasn't been checked.

    5 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

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

    Thanks for the feedback. We’ll consider this in our planning for a future release. Please continue to vote on this feature idea.

    Thanks,
    Scott [MSFT]

  12. Ability to customize the Open page

    In Excel 2016, Open gives a nearly blank page with the only options being Recent, This PC, Add a place or browse.

    Why is there no way to add a specific data directory?

    "This PC" give a list of files under the C: My Documents which is not where my Excel data is held with no way of changing or adding to it.

    To select the relevant directories I need therefore each time I need to go through the pain of browsing for it. There needs to be a "Favo(u)rites" in the same way as Explorer has. There is loads…

    3 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

    0 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  13. An easier way to populate a listbox or combobox with unique (distinct) values from a range

    It is possible but should be easier than using a Collection or Dictionary etc.

    For example,

    Me.ComboBox1.RowSource = "A1:A10", xlDistinctValuesOnly

    or

    Me.ListBox1.RowSource = "A1:A10", xlDistinctValuesOnly

    2 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

    2 comments  ·  Flag idea as inappropriate…  ·  Admin →
  14. la mejor forma de mejorar excel 2016, es corrigiendo el error de filtros de mas de 100,000 registros. actualmente se cuelga y no funciona.

    la mejor forma de corrigir excel 2016, es corrigiendo el error de que se cuelga cuando maneja mas de 100 mil registros. cuando realizamos un filtros el mismo se cuelga. no sirve para trabajar con mucha data. si trabaja con mucha data no instale office 2016.

    2 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

    2 comments  ·  Flag idea as inappropriate…  ·  Admin →
  15. Fix the interaction between macros and Power Pivot/Power Query

    If you have any personal macros (or even a macro worksheet in your XLSTART folder), PowerPivot and Power Query both break—it's been a big bummer having to get rid of all my old macros to use my data models.

    3 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

    0 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  16. Dynamic scrolling in pivot tables as seen on some webpage so that the current hierarchical level is always visible

    Dynamic scrolling in pivot tables as seen on some webpage so that the current hierarchical level is always visible

    2 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

    0 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  17. Excel 2016 Desktop Power Query takes ages to refresh from Azure SQL Database. Make refresh faster.

    In Excel 2016 Desktop, it takes very long time for Query to refresh from Azure SQL Database (such as Access Web Apps database). Even when the whole Query is connecting to a single small table, refresh takes + 5 minutes sometimes. This Refresh should be made faster.

    2 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

    0 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  18. Allow direct editing in cells

    Please make an icon in the ribbon for de/activating direct editing in cells.

    2 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

    0 comments  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
  19. Make search and replace work in textboxes

    I have a large spreadsheet with hundreds of textboxes containing a certain word that I need to change to something else. Search and replace tells me "We couldn't find what you were looking for." Textboxes have been a part of Office ever since I can remember. Search/replace should cover them.

    6 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

    2 comments  ·  Flag idea as inappropriate…  ·  Admin →
  20. Editing a formula in a cell should not overlap the neighbouring left and right cell

    When you type a formula in a cell, the full formula is displayed in the grid. If the formula is long, is starts overlapping with cells on the left and right of the edited cell. But it then means you cannot insert the coordinate of these overlaped cells in the formula by clicking on them because what you actually do is click on the formula. When editing a formula in a cell, the display of the formula must be constrained to its cell borders to allow neighbouring cells to be accessible for the click.

    7 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

    2 comments  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?

Feedback and Knowledge Base