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. please add persian calendar (hijri shamsi) in excel 2013 (as like as 2016 version)

    Some people who use Persian calendar in excel, need to do calculation on date; some apps help them in this way but these are not perfect and they affect on other procedures... this problem is solved by Microsoft in 2016 version... So if it is possible, please add Persian calendar (hijri shamsi) in excel 2013 too.
    I am looking forward to see it in your next updates... thank you very much.

    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  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →

    Hi,

    We’re unlikely to add this in previous versions of Excel, as we don’t have regular updates of those versions, as we do with OFfice 2016.

    Cheers,
    Dan [MS]

  2. Expand possible locations in "Add a Place"

    Add a Place allows us to choose from iCloud Drive, Office 365 SharePoint and OneDrive.
    Could we add the choice to connect to other location such as a G Suite account in order to be able to save or save as in Drive.

    The only way around so far is to install the third party add in "Google Drive".

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Collaboration and Sharing  ·  Flag idea as inappropriate…  ·  Admin →

    Hi,

    This list can be customized, but only via add-ins as you’ve already noticed. The reason for that is that Office needs to know how to communicate with those storage locations, and each works differently – that’s what the add-in does.

    There’s no way for Office to allow you to enter a URL and have things “just work,” unfortunately.

    Cheers,
    Dan [MS]

  3. Axel - Combining Access and Excel into 1 excellent product

    Hello,

    I have been developing with Access and Excel for the last 17 years, it is my bread and butter and while I use VBA to communicate between the two I had the following thought...

    Wouldn't it be great if a new product came to market that contained both Access and Excel objects?

    Viewing Form tabs alongside Excel Worksheets in the same development window, showing sheets as objects in the same pane as tables and queries etc.

    A benefit of both data storage and calculations plus it would certainly be faster.

    You could call it Excess or Axel

    It would…

    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 →

    Hi,

    While we won’t be merging Excel and Access into a single product, we have been doing a lot of work in Excel to make it work better with data. Power Pivot, Power Query, and the Data Model are all tools that let you pull data from multiple sources, join and manipulate that data, and then do all of the ad-hoc reporting on it that you are used to doing in Excel.

    Cheers,
    Dan [MS]

  4. A spread sheet for farmers to keep track of their CCA

    I would like to see an excel spreadsheet set up for farmers to track their CCA class, asset descriptions, market and purchase value of equipment, trade in values etc Right now I have to try and set it all up myself. would be handy to have a sheet all set up

    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  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  5. Manage SQL Server table content

    I wish there was a simple way to manage data in an SQL Server table using Excel. We can read the data with current tools, but I hope we could also insert and update data using Excel.

    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 →

    Hi,

    This is an interesting idea, but one that we’re not going to integrate into the Excel product. Excel is really about connecting to, cleaning, and analyzing your data – it’s not about schema management or SQL Server management.

    A better tool to do that management is Access, or the free Microsoft SQL Server Management Studio.

    Cheers,
    Dan [MS]

  6. Allow indirect conditional formatting to adjust when columns are inserted

    Right now, if you use indirect conditional formatting, and a column is inserted between the formatted cell/column and the cell/column that drives the formatting, the indirect reference does not adjust.

    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 →

    INDIRECT uses strings to generate references. There is no way for Excel to know if the strings in INDIRECT should be adjusted or not – so they never are (in regular cell formulas or CF).

    Cheers,
    Dan [MS]

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

    There is no good way for us to know (with certainty) when a user is actively working in a workbook vs. just has left Excel open. As such, we are unlikely to do this feature, as it would be “wrong” at least as often (probably moreso) than it would be “right.” As an example – a user could be reading or transcribing numbers from an open sheet – so it would look to Excel like there was no activity, but if you asked the user, they would say “of course I was using Excel.”

    Cheers,
    Dan [MS]

  8. numbers and not formulas in the cell

    in a formula, add the possibility to write a symbol after = to say that you want to write just the result, and not the formula, in the 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  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →

    Formulas are a key part of Excel, so we won’t be auto-converting them to values on entry. However, you can convert them to values by selecting the cell after you’ve entered the formula and copying it (Ctrl+C); then Paste Special (Ctrl+Alt+V) and choose Values.

    That will leave the number in the cell, rather than leaving the formula there.

    Cheers,
    Dan [MS]

  9. Power Excel

    Rename and rebrand Excel to become 'Power Excel'
    This would reflect its modernity, point towards closer integration into Power BI and truly distinguish the product from old Excel
    Modern Excel with all the new functionalities therein represents a tremendous analytic arsenal at your disposal yet most users are unaware of this
    A product name change would immediately change perceptions and promote awareness
    Office 2017 Pro Plus comprising Word, Access, Outlook, Power Excel

    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  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →

    Hi Anthony,

    While I personally love the implications of renaming Excel to Power Excel, this isn’t something we’re going to do at this point in time. The (Microsoft) Excel brand is already a well-known brand, and we’re going to look for ways to drive awareness of the new functionalities in that brand rather than change the brand itself.

    Cheers,
    Dan [MS]

  10. Excel Sort v/s Folder Sort

    The sort order in excel is different then sort of files in a particular folder, eg.

    Folder sort
    abc 10.txt
    abc 12.txt
    abc 111.txt

    Excel Sort
    abc 10.txt
    abc 111.txt
    abc 12.txt

    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  ·  Flag idea as inappropriate…  ·  Admin →

    This is not one we’ll be changing, since Excel has sorted this way “forever” and we don’t want to break solutions that rely on this sort order.

    (I think Windows changed their sort order in the Windows Vista-ish timeframe)

    Cheers,
    Dan [MS]

  11. If statement consistent formulas

    How IF statements currently work:
    A1=3; B1=2; C1=1;
    IF(A1>B1>C1, "True", "False") Results: True
    IF(C1<B1<A1, "True", "False") Results: False

    Both these statements should be true, but the second one gives the wrong results. For situations like this the logic statements are only correct if the > symbol is used; otherwise the true and false statements get flipped.

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

    We’ll send you updates on this idea

    3 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →

    Given the way Excel evaluates formulas, which is from left to right, this isn’t going to change. Here’s what happens:

    IF (C1<B1<A1, “True”, “False”)
    IF (1<2<A1, “True”, “False”)
    IF (TRUE<3, “True”, “False”) <— you can see how the next check will fail (be false)
    IF (FALSE, “True”, “False”)
    “False”

    The way to write this function so that Excel will do the right thing is:

    IF (AND (C1<B1, B1<A1), TRUE, FALSE)

    Hope that helps,
    Dan [MS]

    (sorry for the wonky formatting, apparently there’s some UserVoice markup I have to work around)

  12. Enable the Power View feature in Excel 2016, it would be very helpful.

    Enable the Power View feature in Excel 2016, it would be very helpful.

    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  ·  Flag idea as inappropriate…  ·  Admin →
  13. Dates in Pivot Tables dont group correctly depending format existing in data.

    If you have date column in a Pivot Table and change format to GENERAL, pivot table duplicate days. Example:

    Fill Column A with dates, A2:A4 with date 1/9/16, A5:A7 with 2/9/16 and A8:A10 with 3/9/16.
    Create Pivot Table and put ColumnA as row (or column)
    Change A4:A5 to GENERAL format.
    Refresh Pivot Table. The days (1/9/16, 2/9/16) are duplicated!!!

    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  ·  Flag idea as inappropriate…  ·  Admin →

    When you format cells as General, Excel starts treating them as numbers rather than dates (in fact, the cells even display the values that originally represented the dates entered (42378, 42409).

    Since Dates are treated specially in Pivots (and Tables), when you have dates and numbers (the entire column isn’t dates), Excel treats it as “mixed data” and shows all unique data items – in this case, showing the numbers as dates b/c that’s how the PivotTable column was created.

    If you change the number format of the PivotTable field to “General” (as done with the cell values) – by right clicking on it, choosing Field Settings > Number Format > General, it will show the mixed format values in the PivotTable.

    Hope that helps. In the future, answers.microsoft.com is a great place for questions like this.

    Cheers,
    Dan [MS]

  14. The File ribbon should be separate form the other ribbons

    The File Tab opens a full screen page of options and constantly lags. This should be on a different row than, "home, insert, page layout" etc

    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 →

    The Ribbon (across all apps that have a Ribbon) is consistent in that it has a single row of tabs. We aren’t going to change that.

    Cheers,
    Dan [MS]

  15. Selecting an area, mark the info in cells with another colour (default: light grey), just like in previous versions

    I know many people do not like the idea of 'supporting columns' integrated in the worksheet for the user. But I'm all for it. Font in same colour as background colour so no one sees it. If I'd like to quickly check what value the formula returns, I'd only need to select an area incl. that cell. The darker grey colour, to mark the selection, is of another shade of colur than the font.

    At least until Excel 2010 this was always standard in excel. In the Mac version it still is the case! Please guys, would you consider going…

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

    We’ll send you updates on this idea

    3 comments  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →

    Hi Maarten,

    We aren’t going to be changing the selection color in order to make “hidden text” show up more easily because we don’t think that “hidden text” is a good thing in spreadsheets (generally).

    Have you considered adding column to your sheet and simply toggling the hidden/visibility of that column (hide/show) based on whether you want to see the notes?

    Cheers,
    Dan [MS]

  16. Add a function returning the corresponding quadrant to a specific angle.

    Add a function returning the corresponding quadrant (1, 2, 3 or 4) to a specific angle. Preferrable with the option to choose input angle in degrees or radians.

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

    We are unlikely to add a specialized function for this, but the great thing about Excel is that formulas allow you to build this function already. As Kenneth explained in the comments, you can do this today with existing functions (I can’t copy them here due to some we’re UserVoice formatting with the MOD function)

    Hope that helps,
    Dan [MS]

  17. 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  ·  Opening and Saving Files  ·  Flag idea as inappropriate…  ·  Admin →
  18. Multiple copies

    Stop making multiple copies of same spreadsheet. This is very confusing, and I end up sometimes entering data on the wrong one.

    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  ·  Opening and Saving Files  ·  Flag idea as inappropriate…  ·  Admin →

    Excel doesn’t automatically make copies of spreadsheets except for AutoSave, but that only kicks in if Excel is closed unexpectedly. It sounds like that’s not what is happening though, so it’s more likely that someone is choosing “Save As” to create copies of the workbook.

    I’m declining this idea, so you get your votes back.

    Cheers,
    Dan [MS]

  19. cortana should have the ability to be completely disabled in all its functionalities

    cortana should have the ability to be completely disabled in all its functionalities

    1 vote
    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 →

    Cortana is not something developed by the Excel team, and unfortunately we don’t have the ability to pass this on to the Cortana team.

    Cheers,
    Dan [MS]

  20. make Microsoft

    Make Microsoft Works available at no cost for average homeowners use

    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  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?

Feedback and Knowledge Base