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. Export the results of Spreadsheet Compare as a spreadsheet with highlighted differences instead of a list of changed cells

    In the former version "Essential Spreadsheet Compare 1.34.8" the comparison gives you an output where you have in the same spreadsheet the changed rows in red with a strike on top and the new ones in green . This allows users to identify the changes maintaining the view of the whole row and to easily replace the old by the new rows and keep a tracking of the changes.
    In the new version you just have a list of the cells that changed and what changed. Although the program shows you a spreadsheet with the differences highlighted it does not…

    12 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 →
  2. Mini calendar and date picker

    The actual calendar should be embedded in the ribbon instead of you having to open it in every sheet to select dates.

    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  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  3. VBA ScreenUpdating-Property does not work in Excel 2016!

    The VBA Application.ScreenUpdating-Property does not work properly in Excel 2016 / Win 10. See attached screenshot. The screen is updated after each step in VBA, although the ScreenUpdating is set to False. The property worked nicely in Office 2007 / Vista.
    It would be nice to have this bug fixed as quickly as possible, since I have hundreds of Makros who depend on this property.
    Christian Klug
    Düsseldorf, Germany

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

    We’ll send you updates on this idea

    59 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  4. Add-Ins Options Menu: When you are done (or cancel) from one area, it should put you back in the Add-Ins menu so you can do more

    Add-Ins Options Menu:

    When you are done (or cancel) from one area, it should put you back in the Add-Ins menu so you can do more Add-Ins work. It should not throw you all the way out so you have to go back all the way in.

    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  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  5. Make Macros easy to copy and paste into another computer

    I want to record a macro, create a button on my excel worksheet, so it is available to run whenever I want to run it. AND make it easy to copy so I can share it with friends and put it on my laptop without having to physically re-record it. ( export data out of our software into an excel workbook and then I want to run my macro on that data. It's difficult because you cannot edit that macro if you want to change something. Also, I cannot move it to my laptop, nor can I give the macro…

    5 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 →
  6. Capturing/accessing prior cell value (NOT the undo log) for worksheet_change (VBA)

    I see that Dan [MS] has already closed out at least one topic with the explanation that there is no plan to integrate VBA and the undo log- my suggestion does not rely on the undo log, I just wanted to say that up front to avoid any confusion

    I don't think it would be difficult to temporarily store and expose the old value of a cell (or range?) as part of the worksheetchange event, so that VBA users could compare previous and new values for a cell (or range?). For example, in addition to Target.value, you could also

    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  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  7. Change Significance F Label in Regression Output

    My MBA cohort is having a difficult time remembering that Significance F is really the model-level p-value. We understand that the p-value labels below refer to the individual variables, but Significance F is obscure.

    I suggest that you change the label Significance F in the ANOVA section of the output to Model p-value to resolve this confusion.

    14 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 →
  8. Default Sheet codename as 01, 02, etc instead of 1, 2, 3

    Ok, I know this is a minor nit, and probably NOT appropriate for the visible sheetnames (because it would throw half the user base into a panic)... but I often find myself renaming the sheet codenames (and controls) using 01, 02, 03 because of the way the VBE sorts things. Obviously this only helps for workbooks less than 100 sheets, but that is probably 99% of the use cases, whereas the current approach only works up to 9 sheets, which is probably only half the time.

    Sure, I sometimes rename sheets with more intuitive text names as well, but this…

    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  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  9. Keep the font color white on the Status bar while macro is running, so users can read the feedback displayed there.

    When running a macro, it helps to turn screen updating off to maximize speed. Also, users want to know what's happening, so a very good way to do that is to output a progress message on the status bar, such as the process completion percentage...

    New in Excel 2016, the status bar font turns dark grey on a dark green background when the macro is running, making the messages there unreadable. Why? Earlier versions of Excel did not have this design flaw. I understand that different windows themes can be tried to avoid this, but as a developer I can't…

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

    We’ll send you updates on this idea

    5 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  10. FIX THE BUGS with Application.ScreenUpating & Application.DisplayAlerts!It has been reported as broken for over a YEAR

    BUG REPORT: Neither Application.ScreenUpdating or Application.DisplayAlerts work correctly in Excel 2016. Without these functioning, (unattended) macros are useless.

    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  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  11. Python as an Excel scripting language

    Let us do scripting with Python! Yay! Not only as an alternative to VBA, but also as an alternative to field functions (=SUM(A1:A2))

    6,627 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    493 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →

    Wow.

    Thank you to all those participated in our survey. What an amazing number of responses, many of them with very deep content. We’re processing the over ten thousand responses(!), and already appreciate the time so many of you took to answer with passion and experience.

    Please know this survey is used to help influence various topics – both on Python as well as other related topics that the comments started to bleed into. Given the passion, I want to be clear this remains an area of exploration for us, without any specific timeline.

    We’ll provide updates as we progress on this feature request.

    Thanks!

    Ashvini Sharma
    Lead Program Manager
    Excel

  12. Assign a macro inside a cell

    Allow an option to assign a macro inside a cell like the hyperlink option or to assing a macro in hyperlink option.

    8 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 →
  13. Make the Microsoft Mathematics Add-In available for Excel 2016 and 365

    Microsoft Mathematics 4.0 is a fantastic Computer Algebra System with excellent graphing features. It allows you to solve math problems, even complex formula, and then graph them in graphs that could have the variables manipulated. It is a great teaching and visualization tool, which after having installed .Net 3.5, can be well installed on Windows 10 (https://www.microsoft.com/en-us/download/details.aspx?id=15702, https://en.wikipedia.org/wiki/Microsoft_Mathematics).
    Word and OneNote 2013 had a cool Add-in for Microsoft Mathematics 4.0, and we have asked to extend the Add-in to Office 2016.
    Please add it to PowerPoint 2016 too, or even better, to all current and future Office…

    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 →
  14. Amount in words formula in Excel

    PLZ Add Amount in words formula in Excel

    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  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  15. Improve Excel's ability to locate, edit and break links in spreadsheets.

    Often I create spreadsheets used by others within my company and by some of our business partners outside of our company. This may involve merging multiple spreadsheets into a single larger spreadsheet. Under these circumstances it is common to have the new merged spreadsheet pulling something from one or more of the previous stand alone spreadsheets. It works fine on my company laptop as I have access privileges to all of the previous stand alone spreadsheets. However when I give the merged spreadsheet to others within my company and/or our business partners they may experience linking problems. The more knowledgeable…

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

    We’ll send you updates on this idea

    3 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  16. Cloud-based Macros

    Wish that Excel's approach to Macros was much cleaner, shareable, collaborative as Google is impementing.

    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  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  17. TypeScript as an excel scripting language

    I think typescript should be considered alongside python, since as many (if not more) people already know it and/or Javascript, so the learning curve would be much smaller and easier than having to pick VB or Python to learn...

    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 →
  18. Excel 2016 issue: Memory leak when reading shape properties.

    Hello,

    Since long time, reading some shape properties increase excel memory consumption.

    Here how to reproduce the bug:
    Create a shape in the sheet.
    Create a vba module with this code:

    Option Explicit

    Public Sub testMem()
    Dim strOA As String
    While True

    strOA = Sheets(1).Shapes(1).OnAction
    
    DoEvents

    Wend
    End Sub

    Run it and look in task manager how memory consumption grows...

    It's same for

    strOA = Sheets(1).Shapes(1).DrawingObject.Caption
    strOA = Sheets(1).Shapes(1).DrawingObject.Text

    This was reported long time ago but not in good place:
    https://social.technet.microsoft.com/Forums/office/en-US/478f2cd7-6eb8-4a6d-aa18-816705998faf/unreleased-memory-on-property-get-for-shapeonaction?forum=excel#478f2cd7-6eb8-4a6d-aa18-816705998faf
    https://social.msdn.microsoft.com/Forums/en-US/d003c27a-0834-41b6-a507-e629845f72db/unreleased-memory-on-property-get-for-shapeonaction-on-excel
    Then
    https://social.msdn.microsoft.com/Forums/office/en-US/c444b318-a659-477a-9ddd-aa04d3d30663/excel-2016-issue-memory-leak-when-reading-shape-properties
    Where Ashidacchi Hokusosha tell me for that place.

    Regards

    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  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  19. Multiply Footnotes in Excel.

    I have a working version of a Footnote Add-In which is being used in Financial Companies for years. Microsoft should include this Add-in in its future version of Excel.

    This Addin adds a footnote, delete all references if the footnote is deleted or add new references. A superscripted footnote number(1,2,3, etc) or letter (a,b,c, etc) in added to the cell.
    Users can place all footnote references anywhere on a spreadsheet.

    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 →
  20. Expand co-authoring VBA script support to Worksheet.Protect method

    Currently Worksheet.Protect method is not supported in co-authoring mode. When someone protects or unprotects a sheet with VBA script it will force other users to Refresh and discard their changes as Excel cannot merge the versions.

    Worksheet.Protect should be added as supported method in co-authoring for creating more complex and useful protection solutions.

    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  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
1 2 9 11 13 16 17
  • Don't see your idea?

Feedback and Knowledge Base