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. AutoFit columns in the output sheet of the Analysis ToolPak's Regression tool

    Currently, many cells in the output sheet of the Analysis ToolPak's Regression tool are cut off by default because the columns are left at their default width. Please AutoFit the columns as part of the generation of the output. Also, select cell A1 by default so that the output sheet looks cleaner.

    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 →
  2. Behavior of active cell during macro recording and macro execution are different especially when I use End(xlup etc.).

    Active cell wont move when manually select a range using control-shift-xlup or other cursor keys. For example when we select a range from down-right corner to the top-left corner using control-shift-xlup and control-shift-xlleft, active cell is still at the down-right corner. While active cell seems to move to the top-left corner when we execute the same key sequences during a macro.
    Thus it is difficult to reproduce the same behavior by using "Record macro".

    1 vote
    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 →
  3. Suppress Autoopen Macro by holding Shift Key

    Legacy versions of Excel (i.e. those prior to Office 365) enabled you to suppress Autoopen macros from deploying by holding the SHIFT key when opening the corresponding Excel workbooks. This functionality appears to have been lost in Office 365, as holding SHIFT when opening an .xlsm file does not stop the Autoopen macro from running.

    Please can you reinstate this, as its absence feels more like an error or omission than anything else. Thank you ! :)

    1 vote
    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 →
  4. There is an annoying bug in microsoft excel vba, when using sendkeys, Numlock turns on! Please fix this bug

    There is an annoying bug in microsoft excel vba, when using sendkeys, Numlock turns on! Please fix this bug

    1 vote
    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. MPOC - Can I get an add in for 365 pro?

    I really need to move points on charts.
    Can this function be added to excel 365 pro?

    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  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  6. Porqué no esta disponible en Excel 2016 o mayores la función de month view calendar. ¿Cómo puede sustituir esta función?

    Es necesario que la propiedad de month view calendar se encuentra disponible en versiones de EXCEL mayores al 2013, ya que facilita la selección de fechas validas. Cómo puedo sustituir esta propiedad en una macro de excel?

    1 vote
    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 →
  7. Reference Comments (NKA Notes) in VBA by name rather than index

    Currently you can only reference comments in vba by their index number, if you know them. There is no known way to determine the comment index number by vba but maybe through a for-next loop searching the text for a known piece. It is possible to name a comment(shape). Since comments do not always get created by the same order or are in the same place, inserting data above or to left e.g., allow the comment to be selected/manipulated by it's shape name.

    1 vote
    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 →
  8. VBA doesn't check the maximum text line length when importing a module

    VBA doesn't check the maximum length of every text line when importing a module (.bas file). This can cause an issue when saving the VBA project inside VBA when the text line of the .bas file is higher then allowed, which can lead at the end to a full crash of Excel. This is a major issue.

    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. I want you to have an add-in for the Office 365 Excel-enabled Zip Code Conversion Wizard.

    Previously Excel Add-ins: You could use the Zip Code Conversion Wizard to bulk convert, but Office 365 Excel is out of system requirements and want a compatible add-in.

    タイトル
    Office 365 Excel 対応の郵便番号変換ウィザードのアドインを用意してほしい。

    内容
    以前は Excel アドイン: 郵便番号変換ウィザードを利用して一括変換することが可能だったが、Office 365 Excel はシステム要件外のため、対応したアドインを用意してほしい。

    1 vote
    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 →
  10. Lock some cells in all sheets

    Hello
    I want to lock some cells in all the sheets at once. Please guide. Thanks

    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 →
  11. Add an Automatic Open, Refresh, Save and close feature instead of having to go through batch files and power shell

    Add an Automatic Open, Refresh, Save and close feature instead of having to go through batch files and power shell

    It could be a Automation button that Schedules a Refresh of all the Data and Macros in an excel sheet then closes it

    1 vote
    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 →
  12. Providing 64-bit version of MSDAORA driver

    A strategic customer is facing a compatibility issue in using their LOB excel Macro after upgrading from Windows 7 and Office 2010 32-bit to Windows 10 1709 and Office 2016 64-bit.
    The macro is unable to connect to an Oracle database as there is no available 64-bit MSDAORA driver

    1 vote
    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 →
  13. VBA histogram bin

    Please make the number of bins and bin width for histograms open to VBA. I can read the values, but I can't change them. I want to create a macro that allows me to use a spinner so I can adjust the number of bins or the bin width.

    I am working with statistics and need to be able to quickly adjust these numbers for students.

    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 →
  14. Excel 365, home; windows 10 pro x64 - In EXCEL 365 VBA code, the statement "Application.ScreenUpdating = False" fail to operate in some VBA

    In EXCEL 365 VBA code, the statement "Application.ScreenUpdating = False" fail to operate in some VBA subroutines and macros. With "Application.ScreenUpdating = True" the execution is dramaticaly slowed down. Please help.

    1 vote
    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 →
  15. Create a command line tool for signing Office files with a digital certificate

    Besides Office, Excel files can be created using numerous software tools. More often than not, batches of macro-enabled Excel files are processed with scripts for productivity purposes. However, VBA code signing cannot be part of an automated process, as it is a manual task that requires opening & saving the file in Excel.

    This request is about creating a command line tool for signing Office files with a digital certificate, similar to MS SignTool.

    In addition, the existing macro signing process in Office is not 100% compatible with Open XML specifications. I can clarify this statement in a private discussion…

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

    We’ll send you updates on this idea

    23 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  16. Disabeling Calculate; norma, page layout & page break Preview on task bar at the bottom.

    I suggest Disabling Calculate; normal, page layout & page break Preview on task bar at the bottom. Allow the user to make any of the options, their default view, but only for the active workbook.

    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. Analysis ToolPak's Regression tool should not use the clipboard

    After you run the Analysis ToolPak's Regression tool, you can paste some of the numbers that appear in the output. There is no warning that the Analysis ToolPak will use/clear the clipboard. Users may have had important stuff on the clipboard. It is also bad practice to use the clipboard as part of a macro. Please change the Regression tool so that it does not use the clipboard.

    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 →
  18. Eliminate double spaces from the titles of the graphs generated by the Analysis ToolPak's Regression tool

    The residual plots use 2 spaces before "Residual Plot" and the line fit plots use 2 spaces between "Line Fit" and "Plot". Please change these to be a single space.

    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 →
  19. Non-overlapping arrangement of graphs generated by the Analysis ToolPak's Regression tool

    Currently, the graphs generated by the Analysis ToolPak's Regression tool are cascaded (i.e. the next graph overlaps most of the previous graph, but offset a little). This arrangement is useless since you can only see the last graph, and you must spend time to move the graphs out of each other's way.

    Please arrange the graphs in a grid by default. There should be a row/column of Residual Plots and a row/column of Line Fit Plots right next to it. The Normal Probability Plot will have to reside outside of the grid. Luckily, there is a nice space for it…

    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 →
  20. Provide search boxes on every VBA Help page!!

    Provide search boxes on every VBA Help page!!

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

Feedback and Knowledge Base