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. Anti-aliasing on diagonal borders

    Diagonal borders are common to X out a cell. The problem is that you can see the jaggedness as the borders' edges step through each row and column of pixels. Most other visuals in Excel are smoothed out.

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

    We’ll send you updates on this idea

    0 comments  ·  Graphics  ·  Flag idea as inappropriate…  ·  Admin →
  2. Grouping in Power Pivot reports

    To be able to use Grouping in Power Pivot reports as is works in Pivottabels.

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

    We’ll send you updates on this idea

    1 comment  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  3. Suggest formula simplifications to the user

    For those without a strong Excel, math, and/or computer science background, formulas can be much more complicated than they need to be. To help them along, Excel could suggest simplifications to commonly used simplifiable expressions. It would be like a spell checker, but for logic.

    Here are some simplifications that I've done over the years:
    IF(A1=1,"",IF(A1<>1,"s","error")) has an unreachable part "error" and becomes IF(A1=1,"","s").
    NOT(A1<B1) becomes A1>=B1.
    IF(A1<0,0,A1) becomes MAX(A1,0).
    DATE(YEAR(A1),MONTH(A1)+1,1) becomes EDATE(A1,1).
    SUMIFS(,,"="&A1) becomes SUMIFS(,,A1).
    (A1B1)+C1 becomes A1B1+C1.
    ...
    and so on.

    2 votes
    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 →
  4. vlookup should treat the lookup value as it APPEARS

    If you VLOOKUP (or HLOOKUP) 123 (or a range containing 123) into a range which clearly has 123 in it, but the latter is formatted as text, it doesn't find it. If it LOOKS right, it should find it!

    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  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  5. Really badly need "Total Editing Time" as a property.

    It would be very helpful if Excel could record the total editing time spent working on a spreadsheet. Or if Excel could better still, automatically log each time period spent editing a spreadsheet. Helps when billing customers and giving volunteer hours as I do a lot with Excel.

    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 →
  6. Fix filter annoyances

    1) Bug: when panes are frozen, in the moment when filter is applied the sheet is being violently scrolled horizontally in a random direction, hiding the active column.
    Please do not scroll on filter application.

    2) Missing functionality: The filter popup list can be re-sized to show more or wider items. Unfortunately the size of the popup is not remembered on the next pop.

    Many thanks!

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

    We’ll send you updates on this idea

    3 comments  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
  7. Go to Pivot table name

    If I give an Excel-table a name, then I can use the Go-To function to find it. Why can’t I find named Pivot tables in the same list?

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

    We’ll send you updates on this idea

    1 comment  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  8. Pivot Table Calculated Item

    It is observed that the pivot "calculated item" feature has two serious drawbacks:
    (1) The calculation takes a long, long time compared to "calculated field" feature.
    (2) The calculated numbers generated via "calculated item" on the pivot table can be altered or defaced which does not happen when "calculated field" feature is used.
    The above drawbacks render the use of "calculated item" in pivots unusable. Can we address these?

    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  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  9. Allow Edit of the Macro Button

    Allow users to edit the Macro Button (like we could in an older version of Excel) for custom macros in the Quick Access Toolbar. Currently, we can select from ~180 images but it was so much nicer when you could go in and 'draw' your own button.

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

    We’ll send you updates on this idea

    1 comment  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  10. Excel: Achsenbeschriftung bei logarithmischer Skalierung (German)

    Excel: Achsenbeschriftung bei logarithmischer Skalierung

    Logarithmische Aachen lassen sich im X-Y-Diagramm von Excel 2010 und 2013 durch die Eingabe eines festen Minimum und Maximumwertes unter den Achsenoptionen frei skalieren. Die Festlegung eines Haupt- oder Hilfsintervalls bleibt ohne Wirkung, da Ziffern an logarithmisch skalierten Aachen (zur Basis 10) nur an den Hauptgitternetzlinien in Dekaden (1; 10; 100; …) angezeigt werden (Bild 1).

    Die Darstellung von Ziffern an den Achsen innerhalb einer Dekade (z.B. X = 200; 300; 400; 500; 600) gelingt nicht. Liegen z.B. Messwerte bei X = 200; 300; 400; 500; 600 vor und wird die Skalierung der X-Achse entsprechend…

    2 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 →
  11. Microsoft keyboard shortcuts for in-cell alignment.

    Other Microsoft products allow keyboard shortcuts to align text. Please add these to Excel: Ctrl-E to center a cell's contents, Ctrl-R for right alignment, Ctrl-L for left alignment.

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

    We’ll send you updates on this idea

    1 comment  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  12. Do we need 15 decimal places?

    Who needs 15 decimal places? The IEEE round off error were users get, say, 12.3 × E-15 when they expect zero just confuses then and undermines their confidence in Excel and in themselves.

    I cannot see any one in the finance world needing 15 decimal places.

    Few, if any, engineers/scientist work with that sort of precision. Look up physical constants and you will find they are generally known to only 9 significant figures: Planck constant h = 6.626 070 040(81) × 10−34, were (81) is the std dev in the last two decimal places. Albeit some work with atomic masses…

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

    We’ll send you updates on this idea

    6 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  13. Change default calculation for pivot table items

    When I drag new items into the values section of a pivot table, they always default to the 'Count' calculation. In my work, it's almost always 'Average' that I want though, and I'm left dragging a bunch of items in and changing them one by one in the dropdown. Annoying.

    So, I'd ask you to consider adding one or both of the following options:
    1. Change the default calculation for newly added items
    2. Allow changing of calculation for multiple items at once (this would be particularly good if it let me change all the options for multiple items together)

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

    We’ll send you updates on this idea

    2 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  14. Function to only use every xth-row or column in another function

    Function to only use every xth-row or column in another function

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

    We’ll send you updates on this idea

    3 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  15. Add a Switch Reference button to Ribbon

    Many know the F4 is used with authoring a function. However it needs to be memorized. please create a button on the ribbon to switch between types of referencing.

    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 →
  16. Please fix the bugs in pivot tables! (I am only using XL2010 so far).

    There are loads of bugs and omissions in Pivot Tables (maybe already solved in the latest version).


    1. If the data source range is updated to zero records (ie only the one row of column titles), Excel gives a useless error message and then displays the previous dataset's results instead of an empty pivot! Not only is this a potential security risk in a multiple user situation, but it means that all pivot table code has to be surrounded by workround code to add a null record to the range so that it doesn't fail.


    2. If you double-click on a pivot…

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

    We’ll send you updates on this idea

    3 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  17. Add an IN() function to check for existence of a value

    Right now, I often use formulas like this:

    =IF(COUNTIF(&quot;A&quot;, myRange)&gt;0, ..., ...)
    

    It's be handy to be able to just use:

    =IF(IN(&quot;A&quot;, myRange), ..., ...)
    

    This could also help with formulas where a number of different criteria are allowed:

    =SUMIFS(B:B, A:A, &quot;2016&quot;) + SUMIFS(B:B, A:A, &quot;2013&quot;) + SUMIFS(B:B, A:A, &quot;2010&quot;)
    

    becomes

    =SUMIFS(B:B, A:A, IN(A2, &quot;2016&quot;, &quot;2013&quot;, &quot;2010&quot;))
    

    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  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  18. creating Layout of directory in excelsheet directly from your local hard drive

    if it was possible that just with one click, we can create a Tree Grid Map of directory, which will give option of inducing sub folders & files with option of inserting hyperlink.

    So that i don't have to open 7-8 sub folders before opening my files.

    (nothing against VBA, its a great tool) if i create a directory using VBA it is not very beautiful..... i wish i could see small folders with little Expansion buttons it would be very great.

    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  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  19. Pin newly opened files to visual area (or just the upper left hand corner)

    I open my excel to cross over multiple screens, but when i open a file its a crap shoot as to where it appears across the screens. I know the file is open as I can see it in the list of open files but beats me where it is. I have to go to "View/Arrange All" and then vertical to be able to find the file. But doing that moves all my other files that I have placed in my work area for a reason.

    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  ·  Opening and Saving Files  ·  Flag idea as inappropriate…  ·  Admin →
  20. Save As Cell Contents, instead of the default "Book1.xlsx"

    Often I have typed a heading in a workbook, and then had to re-type the same or nearly the same information when saving the workbook. MS Word has an intelligent guess at the Save As option by using the first words in the document, but Excel just offers Book1.xlsx. What if we could have Save, Save As, and Save As Cell Contents? In other words, select your chosen cell, click on Save As Cell Contents, and you have your desired file name with no duplication of effort.

    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 →
  • Don't see your idea?

Feedback and Knowledge Base