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. Apply button for the Format Cells dialog box

    This would simply be the addition of an 'Apply' button in the format cells dialog box. This way formatting changes can be viewed without having to reopen the dialog box.

    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 →
  2. manage pivotcache to reduce file size

    to used the same pivotcache for pivottable, to correct the misallocations

    Printing or reading allocations like relations in Access

    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  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  3. Problem Activating Worksheets from Modal Form

    In Excel 2016 if a modal user form attempts to activate a protected sheet then it will not activate properly.
    This bug was also noted in Excel 2013 and appears to have been fixed in Excel 2016 for unprotected sheets but protected sheets still do not activate properly.
    The symptoms of an improperly activated sheet are that entering values will actually cause the value to be entered on the previously activated sheet. If that cell is protected (on the previous sheet) but not protected on the active sheet it will display that the cell is protected. Scrolling with the mouse…

    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  ·  Flag idea as inappropriate…  ·  Admin →
  4. 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  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  5. saving to onedrive

    If I have 2+ excel files open, and I close one, confirm saving, then it uploads to onedrive. While this dialog box window is open, I'm locked out of my other excel sheets until the file finishes saving to onedrive. If the file is large (100+MB), then this can lock me out for several minutes.

    I'd like all excel file activity to be contained in that window, and not interrupt or prevent activities in the other excel file windows.

    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  ·  Opening and Saving Files  ·  Flag idea as inappropriate…  ·  Admin →
  6. Place some indicator in the Row (1,2,3...) or Column (A, B, C...) header that there is data or formula within that entire row or column

    Before I begin to manipulate rows or columns, I check to see if my change will affect the data presentation elsewhere or include unintended information within my formula.

    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  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  7. Fix Formula Bar not activating sheet when Find window is open

    Fix Formula Bar not activating sheet when Find window is open
    This bug is in 2013&2016: if you open 2 workbooks (side by side) and use the Find window to find items in workbook A and then click the formula bar of workbook B to enter the info you want to xfer into workbook B, the info will actually overwrite the 'found' cell in workbook A. Try it, it is actually kind of funny to see.

    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  ·  Flag idea as inappropriate…  ·  Admin →
  8. Marking values presented more that once in filter window

    While working with purchase specifications, the same positions in differens rows often appear with different quantities in each row which should be summed up for sending a request. It would be very convenient to have values corresponding with more then one rows marked by font, color, etc. in filter window…

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

    We’ll send you updates on this idea

    6 comments  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
  9. Allow files to load from browser.

    Before the upgrade to Office 365 (I think) we had Office 2010. I was able to go to the file search window and select the file I wanted to open. A simple double click opened the file in Excel, Word, Power Point, or whatever.

    Now, the same action opens the application, but there is no file. I have to use the "File" menu within the program and search a second time to find the file and open it the long way.

    Please correct this error and do an update.

    Thanks,
    Kam

    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  ·  Opening and Saving Files  ·  Flag idea as inappropriate…  ·  Admin →
  10. Allow left and right vertical axes to sync their gridlines

    Suppose we have a left and a right vertical axis. One axis could have, say, five labels and tick marks, and the other could have seven. But there's no way to synchronize those items so that their gridlines can overlap.

    To implement this, you could offer a check box that would synchronize the two axes, or you could allow us to specify the number of tick marks on each axis so we could synchronize them ourselves. Better yet, you could offer both options.

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

    We’ll send you updates on this idea

    2 comments  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →
  11. Extend FIND and SEARCH to look for the Nth instance of a subtext in a longer text

    FIND and SEARCH currently will only find the first instance of a required text within a longer text and they always search from the beginning or to the right of a specified position. These functions would be much more useful if one could for example look for the third comma in a text or (most easily instituted by using negative counts) for the, say, third comma from the end of the text. So instance -1 of "a" in "banana" would yield a position of 6, the last "a" in the word, and instance 2 of "n" would yield 5, the…

    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  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  12. multiple case statements in switch function

    The new switch function is great. It would be even better if multiple case statements could be grouped together. Maybe SWITCH(expression,{value1,value2,value3,...},result1,{value4,value5,...},result2,...) or maybe SWITCH(expression,SWITCHOR(val1,val2,...),result1,...).

    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 →
  13. Add conditional TEXTJOIN

    There is a popular user defined function publishe on the web called CONCATENATEIF (http://stackoverflow.com/questions/22639868/vba-user-defined-function-for-concatenate-if-by-rows)
    It extends TEXTJOIN to include a conditional.

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

    We’ll send you updates on this idea

    4 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  14. Excel doesn’t register .xltx as a file type it is able to open

    Excel 2016 no longer registers .xltx as a file type it is able to open. This is clearly an error.

    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  ·  Flag idea as inappropriate…  ·  Admin →
  15. Top 10 filter + extra selection of your choice

    It is not possible to compare some item in a group with the top x of the that group in the same pivot table. It is useful to give some context to that that item when we produce reports. e.g. top 10 economies by GDP + the GDP of Cameroon.

    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  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  16. Capability to resize Title bar, Tab names (of masked Ribbon) and Quick Access Toolbar

    Hello,

    Moving from Excel 2013 to 2016 lead to loose 1+ raw (same zooming) because Title bar, Tabs of masked Ribbon and Quick access bar are higher. This is a problem at least for these reasons :
    - Sheets sized to fit a sceen (2013) ... don't fit any longer
    - Screens height became smaller with 16/9 (cinema format) pushing us to scroll and scroll...Various bars (Title, Quick Access, Menu..) are now taking more space see hard copy leading us to scroll even more !

    It would be great to be able to resize (height, text and icons) these bars…

    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  ·  Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…  ·  Admin →
  17. Generalize MINIF and MAXIF to be SMALLIF and LARGEIF

    The new conditional MIN and MAX formulae are great. Conditionalizing SMALL and LARGE would take this to the next level. A conditional version of SMALL based on the ordinary tool-set is very cumbersome.

    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  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  18. 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  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  19. Direct Query to Azure SQL Database, Azure SQL Data Warehouse, SQL Server

    I want to connect Azure SQL Database, Azure SQL Data Warehouse, and SQL Server by Direct Query of Data source.

    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  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  20. [VBA] Shape color is not visible with Excel 2016, but is with Excel 2013

    I've made a code for studying function SIN and COS. It's like an analog clock that shows only second hand(Line shape).
    It works as expected with Excel 2013. But with Excel 2016, second hand(colored red) cannot be seen, only marks(both ends of Line) can be seen.
    I've reproduced this, in Windows 7, 8.1, and 10.
    --- my code ---
    ' --- for "Sleep" スリープ関数(API)の宣言
    Declare Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long)

    ' ---[10] Analog Clock (display second hand) (アナログ時計・秒針を表示:サイン、コサインの練習)
    Public Sub prcShowAnalogClock()

    Call prc_Clear_Clock    ' -- delete Oval and Line already exist: 既存の円と直線を削除
    
    Application.ScreenUpdating = True
    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