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. Add Get Parameter button to Power Query and avoid Privacy / Formula.Firewall problems

    It's fantastic that you can pick up named ranges in Excel and pass them to Power Query as parameters. However the process is cumbersome and often results in Formula.Firewall warnings or other issues.

    This leads to having to switch Privacy Levels to "Ignore" or having to write a query within a query rather than nice and clean "parameter" queries.

    It would really simplify things if we could quickly create parameter queries (including a drop down to select parameter type) and that these queries would be immune from the Privacy warnings.

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

    We’ll send you updates on this idea

    10 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  2. Make "Conditional Formatting Rules Manager" box resizable

    As a programmer myself, I know that this is such a simple idea that could be fixed in seconds with no impact on anything else. There's many many suggestions already mentioning it in with other things going back years, but nothing has ever been done about it... maybe the developers don't even bother reading these suggestions any more?

    4 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 →
  3. Implement the Stock Data feature from Excel 365 into Excel 2019 for Desktops

    Basic stock information retrieval is a badly needed feature that should have been added to Excel years ago. A built-in feature would be preferable to hand-crafted solutions created by users or developers with varying skill levels.

    8 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 →
  4. Give users the ability to put the color back in all the Toolbar icons. The October 2018 white/blue icons are impossible to decipher.

    Give users the ability to put the color back in all the Toolbar icons. The October 2018 white/blue icons are impossible to decipher. Huge step backwards.

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

    We’ll send you updates on this idea

    7 comments  ·  Graphics  ·  Flag idea as inappropriate…  ·  Admin →
  5. Stop formatting all numbers as dates, as users have been requesting since the 1990s

    Automatic date formatting is not useful except for data entry, and it makes use of Excel for anything but the simplest processes a royal pain. Users have been requesting a way to switch this off for DECADES, but all they get in response is some unpaid "MVP" telling them how to use apostrophes.

    9 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 →
  6. Like copy down (control+d), I would like to see a copy up (control+u)

    Like copy down (control+d) to copy cell immediately above, I would like to see a copy up (control+u) to copy cell immediately below

    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 →
  7. KEEP UNFOCUSED WORKBOOK ACTIVE CELLS HIGHLIGHTED

    OPTION TO KEEP ACTIVE CELLS HIGHLIGHTED WHEN UNFOCUSED AND IN ANOTHER APPLICATION

    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  ·  Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…  ·  Admin →
  8. Date-Time Format

    Would like a simple method to format cells to display both Date & Time.
    Currently a date format and time format, but no date-time format, such as yyyy-MM-dd HH:mm:ss.
    I waste so much time with custom formats since I more often that not am interested in date and time.

    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 →
  9. Allow Data Validation List function to use the new "UNIQUE" formula

    The new "UNIQUE" feature is fantastic and it would be fantastic if you could use this function to create a dynamic list in a data validation list using indirect, rather than creating a separate dynamic list using the unique function and then creating a dynamic named range for this and then using the indirect function in a data validation list.

    4 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 →
  10. Introduce a feature which enables recovery of deleted content even after saving, so that deleted content can be recovered

    it will help recovering deleted content as sometimes we delete some content temporarily but we don't get it back, so to resolve it you must introduce this feature

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  Opening and Saving Files  ·  Flag idea as inappropriate…  ·  Admin →
  11. Zoom tool for graphs

    Excel is great for quickly plotting and looking at data. But it falls short when the user wants to view a specific region in a graph or chart. The only way I know how to do this is to change the axes to 'force' zoom-in on a region, which is very clunky and slow. It would greatly improve the users ability to look at specific regions of the data quickly if there was a zoom in/out tool (similar to MATLAB's implementation) in the side toolbar that appears when hovering over the chart. Additionally, having a hand tool that, when zoomed…

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

    We’ll send you updates on this idea

    0 comments  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →
  12. Excel is wrong in calculating -x^2

    If you type in for example =-6^2, Excel gives you 36. This is incorrect. Excel is assuming you mean =(-6)^2. But -6^2 is different.

    You can see this when you factorise. -6^2 = (-6)*(+6) = -36.

    Whereas (-6)^2 = (-6)*(-6)=36.

    Now if you type in = 0-6^2, only then does it give you the correct answer of -36.

    This error goes against millennia of algebraic convention.

    Plot the graph y=-x^2-7x-12 and then plot y=-7x-x^2-12. These two expressions are identical, yet Excel gives very different traces (the latter of the two gives the correct graph).

    Another way to correct -x^2 would…

    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 →
  13. Ordinal Position Function

    A function which returns ordinal position of one specific element in an array as a number. Alternative name occurrence.

    So for example if the array was like this
    A1 Dave
    A2 Fred
    A3 Jim
    A4 Dave

    Then Ordinal(A1:A4,A1) would return 1 eg the 1st Occurence of Dave
    Ordinal(A1:A4,A2) would return 1 eg the 1st Occurrence of Fred
    Ordinal(A1:A4,A3) would return 1 eg the 1st Occurence of Jim
    Ordinal(A1:A4,A4) would return 2 eg the 2nd Occurrence of Dave

    Function Format something like
    Ordinal(lookup array, lookup cell, optional reverse)
    Lookup array could be vertical with a width of 1 column or horizontal…

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

    We’ll send you updates on this idea

    4 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  14. 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…

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

    We’ll send you updates on this idea

    75 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  15. Make it possible to insert pictures behind cells.

    Make it possible to insert pictures behind cells.
    Currntly its only possible if you set a background. But this implicates to have the background behind the complete sheet.
    Many Users want to have the feature to paste a picture in a sheet, format the size a.s.o. and have the ability to set it to the background.

    Currently if you set such a picture to the background its just related to other pictures but not behind cells. It would be great to have the ability to set it behind cells so that content within the cells is shown above the picture.

    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 →
  16. Make the Evaluate Formula dialog box re-sizable

    The evaluate formula box is unusable with large and/or CSE formulas. Please just make it re-sizeable. Thank you.

    41 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 →
  17. Allow wildcards to be used with IF statements

    I think the IF function should allow wildcards to be used. Take a look at the attached file. I'd rather write the below function than what I have show in the attached filed:

    =IF(N2=2010??, "2010", IF(N2=2011??, "2011",...etc.)

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

    We’ll send you updates on this idea

    4 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  18. Add append and prepend options to find the find and replace dialogue box.

    Right now the only way of appending or prepending something to cell contents is to use a concat function which can be a hassle depending on the contents.

    Alternatively adding full regex functionality to the search/find and replace function would be even better!

    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 →
  19. Gridlines make them visible in a block of filled color cells

    Gridlines, when you fill color a block of cells the gridlines are no longer visible to see each cell when working in the sheet. Would be nice to turn this on and off.

    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 →
  20. Perform Calculations (Sum, Count, If, etc.) Based on Cell Color

    Allow users to create formulas and that perform specified operations with data/values from only cells with a chosen background color, from a range of cells.

    For example, in a range of 10 cells (A1:A10), only 3 cells have been colored yellow (either by the user or by a specified condition). A user can create a formula, such as =SUM or =COUNT or =AVERAGE, that will only use the cells colored yellow to determine the result. All other cells in the range, regardless of background color, will be excluded from the formula's result.

    Alternatively, the same functionality can be achieved based…

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

Feedback and Knowledge Base