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. 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  ·  Opening and Saving Files  ·  Flag idea as inappropriate…  ·  Admin →
  2. Indicator on file icon for files on sharepoint that are booked out. (Excel especially, for administrative maintanance.)

    The idea is to see which files are locked by online users who are busy working on files (Excel specifically).

    This means that there should be an indicator on the file icon in the browser, that works the same as the sync feature (the animated circling arrows that shows a file is in the process of being uploaded/synced).
    This will make choosing a file for editing (maintanance) easier using Excel offline.

    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 →
  3. hex2dec

    HEX2DEC should be able to process 64bit quantities. Figuring out we can write a formula like this to process such a quantity by parts ... just should not be necessary:

    HEX2DEC(LEFT(D9,8))*POWER(2,32)+HEX2DEC(RIGHT(D9,8))

    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  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  4. 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  ·  Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…  ·  Admin →
  5. Keep cell formatting when editing hyperlink

    When you edit a hyperlink (eg the screentip or URL), the formatting gets set back to default hyperlink styling (eg blue underlined Times New Roman). I use completely different styling for hyperlinks (Wingdings, with conditional formatting defining the font colour) and it's so frustrating having to re-apply the formatting once you have edited a detail of 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  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  6. Give us back our formatting windows, instead of the ridiculous formatting sidebars for objects, among other things.

    Give us back the formatting windows, instead of the formatting sidebars for objects in Excel 2016. It is impossible to navigate the sidebars using the keyboard, as one used to the windows, significantly decreasing productivity.

    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  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  7. Power Query Sharepoint Dates Don't reflect regional settings

    When querying a SharePoint list, it brings dates back as American format and not regionalised. Even though in SharePoint the date settings are set correctly to New Zealand, dates are incorrect. This also happens in Power Query in Excel and PowerBI. They display correctly in SharePoint. The query brings them back as Text, which also fails when converting to dates because our regional format is dd/mm/yyyy so any date like 16/11/2016 fails and gives an error. This makes querying SharePoint not really usable in our region. It also doesn't bring back timezone information.

    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  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  8. Find (and Replace) Next or Next-1 toggle

    I refer to the "Find // Replace" function within the "Find & Select" option.

    It would be much more useful if:

    a/ The "Find NEXT" would could be toggled to search backward

    &

    b/ That one was able to set personalize the DEFAULTS within the Options window

    Thank you

    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  ·  Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…  ·  Admin →
  9. Provide an option for multiple x-axes in xy-charts

    Display of multiple data-sets in a single chart does not only require multiple y-axes, but often multiple x-axes as well. It would be of great help to have the option for at least 2 x-axes

    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  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →
  10. Combo Chart using primary and secondary axes

    When i build a combo chart, some items are on primary axes and some on secondary because of different scales.

    However, the labels are all mashed up into one giant box. It would be far better if the labels were shown on the same axes as the data series. It would make the chart much more self-explanatory.

    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  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →

    Can you provide an example and steps for the problem that you are describing? Its not clear what you mean by “mashed up into one giant box.”

    Thanks,
    Scott [MSFT]

  11. Replace the #NUM! output with a useful description

    Excel is throwing me a #NUM! error when I try to use the NORM.INV function. This error is pretty much useless. The Excel application knows why it's throwing the error. Either I haven't loaded the function yet (and why would I need to, BTW), or it doesn't like one of the inputs. Rather than showing #NUM!, do something useful and give a detailed 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  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  12. Provide IBCS-Charts

    or buy ZebraBI (Add-In) www.zebrabi.com

    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  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →

    By IBCS, I assume you are referring to “International Business Communication Standards”. Could you provide more detail on what you are specifically looking for? IBCS is pretty broad.

    Thanks,
    Scott [MSFT]

  13. Open file

    If I have a workbook open and want to open another workbook, I would like an option to open within the same folder and not picking 'Browse', 'Recent Location' etc. If I use the 'Save As' button it does that, but 'Open' no longer does. Maybe an 'Open In' button? Thanks Microsoft for the opportunity to provide feedback!

    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 →
  14. More formatting options

    These are the existing format options available in excel

    General

    Number

    Currency

    Accounting

    Date

    Time

    Percentage

    Fraction

    Scientific

    Text

    Special

    Custom

    in most of my business cases i miss all the below fields

    Email

    Website url map
    Social Facebook Twitter
    Contact Mobile landline

    Pincode Country state

    Poll Q1 Q2 Q3
    Apps App URL

    it would be great if Office can consider adding more formating options
    in word,excel etc

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

    We’ll send you updates on this idea

    3 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  15. ability to have multiple relationships between tables in power pivot

    ability to have multiple relationships between tables in power pivot

    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 →
  16. change data source for all Pivot tables without VBA

    you cannot change the data source for 2 or more pivot tables (conneceted to the same data source) that "share" the same slicer.

    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  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  17. In PivotTables with many Value fields it is annoying to change them all from SUM to COUNT. Make this easier.

    In PivotTables with many Value fields it is annoying to change them all from SUM to COUNT. Make this easier.

    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  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  18. UNIVERSAL SHEETS AND WORKBOOKS MANAGER

    It is necessary to add A UNIVERSAL SHEETS AND WORKBOOKS MANAGER similar to file manager for OS. Plus different small features as toggling, vertical tabs and so on.

    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  ·  Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…  ·  Admin →
  19. 1040 Tax forms in PDF form can be coped to excel as a picture. I need a way to cut holes (boxes) to access various Excel cells to make activ

    1040 Tax forms in PDF form can be coped to excel as a picture. I need a way to cut holes (boxes) to access various Excel cells to make active forms (adding subtracting, multiplying and other functions) would then be available.

    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  ·  Graphics  ·  Flag idea as inappropriate…  ·  Admin →
  20. Directional sumproduct(a1:a10;b10:b1,c1:c10...) allowing one column to proceed downward, other proceed upward

    There is a new, super-powerful and easy method of solving systems of differential (and ordinary)-value-problem equations: the Parker-Sochacki solution to the Picard iteration (see Wikipedia, or ARXIV papers/1007/1007.1677.pdf for a how-to). It's easy enough to do by hand. But it requires a sumproduct that allows some columns to go forwards, while other columns go in reverse. It isn't practical to reverse the column with lookups (it's an iterative thing); and it's super-slow using visual basic. However, it should be super-easy to modify sumproduct() to do the job. Call it FRsumproduct(), and either allow a initial prefix string that tells the…

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

Feedback and Knowledge Base