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. vlookup returns formatting of target cell not just data within target cell

    Vlookup currently returns only array data within a looked up cell only into my target cell. I require any cell formatting found in the looked up cell such as colour fill to be returned in the vlookup function to the target cell. If the vlookup did this automatically rather than me having to then create conditional formatting rules for each variable of data returned from the array after vlookup has completed its job returning the data from my array into my workbook it would make the vlookup tool much more powerful.

    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  ·  Performance  ·  Flag idea as inappropriate…  ·  Admin →
  2. Unique Filtering Bug Excel 2013 (extremely slow)

    This is still a problem even with the latest Excel updates.

    I have 2 columns, with 175,000 lines.


    • Column A contains a 5 digit number.

    • Column B contains a value (between -50 and 100).

    Steps to reproduce:

    1) I have cleared all filters, formats, and there are no extra rows / columns on the sheet.

    2) I select Column A and Column B.

    3) I click "Advanced Filter".

    4) I click "Criteria" text entry.

    5) I select Column A.

    6) I select "Unique Records Only".

    Result:

    I then see windows blinking open and closing in Excel, while it takes up…

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

    We’ll send you updates on this idea

    2 comments  ·  Performance  ·  Flag idea as inappropriate…  ·  Admin →
  3. 16 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 →
  4. Combine cells, increase command utility

    COMBINING CELLS should offer the possibility of displaying in the new block only the contents of the first cell or the concatenated contents of all cells, without deleting the actual contents of each cell, which will be shown again when the block is undone. This would greatly enhance the performance of the command.

    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  ·  Performance  ·  Flag idea as inappropriate…  ·  Admin →
  5. Background colors for ribbon and QA toolbar

    The QA toolbar and the Ribbon need separate color controls. The themes wipe out all of the colors normally on each icon making them all look the same and hard to distinguish. Only fixable with the White theme but then the ribbon runs into the rest of the document. Needs a contrast!

    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  ·  Performance  ·  Flag idea as inappropriate…  ·  Admin →
  6. please add black office theme in office 2016

    Please do add black theme in office theme for 2016

    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 →
  7. Speed up lag

    Keyboard input lag on the newest versions of excel (including 2013) is extreme. Business and power users value speed above flashy looks. Please bring back the snappiness of the old versions.

    4 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 →
  8. Calculate Selection

    If you go to "FORMULAS/Calculation Options/Manual". Once manual is selected, there are only two options for calculations
    1. Calculate Now: For all sheets in a spreadsheet
    2. Calculate Sheet: for a single Sheet

    I suggest "Calculate Selection". This will be a smaller subset than "Calculate Sheet" that will only focus on the cells selected.

    I work with very large files (~40MB+ if saved as xlsb) and very often I have to work on manual calculation mode to be able to handle the data. Once I am ready I use "Calculate Sheet" to speed the process, but speed is an issue…

    4 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 →
  9. swap

    SWAP
    I am frequent user of excel. many time I'll face the problem during changing/ bringing rows front and bottom and vice versa.
    if you provided the swap option it will be very helpful for the quick finish of work.
    and also provide some shortcuts to that, so that it made more accessible.

    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  ·  Performance  ·  Flag idea as inappropriate…  ·  Admin →
  10. Make a noise when long calculations complete

    Make a noise when a long calculation completes. This way we can work in another window while the "Calculating 20 processor(s): % creeps up".

    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  ·  Performance  ·  Flag idea as inappropriate…  ·  Admin →
  11. Implement Nvidia CUDA Parallel processing to decrease processing times on Nvidia powered machines

    I am not entirely sure how this would be preformed but I have seen examples of excel using the processing power of a GPU to massively decrease calculation times when working with functions that can take advantage of the parallel processing that the GPU is capable off.

    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  ·  Performance  ·  Flag idea as inappropriate…  ·  Admin →
  12. What-if Data Table calc should use multi-threading

    Calculation Performance of iterative what-if Data Tables is unnecessarily slow. The reasons seem to be (in priority sequence):
    - each iteration is using single-threaded recalculation rather than multi-threaded
    - the overhead for the whole table calculation looks larger than it should be
    - the process starts with a recalc, then does each iteration, then ends with a recalc: the first recalc is unnecessary
    - if the values to be used in one of the iterations are the same as the start values the recalc for that set of values could be skipped

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

    We’ll send you updates on this idea

    4 comments  ·  Performance  ·  Flag idea as inappropriate…  ·  Admin →

    Many thanks to Charles for taking the time to analyze this in such detail and start the discussion about improving the efficiency of data tables. Please vote for this issue if it’s important to you so we can prioritize it appropriately.

    Thanks,
    Steve (MS Excel)

  13. Fix the scrolling issue in 365

    Currently when I using a mouse wheel to scroll down any excel charts, the page scrolls down in leaps instead of tiny increments. Changing the scrolling to progress down the page in tinier increments will provide users a much smoother experience. The current scrolling is problematic, because when scrolling through large cells the page appears to 'jump' down or up very quickly and it is hard to keep track of whether you have missed a cell. It is not possible to smoothly scroll from the top of an excel sheet to the bottom because it is so jumpy. This also…

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

    We’ll send you updates on this idea

    2 comments  ·  Performance  ·  Flag idea as inappropriate…  ·  Admin →
  14. Better use of my processor's cores.

    When I look at my task manager, Excel is usually only using approximately 14% of my CPU. I work with huge spreadsheets that take a long time to calculate. Why doesn't Excel use my idle processor cores / threads?

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

    We’ll send you updates on this idea

    2 comments  ·  Performance  ·  Flag idea as inappropriate…  ·  Admin →
  15. Short-circuit evaluation for AND and OR

    If any argument of AND is FALSE, then AND is FALSE; no need for further evaluation.
    If any argument of OR is TRUE, then OR is TRUE; no need for further evaluation.
    However, the arguments of AND and OR always evaluate fully, which wastes calculation time and computer power.

    The current workaround, which sacrifices clarity, is to write AND(a,b,c) as IF(a,IF(b,c)) and OR(a,b,c) as IF(a,TRUE,IF(b,TRUE,c)), since IF skips the evaluation of the branch not taken.

    The only time that the change to short-circuit evaluation would not be desirable is in a case such as AND(something,UDF()), where UDF() is a UDF…

    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  ·  Performance  ·  Flag idea as inappropriate…  ·  Admin →
  16. Filtering should not recalculate the filtered range

    This also applies to row/column hiding/unhiding and unfiltering. Excel should recalculate only the formulas that use SUBTOTAL on the range whose cells' visibility is being changed.

    This is a major performance issue when the filtered range has many dependents. The performance decrease is also unjustified when SUBTOTAL is not even used.

    References:
    http://www.pcreview.co.uk/threads/why-does-excel-recalculate-when-i-make-a-different-filter-selectio.3685266/
    http://answers.microsoft.com/en-us/msoffice/forum/msofficeexcel-msowinother/excel-wrongly-recalculating-when-changing-filter/9c79ed0f-74dd-45ce-964a-df5e6c2d1bc8

    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  ·  Performance  ·  Flag idea as inappropriate…  ·  Admin →
  17. Allow user to create multiple customized toolbars

    Excel 2003 and prior had a wonderful feature - they allowed a user to create multiple customized toolbars with custom icons picked from a selection library or created in an image editor.

    Pity Microsoft did away with that feature and replaced it with the disaster that they call a ribbon. It is sub-optimal for a power user and takes up too much screen space on a laptop.

    Bring back the multiple customizable toolbars and keep the Excel 2010 feature that allows you to export the customization to a file and import on another Excel 2010 installation.

    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  ·  Performance  ·  Flag idea as inappropriate…  ·  Admin →
  18. Keyboard Shortcuts need to go Quicker - as they did in 2010

    Keyboard Shortcuts need to go Quicker - as they did in 2010. Any finance professional or analyst will tell you that when using shortcuts in 2013, they have to wait for the keys to finish cascading before the demand will take effect. As an example, when you use Alt+HVSV and then hit escape, it takes so long that it escapes without pasting anything. This problem did not exist in earlier versions of excel, so there must me some way to revert back to the performance levels of the old shortcuts. I know several people who refuse to update MS Office…

    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  ·  Performance  ·  Flag idea as inappropriate…  ·  Admin →
  19. Calculation time remaining

    When Excel is calculating, we currently see something like "Calculating (4 processors): 99%" in the status bar. "Time remaining" would be useful as well.

    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  ·  Performance  ·  Flag idea as inappropriate…  ·  Admin →
  20. Need a better distinction between "long calculation" and "frozen/crashed"

    There are calculations so large and long that Excel is unresponsive until they are done. It will say something like "Book1 - Excel (Not Responding)" in the title bar. The GUI will not update and will fade if you try to click in it with your "hourglass" cursor.

    If I didn't know any better (and I used to not know any better), I would assume that Excel was frozen and just kill the process and lose all of my saved work. But it isn't frozen. It's just taking a very long time. This should be made clear to the user…

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

    We’ll send you updates on this idea

    6 comments  ·  Performance  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?

Feedback and Knowledge Base