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. Excel hex color codes for formatting

    Please allow to enter Hex color codes when choosing colors for cell fills, borders, fonts, charts, etc...
    RGB and HSV are triple the work!

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

    We’ll send you updates on this idea

    4 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  2. Have a date function that is shows the date of when a data point was entered

    We'd like to have a function in which we could see the date of when a data point was entered into the system. Like that we wouldn't have to enter the date manually every time we entered a data point into the spreadsheet. it would be like an if statment, example( =IF(B3<>" ",DateOfEntry()," ")) the function itself would be the "DateOfEntry()" the issue we have with Today() is that it updates every day and therefore every time we enter the spreadsheet the date information is updated to the current date and we arent able to have proper tracking of the…

    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  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  3. Enable to sort separate range columns in latest desktop version of Excel

    Trying to sort out multiple columns in Excel but received an error!! This is possible on earlier versions of Excel desktop. Need to sort multiple columns at once.

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

    We’ll send you updates on this idea

    0 comments  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
  4. Eliminate the new "Save your changes to this file?" dialog box

    In the last week, whenever I close down a new Excel file without saving it, a new dialog box appears asking "Save changes to this file?". Whereas previously I could use keyboard shortcuts to immediately close down a file (Ctrl-F4, N), this no longer works. Instead, the new box interprets the "N" keypress as something to be entered into the "File Name" text field.

    8 votes
    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 →
  5. Multiple sheet Unhide option..

    Unhiding multiple sheets is a painful task, you have to go one by one. There should be an option to unhide multiple sheets at once.

    Please bring in this feature.

    Thanks.

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

    We’ll send you updates on this idea

    4 comments  ·  Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…  ·  Admin →
  6. slicer red x

    FIX SLICER RED X ON FILTER
    Since upgrading to Office 365, all my slicers now have red X on the filter button, regardless of any filtering. In 2016, the X turned red only when the slicer was filtered, otherwise it was greyed out. Now, in 365, ALL slicers ALWAYS have a red x. No way of scanning quickly to see which slicers are filtered. They all LOOK like they are filtered, whether they are or not.

    6 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 →
  7. Ticket #12395436 - Excel arabic

    Hi, we experience an issue with MS Excel and the arabic language pack: User does right click on desktop and selects new Excel Workbook. New Workbook opens and first column A is on the right of the sheet and title of the sheet is arabic. If user just starts excel and creates a new workbook within excel all is working as expected, only if user selects new workbook from right click to desktop this happens. We installed the arabic language pack and this seems to affect the default template of excel.

    The same issue is already reported for Office2007 and…

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

    We’ll send you updates on this idea

    1 comment  ·  Application Errors  ·  Flag idea as inappropriate…  ·  Admin →
  8. Directions from 0 to 2pi 1)atan(x,y) 2)atan(E,N) and from -pi to +pi 3)atan2(x,y)

    1)atan(x,y)=pi-pi/2*(1+sgn(x))*(1-sgn(y^2))-pi/4*(2+sgn(x))*sgn(y)

    -sign(x*y)*atan((abs(x)-abs(y))/(abs(x)+abs(y))) when x=x2-x1 ,y=y2-y1

    2)atan(E,N)=pi-pi/2*(1+sgn(N))*(1-sgn(E^2))-pi/4*(2+sgn(N))*sgn(E)

    -sgn(N*E)*atan((abs(N)-abs(E))/(abs(N)+abs(E))) when N=N2-N1 ,E=E2-E1

    3)atan2(x,y)=pi/2*(1-sgn(x))*(1-sgn(y^2))+pi/4*(2-sgn(x))*sgn(y)

    -sgn(x*y)*atan((abs(x)-abs(y))/(abs(x)+abs(y))) when x=x2-x1 ,y=y2-y1

    The above fuctions give the directions in the 4 quadrans for all the pairs of dx and dy.

    For dx=dy=0 the result is indefinite .

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

    We’ll send you updates on this idea

    15 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  9. Expand Dark Mode

    Provide an option in dark mode in which the cell color defaults to black ( ie "no fill" results in a black background) and the text color defaults to white or light gray

    6 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 →
  10. Convert Number to Word (SpellNumber)

    A very much need function which should allow Excel users to convert number to word.

    Example :
    1. $ 450.00 it should convert to US Dollars four hundred fifty and zero cents only.
    2. SAR 450.00 it should convert to Saudi Riyals four hundred fifty and zero halalas only.

    Note : the conversion should be based on regional setting and user should be able define the currency code.

    =SpellNumber([cellReference],"CurrencyCode")

    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  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  11. Add a CONTAINS("find_text","within_text") Function

    Excel's own documentation recommends pairing the ISNUMBER and SEARCH functions to accomplish this, but I still have team members asking on a regular basis for a function that returns whether a string is found within a given cell. An out of the box CONTAINS() function would go a long way for usability.

    13 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 →
  12. Make undo work per workbook, not for all of Excel. I am commonly working in two workbooks and need to undo something I did in the other work

    Ctrl + Z should work per workbook, not for all of Excel. I commonly have two workbooks open and work in them simultaneously, but when I use the undo shortcut it backs out through all of excel, instead of just the active workbook.

    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  ·  Performance  ·  Flag idea as inappropriate…  ·  Admin →
  13. Setting row height from 0.21" (default) to 0.5" on Page Layout does not give the proper Excel Output

    Custom Margin Settings for 2 Excel files were both set this way:

    Top: 0.5
    Bottom: 0.5
    Left: 0.7
    Right: 0.7
    Header: 0
    Footer: 0
    *no other settings modified

    First Excel File

    View > Workbook Views > Page Layout
    Highlighted first 20 Rows > Home > Cells Section > Format > Row Height > Set Row Height from 0.21" to 0.50"
    Which results in row 21 showing up on the first page,

    Second Excel File

    View > Workbook Views > Page Layout
    Highlighted first 20 Rows > Home > Cells Section > Format > Row Height > Set Row Height from…

    11 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 →
  14. Update Visual Basic for Applications

    Visual Basic for Applications is still version 7.1 from 2012. It's high time that power user portion of the application received updates to the interface, IntelliSense, and features. That portion of the program needs to be aligned with the current features now available within the Microsoft Suite. It also needs a facelift to the Userforms palette. I suggest starting with Excel, where VBA is most widely used, then PowerPoint, Word, Outlook.

    Don't go destroying developer's programs, just add interoperability, functions, and facelift.

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

    Idea of insertion/ removal of Watermark in the excel sheet like in word is likely for some creative work

    11 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 →
  16. Please fix conditional formatting!!

    I create Conditional Formatting on whole columns. I should be able to insert, delete, blank within my range without Conditional Formatting breaking up into formatted sections which eventually causes some rows not to format correctly. I am constantly correcting the Conditional Formatting which is very time-consuming! It is such a handy tool but very frustrating tool to work with.

    12 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 →
  17. Allow temporarily broken formulas

    I have a long list of formulas, and want to nest every formula within another if statement. Using find and replace to replace the beginning and end of every formula (the parts that don't differ between each one), this should be very easy. However, excel won't let me change a single one because, when I try to replace the text, "the formula is missing an opening or closing parenthesis."

    I can appreciate having error checking for formulas, but there should be SOME way to either bypass this error checking or turn it off! This is frustrating me to no end.

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

    We’ll send you updates on this idea

    5 comments  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
  18. Add a Reporting Ribbon to Excel to consolidate and highlight the amazing capabilities of Power Query and Power Pivot

    Tables, Power Query, Power Pivot and Pivot Tables are amazing tools that will transform the way people build their reports, but only once they know about them!

    Let's SHOUT about how good these things are and how well they work together by putting them onto a single new Ribbon called "Reporting" - something like the attached image.

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

    We’ll send you updates on this idea

    17 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  19. Named conditional formatting rules

    Named conditional formatting rules - If you could name your rules they would be easier to identify. Also, it would be nice if you could right click a cell and have a choice to add it to a named conditional formatting rule. Excel would need to be intelligent enough to be able to add the cell or group of cells to the rule correctly.

    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  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  20. Fix this problem: "sometimes you might find yourself with a workbook that has links you can’t find even though Excel tells you they exist. "

    Fix this ridiculous problem: "Sometimes you might find yourself with a workbook that has links you can’t find even though Excel tells you they exist."

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

    We’ll send you updates on this idea

    8 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?

Feedback and Knowledge Base