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.

How can we improve Excel for Windows (Desktop Application)?

(thinking…)

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can support and comment on it.

If it doesn't exist, you can post your idea so others can support it.

Enter your idea and we'll search to see if someone has already suggested it.

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. Save as option when right click on the sheet tab

    I want to be able to save a single sheet(or just selected sheets) to a new file - if I have many sheets I need to delete the ones I do not need after saving to a new file.

    2 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Opening and Saving Files  ·  Flag idea as inappropriate…  ·  Admin →
  2. Content Pane Remove Size Limit, Add Positioning, Resizing

    There is a limitation to the width and height of a Content Pane at 1000 x 1000px. This limit is imposed when resizing via mouse in Excel Desktop and the JavaScript API. This (via mouse) is not true in Excel Online (or in PowerPoint) where the size can be set and saved to any size via mouse.

    It would make the Content Pane consistent and open up a huge number of innovation opportunities to remove the current 1000 x 1000px limitation in the JavaScript API and Desktop Content Panes in Excel.

    The ability to position and resize the Content Pane…

    6 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  3. Better Support for Analysis Services Tabular

    It's about time to improve support for SSAS Tabular:
    1. Auto-generate DAX
    2. Avoid splitting a table into a "measure group" and "dimension". See how PBI Desktop handles metadata.
    3. Carry over data types so that users can create reports, such as show me invoices where Due Date is greater than ... Currently, all dimension table fields map to Text.
    4. Many customers have expressed interest to connect Excel tables directly to Tabular, bypassing Pivot Table, so they can use the column dropdowns and other Excel goodness.
    5. Support descriptions as tooltips when the user hovers on a field in…

    63 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  4. I need to open documents that have numbers starting with zeros without Excel dropping the zeros

    open documents that have numbers starting with zeros without Excel dropping the zeros

    15 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Opening and Saving Files  ·  Flag idea as inappropriate…  ·  Admin →
  5. MS Office 365 ProPlus, Excel / Access date recognition bug

    MS Office 365 ProPlus, Excel Version 1808, Build 10730.20280

    What I did:
    1. Copy column B to C
    2. Replace "2018" with "2019" in column C

    What is the result:
    - German month names are recognized
    - English month names only recognized for Apr, Aug, Sep, Nov

    What I would expect:
    - English month names are recognized as well

    Same result within MS Access

    1 vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Application Errors  ·  Flag idea as inappropriate…  ·  Admin →
  6. Name a dynamic array (rather than use "A1#" notation)

    The new dynamic array notation is incredibly powerful, but one thing that makes formulas complicated is the "A1#" notation when used in formulas.

    It would be great if you could (easily) assign a name to it in the same way that you can name an Excel table.

    It would be much easier to see:

    =SUMIFS(TABLE1[totals],TABLE1[dept],departments)

    than

    =SUMIFS(TABLE1[totals],TABLE1[dept],B1#)

    I am able to define a named range for these values, but that is a bit clunky. It would be great if the naming was exactly the same as Table naming (e.g. in an ARRAY context menu like the TABLE context menu).

    10 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  7. Fuzzy Match in Power Query Excel

    Include Table.FuzzyNestedJoin fuzzy match capability in Power Query Excel

    3 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  8. How about a function to enable data to be swapped from one cell to another, eg if you want to move an item up a list to another cell and hav

    A function to allow you to swap data from one to another, eg when constructing a list of priorities, if you have data in a cell that you want to move up a list to a cell that already has data in it then that data should have an option move to the cell that was just vacated. This would help when prioritising cell contents without the need for inserting cells, cutting & pasting and remembering what you have pasted over when cutting cells.

    2 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
  9. Correct illogical limit of 255 characters for entering Matrix formulas using VBA

    When you use Excel, you have a limit of 8192 for the lenght of a formula.

    When you assign a matrix formula using VBA, it is restricted to 255.
    Even using macro recorder, it'll save the correct instruction, but then it'll be useless as VBA won't execute that instruction.

    6 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  10. New Template, Investment Tracker, Use in UK

    This is a great idea. But I am in UK and entering my shares does not work.
    (XLON:RDSB) produces a field error.
    (XLON:AV.) produces a US$ price which is about 10 times the actual £ price.
    The template is just what I need; but as with many others I have looked at it is not easily adapted for UK use. This severely limits the value of their subscription for UK users of Office 365.

    Can UK versions be supplied, please?

    1 vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  11. More vba events

    VBA events are extremely powerful but currently they are seriously lacking! If the Excel team went through and exposed more events VBA would a lot easier to manage for complex applications.

    Events to expose:
    * Row and column insertion
    * Table specific events:
    ** Table - Insert_Row
    ** Table - Insert_Column
    ** Table - Cell_Change
    ** Table - On Filter
    ** Table - On Filter button click
    * Chart events!
    ** Chart - On Mouse Down
    ** Chart - On chart object select
    ** Chart - On chart resize
    * Shape events
    ** On shape resize
    ** On shape click …

    12 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    4 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  12. A tool is needed for auditing Conditional Formatting formulae

    Conditional formatting allows a formula as part of a rule, and that formula may refer to another cell in the workbook. If that other cell is deleted, then a #REF error creeps into the conditional formatting formula.
    Of course a properly constructed formula would allow for such circumstances, but there is no simple method to check the conditional formatting rules to validate them.
    It would be helpful to have a way to download the conditional formatting rules to allow the programmer to audit those rules.

    3 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  13. Filter Option - for 6 Months

    In Filter, there are options for Last Week, Month, Quarter & Year. There could be following 2 options that can help user a lot:
    1) Last 6 Months
    2) First 6 Months (Current Year)

    26 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    12 comments  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
  14. undo by cell

    Have a way to undo the last thing that was done to a specific cell, without having to undo everything that has been done since that. I have a workaround, but it is a bit involved.

    3 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
  15. add to the ribbon a nummeric up-down control

    Not only to excel but to all of office
    implement getmin, getmax, getvalue

    3 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    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. Sync ribbon settings

    I want to sync settings that is ribbon customize in my O365 account.
    Now I need export ribbon and import.

    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  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  17. A formula to calculate the direction of a vector from 0 to 360 degrees.

    The formula is working for any value of x and y, is not using any trigonometric function and give the result with an accuracy of one billionth of the degree.

    f(x , y)=180/pi()*(pi()/8*sign(x*y)*sign(y^2-x^2)+pi()/4*(4-2*sign(y)-sign

    (x*y))-pi()/2*(1-sign(y^2))*(sign(x^2)+sign(x))-
    n=0
    sign(x*y)*Σ(-1)^n*((abs(x)*(sqrt(2)-1)^(x^2-y^2)-abs(y)/
    n=17
    (abs(x)+abs(y)*(sqrt(2)-1)^(x^2-y^2)))^(2n+1)/(2n+1))

    2 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  18. Copy multiple selections into Clipboard

    I've always wanted the option to copy multiple selections to the clipboard. When you paste, you'd be presented with the option of everything on your clipboard, to be able to pick which selection(s) you want to paste.

    10 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  19. Parameters passing to Named Ranges

    I'd like a simple passing of parameters to Named Ranges that would work similarly to the way they are passed to functions:

    =VLOOKUP(A12,People,2,FALSE)

    for example. Similarly, if I had a Named Range (call it "Horse") that implemented the VLOOKUP() function and desired to pass it the first and last parameters needed by VLOOKUP(), I would enter:

    =Horse(A12,false)

    I CAN do this, with a LOT of work to set it up each time, and not, um, precisely looking the same, but close:

    =Horse + N("A12,false")

    but again, not only is the work involved onerous, the bulk of it means that a…

    1 vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  20. Set default to Copy - paste visible only, opt into paste hidden

    Set default to Copy - paste visible only, opt into paste hidden
    The Default setting should be able to be set for visible only with paste special being for hidden.

    Really annoying when working with filtered lists and pasting on everything hidden and not knowing / forgetting.

    3 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

Feedback and Knowledge Base