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. Prevent Copy-Paste in Excel all applications including Web, Android etc.

    The idea is preventing other users from copy-paste into Excel sheet. So that the user can enter only correct values in excel.

    Why it is required?
    I have applied Data Validation on specific column about numbers only, then this validation works fine if user enters manually, but if user copy from external source or paste into that column then the data validations won't work on that cell.

    And if I supposed to use Macros to prevent copy-paste, however the limitation is macros only work in Desktop Application only.

    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 →
  2. Creating macro or repetitive function without writing code in VBA.

    We need to be able to write repetitive Excel tasks through simple functions or formulae so that whenever we need to re-perform that task we can just use the same function to process the same.

    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. Money in Excel trends by account

    Ability to see month over month usage of specific account. This would be helpful to see savings account grow over time.

    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 →
  4. Give us a QR Code font

    Please give us an add in with the ability to create text into QR codes. We have a system that loves QR codes and a lot of part number we need to print in QR code and now we have a lot of work to do to make it work in excel.

    Thanks

    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 →
  5. Replace new "Workbook statistic" function with Inquire

    Hello,

    Workbook statistics functions was introduced recently in Version 2002 (Build 12527.20194).

    So far it's just plain crazy simple window with useless information.

    You show me i've 10 tables in my workbook? Cool, mind to show me all of them with names and references?

    What do i've to do with those plain numbers?

    There's already insanely useful add-in called "Inquire" where info from "Workbook statistic" and much much more is available already.

    Please just make Inquire available for all excel desktop users!

    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 →
  6. Please get the Excel VBA cpontext sensitive help back to work!!

    I don't really care, if it's offline or online help as long as it's fast and reliable, but currently pressing F1 in VBA shows only the MS documents content list (https://docs.microsoft.com/de-de/).
    For 20 years the context help with F1 was really fast, informative and helpful. Now its just scrap. BTW: Germany is an online underdeveloped country!! Remember: we Germans need OFFLINE HELP. (I still have a 1 Mbit connection!)

    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. Intellisense support for Range.Formula2, HasSpill, etc. properties

    The new Range.Formula2, HasSpill, SpillParent, and related properties introduced recently to Excel do not have Intellisense support in Visual Studio. As VSTO is still the best platform to build advanced-capability add-ins for Excel, exposing these properties via Intellisense is very desirable.

    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 →
  8. Ability to add a table of contents, one hyperlink for each worksheet in a workbook.

    Ability to add a table of contents, one hyperlink for each worksheet in a workbook. When adding additional worksheets, ability to refresh the TOC to make it easy to find a particular worksheet within a workbook that has many worksheets.

    I AM NOT ANONYMOUS - I DID ENTER MY EMAIL ADRESS

    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. Money in Excel: Add a nonbank account

    Adding an account which isn't linked to a bank account, to be able to track cash.

    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. Please replace VBA with a modern scripting language

    Please replace the VBA scripting language by something more modern.
    I would like to see a .NET language with editing and debugging capabilities in Visual Studio.

    I think that VBA is no longer a viable option as a scripting language.

    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 →
  11. money

    Add starone CU to financial institution for money in excel

    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 →
  12. Ignore cell style while using .find in VBA and the xlWhole parameter

    When a macro fills a cell with a text and later needs to go back to that cell the .find method and the xlWhole parameter should do the job. However it fails when the cell style is not standard. That behavior is very odd. Please ignore the cell style when searching whole texts. xlPart works fine, but often you simply need exactly the whole cell text.

    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. [BUG] Listbox autoselects item if openned under cursor via doubleclick on cell

    If it happens that userform with listbox opens (via on cell doubleclick) under cursor it automatically selects listbox item (that apperas under cursor).

    Reproduced in Excel 2013, 2016, do not have other versions.

    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 →
  14. Range.Find should use cell values, as opposed to the displayed text.

    The following equation fails if you change the column width. See attached pictures.

    colNum = Worksheets("Sheet1").Range("E5:DA5").Find(-10).Column

    It should be finding that cell H5 has a value of -10.

    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. Simple Query language like google sheets, The Power query on Excel needs an overhaul

    Excel needs to look at how simple and user friendly the query language in google sheets is, the power query in Excel needs an overhaul.

    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 →
  16. Code for VBA to return or set the column width in pixels instead of points

    Pixel values vary depending on the monitor used, my issue is if you sum the range of column widths that suit your print area for 1 page example 7 columns in points total points = 89.33 (853 pixels) and try to apply this total width to another column let say 1 column then 89.33 points becomes (811 pixels). I understand why this happens due to how points are calculated, however you can display the pixels when you click on the column in excel im assuming code to retrieve or set by this pixel value wouldn't be too much of an…

    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 →
  17. Provide a VBA-configurable "Display Name" for worksheets

    It appears the name of worksheets can not be altered in VBA. This is a restrictive when the workbook is locked for users etc.

    This means that worksheet names are fixed and cannot be named in accordance with user data.

    Example:
    Workbook 1: "List of Current Cities"
    Workbook 2-11: <City Name 1-10>

    If there are up to 10 Cities required, the workbooks have to be manually named (for display and for referencing in formula etc).

    When copying the spreadsheet (workbook) for another person say, those city name would have to be changed manually also.

    If a separate "Display Name" were…

    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 →
  18. VBA code window scroll bar not working with touchpad

    Using my laptops trackpad with the "two finger gestures" enabled, I am able to scroll both vertically and horizontally in every single application and all throughout windows, Except for Office 365, VBA code window. I have tried repairing office, uninstalling and reinstalling even reimagining the PC but nothing works, not even a usb mouse! Please Please Fix!
    Device: Dell XPS15-7590, Win10 Pro 64Bit, Office 365

    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 →
  19. money in excel add affirm

    Add affirm as an option to pull in debt

    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 →
  20. Add options to the Excel "stock" function

    In order to make the Excel "stock" function far more useful, consider adding the following functions:
    1. Dividend TTM (trailing 12 months)
    2. Ex-dividend date.
    3. Next quarterly report date.

    These are a simple lookup in either the NASDAQ site or the Yahoo Finance site.

    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