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. Allow modifying custom ribbon controls using VBA

    It would be very helpful to have the ability to edit custom controls using VBA (such as in Project with method SetCustomUI(CustomUIXML)). Sometimes it is necessary to add or remove controls (nut just show and hide).
    Thanks!

    5 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 →
  2. Please make for Crtl-x the same pasteoptions available like Crtl-v

    Ctrl-x offers only one paste option
    Ctrl-V enables multiple pasteoptions
    Please also makes for Crtl-x the same Paste Options available.

    7 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 →
  3. Allow non-tiled Background images

    Setting an image as Background automatically tiles it across the entire workbook. Would be nice to have the option to not tile it and have the image appear only once in the top left corner.

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

    We’ll send you updates on this idea

    0 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  4. VLOOKUP NEW OPTION FOR DATABASE TABLES

    VLOOKUP already support table names (if formatted as tables) column name... simply, make VLOOKUP accept not only a column INDEX but also a column NAME, e.g.

    VLOOKUP(A1, [Orders], [OrderDate], false)

    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  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  5. Move 4 Functions to the Maths & Trig Category

    SUM is in the Maths & Trig category

    but

    AVERAGE, COUNT, MIN and MAX are in the Statistical category

    My suggestion is to move these functions to the Maths & Trig category.

    Here are some reasons why:
    1 - The AGGREGATE and SUBTOTAL functions are in the Maths & Trig category
    2 - There is a dedicated Maths & Trig drop-down on the FORMULAS tab so they can be found easily

    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 →
  6. Editing calculated fields from the PivotTable Fields pane & renaming calculated fields

    It has always confused me that I can see my calculated fields in the PivotTable Fields pane but cannot edit them from there. Instead, I have to go "Analyze" tab, "Fields, Items, & Sets", "Calculated Field", and choose the calculated field from the dropdown list. We should be able to add, modify, and delete calculated fields from the PivotTable Fields pane, perhaps through a right-click menu.

    We should also be able to rename a calculated field. Currently, if you "rename" a calculated field, the "Modify" button becomes "Add". In other words, to rename a calculated field, you have to add…

    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  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  7. Cell("path")

    Instead of =LEFT(CELL("filename"),FIND("[",CELL("filename"))-1) return path of current worksheet.

    Also: Make arguments universal between different language packs

    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 →
  8. REPL

    Add Excel REPL - code and see results in place:


    1. modify/create sheets

    2. modify/create charts

    3. import/export data

    4. integration with macros

    5. html output window

    6. widgets

    1 vote
    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 →
  9. Fix the problem with multiple Groupings on the same field in Pivot tables

    Until Excel 2003 the Pivot Table Wizard asked the user if he/she would like to keep the new pivot table independent from the others (separated data cache). This allowed i.e. to create different groupings on the same field. Starting from Excel 2007 this option has disappeared from the pivot creation gui interface. Please re-add 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  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  10. Printing control - worksheets single/double page

    It would be great if there was some way for preferences to save a setting to specify printing individual worksheets as either single- or double-sided.

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

    We’ll send you updates on this idea

    1 comment  ·  Printing  ·  Flag idea as inappropriate…  ·  Admin →
  11. Selecting multiple sheets & copying from editing sheet

    Selecting All Sheets & Editing/Formatting First Sheet Then All Selected Sheets Copying The Format Which We Are Formatting In First Sheet

    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 →
  12. Improve the precision of object placement on charts

    Since Excel 10, the precision of placed objects like lines on charts has deteriorated. For example, drawing a 45 degree line on a chart from one corner to the other is very imprecise because it seems the cursor has trouble picking up the correct pixel in the chart axes corner. Sometimes the chart has to be resized to nail the placement down.

    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  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →

    Thanks for the feedback. Would you be able to provide a sample file that illustrates the problem or more specific repro steps?

    Thanks,
    Scott [MSFT]

  13. Make points into objects

    Make scatterplot data plot points into objects that can be selected with the mouse in order to remove them from a regression or move them to another series.

    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  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →

    Thanks for the feedback and further details. We’ll consider this in our next planning round for a future release. In the meantime, please continue to vote on this feature idea.

    Thanks,
    Scott [MSFT]

  14. Macros usable to other users

    When you create a macro and send the workbook to other users, unless they have their settings such that they can run a macro, you need to give them special instructions so that the macro runs.
    Surely, there must be a way to send a workbook with a macro in it to someone without having to tell them to change their security settings which often causes them to think they're doing something to put them at risk.

    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  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  15. Animations

    Please give users ability to turn off animations when cell is selected. This is annoying and there is no way to turn this off.

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

    We’ll send you updates on this idea

    8 comments  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
  16. STDEVIFS Standard Deviation if formula

    STDEVIFS formula similar to AVERAGEIFS. Thanks

    6 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 →
  17. Regression output to include labels from both columns

    Currently the regression output only includes the label for the X range. It would be helpful if the Y-range label would also be included.

    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. Axis title high-low option for charts.

    For some unknown reason, excel chart always flips my data so that the first data point is at the bottom of the y axis. As a result, I always have to select 'reverse order' so that the data appears in the order that I type it. Annoying, but not a major problem. However, the x-axis title is now always at the top, and there is no option to select 'high' to place it at the bottom of the chart.

    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  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →

    I’m not able to reproduce the problem you are describing. Can you send me more explicit steps that are needed to reproduce it and a sample file?

    Thanks,
    Scott [MSFT]

  19. When you go to the "move or copy" tab icon, it would be easier if that drop down list included the highlights that I've added to each tab.

    When you go to the "move or copy" tab icon, it would be easier if that drop down list included the highlights that I've added to each tab.

    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  ·  Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…  ·  Admin →
  20. Change automatic border color

    Black borders are ugly and take attention away from the data in tables. I would like to be able to switch the default border color to gray, but I can’t do that either at the workbook or the sheet level. This means that I have to manually change the border color or paste formatting every time I add borders.

    I’ve tried setting preferences in the Workbook and Worksheet templates in the XLStart folder, but the border preference does not stick.

    This is not to be confused with the default gridline color, which can be set in the Advanced Excel option.

    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  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?

Feedback and Knowledge Base