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. Allow back-up macro code to be saved/backed up separately! When working with macros, I'm finding that it's maddening when to open a saved

    Allow back-up macro code to be saved/backed up separately! When working with macros, I'm finding that it's maddening when to open a saved xlsm to find the ode has disappeared!

    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 →
  2. 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  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
  3. chart black and white

    In chart tools, the most commonly used color scheme for technical presentations of experimental data are black and white charts with differing markers. This used to be available in the old versions of MS Excel probably 2010 and older but was dropped to give way to colored plots. However, most academic journals still prefer a black and white plot with a legend for the different markers used.

    This can be manually made but it is very tedious when working with a large amount of data.

    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  ·  Graphics  ·  Flag idea as inappropriate…  ·  Admin →
  4. Bug fix: triggering sheet calculation

    Rather than re-writing the steps to repro, please see this post in the MS Office forums (steps to repro are in one of the follow-up posts)

    https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_winother-mso_2016/bug-pastevalues/c196c0d0-c68c-40c6-9d5f-681f65421f6f
    Thanks!

    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  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  5. Sideways scrolling bar back where it belongs -> Down!

    The sideways scrolling bar should be put back into same bar where the zooming is, as it is mostly empty, but now it is annoyingly hiding excel tabs for no reason.

    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  ·  Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…  ·  Admin →
  6. Increase Locked Table Length

    Please PLEASE allow tables to expand when the sheet is locked! At the moment I have had to write code to unprotect the sheet, expand the table, and reprotect! This is labourious and time consuming. Implement this option to make tables even more powerful!

    5 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 →
  7. sheet/range protection management in Google Sheets is better: Excel should catch up

    See subject. Google Sheets method of setting sheet protection and allowing integration, enumeration, of individual range protection for all exceptions in one place is way cool. Naming of protection rules is probably a useful feature too.

    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  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
  8. formula editor for Google Sheets is much better: Excel should catch up here

    See subject. Colorization, more visible parenthesis highlighting, better in-line function help, more specific diagnostic info showing where the problem is exactly (If expected 3 arguments...) and so on. A day using Google Sheets was quite a revelation about the possible as compared to Excel. There are just a lot of things about Sheets to like.

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

    Hoje o subtotal (dados) somente tem 1 opção "a cada alteração em:". Se possível acrescentar 2 ou 3 para torna-la encadeada, pois posso somar valores de um mesmo dia e dentro do dia somar os valor faturado de cada produto.

    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  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  10. #REF!

    Sinalizar células que apresentam erro de referência #REF! assim tornaria mais integro os dados, pois mesmo com erro de referência algumas fórmulas não apresentam o erro.

    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  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  11. Please add "IP" functions, formats, formulas, macros, etc.

    Please add the format "IPv4", "IPv6", and let us operate (addition, substraction, multiplication, division, subnetting of IPs) also wildcard and subnet mask,

    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 →
  12. Add MSCOMCTL.OCX to Excel 2016 --- so we can add a dropdown calendar to our cells

    There is no MSCOMCTL.OCX for 64 bit and you have to go through a lot to get the 32 bit and then extract it to the right place so you can use this feature. There is no other way to put a calendar in the drop down for a cell.

    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  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  13. Insert tolerance curves to the graphical trend line

    On your graphic, when you add the trend line, it can be very useful to have the possibility to add the upper limit and lower limit lines. For example, the X axis contains the number of hours due to projects, and the Y axis contains the projects' price. It would be very useful to implement limits (up and down) to the trend line. Then, you can have an estimation of the number of hours you can use for a project of a certain price, and vice versa.
    You fix the percentage of gap you want (Exemple +/- 10%) and 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  ·  Graphics  ·  Flag idea as inappropriate…  ·  Admin →
  14. Disable run on start and set start on trigger for office click to run ( ClickToRunSvc )

    On most PC's Office is used at some times. But the CTR (Click To Run) is always on. It doesn't have to be. A new Windows 10 is coming for low performance PC's... Microsoft Office still needlessly uses resources....

    Taken from msdn.microsoft.com/en-us/library/windows/desktop/dd371723(v=vs.85).aspx

    "Reduce resource usage when the system is on battery power
    Your application should reduce its resource usage - such as background update frequency - when the system is on battery power."

    This makes me wonder how much power is consumed worldwide by needles background programs like these?

    For now I've made a new Excel/Word.exe that start CTR and…

    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  ·  Performance  ·  Flag idea as inappropriate…  ·  Admin →
  15. Add if like functionality to more mathematical functions

    Currently SUM and COUNT function classes have additional IF functions to do conditional operations. Please add similar functions to more mathematical functions especially statistical functions to make the product more versatile and user friendly.

    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 →
  16. Format Specific Gridlines

    When formatting the colour or style of gridlines, the formatting will apply to either ALL major or minor gridlines. There are values I would like to highlight at +15/-15 that would help if i could highlight two specific major gridlines as opposed to every single one.

    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  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  17. Move to the bottom of function list using UP ARROW

    Please add an ability to move to the bottom of the function autocomplete list using the UP arrow key. When you start entering a function, for example, =S..., then it would be nice if you could move to the BOTTOM of the function list (using UP arrow key). Sometimes you know that the function is in the end of the list and want to move there quickly. This is available on Google Sheets,which I use for some of my projects. Right now, it is not possible in Excel, except with Page Down or Page Up, which only go as far…

    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  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  18. Mouseclick to opened Excel-TAB shall be moved to 2nd screen

    in order to open a 2nd instance of the currant working sheet, I would like to click to the below TAB and move it to the 2nd Screen.
    Ich will unten den Reiter anklicken und auf den zweiten Bilschirm ziehen, sodass ich eine Excel-Datei mit zwei Reitern zugleich geöffnet habe, sodass ich Reiter 1 mit Reiter 2 vergleichen kann.

    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  ·  Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…  ·  Admin →
  19. copy and paste no border

    Copy and paste should not include borders. I am doing financial spreadsheets and I made some borders. but when I copy and paste numbers around, the borders get all messed up. Very annoying!

    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  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
  20. 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  ·  Application Errors  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?

Feedback and Knowledge Base