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.

How can we improve Excel for Windows (Desktop Application)?

(thinking…)

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can support and comment on it.

If it doesn't exist, you can post your idea so others can support it.

Enter your idea and we'll search to see if someone has already suggested it.

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. Be able to select rows and columns and simply click DO NO SORT

    It is a massive ball ache sorting when it should not be this aggravating. Maybe I'm being stupid and there is a simple solution already, but I can't find it online and I can't figure it out myself.
    My annoyance is that I generally need to sort when I have multiple rows with text for headers, and some boxes need merging.

    I'll explain because some people say "do not merge", but this isn't always helpful.
    Current excel spreadsheet I'm working on.
    I included a picture of my spreadsheet so you can see. I want those top 3 rows to never…

    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  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →

    Hi,

    You can achieve what you’re asking for by inserting a blank row between rows 3 and 4 (where you don’t want any sorting to happen above the blank row).

    You can then make the row height very small (1px or so) so it doesn’t take up room on your sheet.

    Then, when you sort the content in your table, it won’t sort the headers.

    Hope that helps,
    Dan [MS]

  2. Associate XML file with Excel

    Update Office so that one of the opening options for XML files is Excel. Currently, when you open an XML file, it opens in Internet Explorer, and is unreadable

    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 →

    Hi,

    This is already supported. To open XML files with Excel, you can:

    1. Right click on the file in Windows Explorer
    2. Choose “Open with…”
    3. Select Excel from the list or browse for Excel.
    4. Optionally, select the box to “Always use this application to open XML files”

    That should do it.

    Cheers,
    Dan [MS]

  3. Find something - info in which cell is searched string

    If user use Find and Replace window Excel is moving sheet to place where it find what user search for. But for user is hard to find in which cell is searched string. Excel only give green box to inform user about cell. Can next to "Find what:" show user cell name where the searched string is f.i. "C41"

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

    Hi,

    To see the locations where the info you wanted to find exists, you can try these two things:

    If you just want to look for one cell, then the upper left corner of the app (to the left of the formula bar) will show you where the value was found in the grid (C41) for instance.

    If you want to see a list of locations where the value you are looking for exists, press Find All instead of just Find. Excel will show you a list of all the locations that contain the value you searched for.

    In the future, the Excel Tech Community is a great place to ask questions like this.

    Hope that helps
    Dan [MS]

  4. Set 8.43 as the default cell width for ALL versions

    Hi guys,
    almost a month ago I was working on a file on Excel 2010 (whose cells were 15 x 8,43), when all of a sudden Windows asked me to install the so-called "Windows 10 anniversary" update and, when I went on to open the file, I found out the cell width had gone from 8.43 to 8.38. As a result, only columns A through R would show on one page (before it was columns A through half of U), because each of them had gotten larger: I guess it was because 8.43 = 64 pixels and 8.38 = 72…

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

    Mariam,

    8.43 is the correct width (though, to be transparent, the cell width is based on the font used for the “Normal” style, so if you use a different font than Calibri there, then the width will be different).

    As you discovered, the change to Calibri as part of the Windows 10 Anniversary Update caused some issues with Excel formatting. You’ve got the workaround, and we’re in the process of getting a fix out there so you can use ClearType again.

    Cheers,
    Dan [MS]

  5. quick analysis improvements

    We need better sum and subtract quick analysis features that include the number in an existing cell rather than paste to a new cell reference. Especially helpful would be the ability to quickly subtract some positive values from another.

    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 →

    You can do this already.

    1. Copy the values you want to subtract from other values.
    2. Select the range you want to subtract those values from and choose Paste Special > Subtract

    Cheers,
    Dan [MS]

  6. Reduce the wasted space above the spreadsheet!

    Reduce the wasted space in the spreadsheet. Referring to the ribbons and spaces above the actual spreadsheet. Especially when viewing multiple files in horizontal arrangement, where there are groupings, the actual viewable spreadsheet real estate is tiny. Very annoying and unproductive having to constant scroll up/down the multiple files. In the past, it was possible to lessen the wasted space but somehow with the new ribbon design, you forgot why people use spreadsheets in the first place, which is to look at data not view the scenary.

    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  ·  Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…  ·  Admin →
  7. Allow me to insert things like 1-9 without automatically correcting to the date.

    basically what the title says. This is a thorn in my side, as there's no existing type of cell format for this input.

    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 →

    Hi,

    You can do this already in Excel today – there are two ways:

    1. You can type an apostrophe before the data you enter → ’1-9, and Excel will then not interpret that as a date (it will interpret it as Text).

    2. If you format the cell as Text before typing the value in the cell, Excel will not interpret it as a date.

    Hope that helps,
    Dan [MS]

  8. Countifs with multiple choice in the same range: COUNTIFS (A1:A20;">=32";A1:A20;"<85")

    Allow countifs to manage < and > in the same range.
    Example
    NOW: COUNTIFS (A1:A20;">=32")-CONTA.SE(A1:A20;"<85")
    IN THE FUTURE TO HAVE THE SAME RESULT:
    COUNTIFS (A1:A20;">=32";A1:A20;"<85")

    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 →
  9. have a amortized schedule not just for loans, but also for lines of credit

    have a amortized schedule not just for loans, but also for lines of credit

    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 →
  10. I would like to have the option of deleting a document (i am just learning the how to do it and I haven't found a way yet).

    I would like to have the option of deleting a document (i am just learning the how to do it and I haven't found a way yet).

    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 →

    To delete a document, simply select the file in Windows Explorer (or SharePoint Online or OneDrive – wherever the file is stored) and press the delete key on your keyboard.

    Hope that helps,
    Dan [MS]

  11. Bring back parentheses for negative number formatting

    Bring back parentheses for negative number formatting as in previous excel versions

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

    Using parentheses for negative number formatting is still supported by Excel (just like in previous versions).

    To use it:
    1. Select the cells/range you want to use parentheses when negative.
    2. Press Ctrl+1 to bring up the Format Cells dialog (or on the Ribbon, click on the Number format drop down, then select “More Number Formats…”)
    3. On the Number tab of the Format Cells dialog, select the Number category, and then one of the number formats that uses parentheses for negative numbers.

    Cheers,
    Dan [MS]

  12. New Shortcut to copy the content from previous cell (in the same row)

    For a long time we have Ctrl+d to copy the content from previous cell from the same column, it would be great if we have a similar key to copy the content from the previous cell in the same row

    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  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
  13. 1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    4 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →

    This is already supported in Excel 2010 and later when using PivotTables based on data from Analysis Services (or other write-back enabled OLAP providers).

    Cheers,
    Dan [MS]

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

    Hi,

    This is already supported in Excel. To clear a print area
    1. Click anywhere on the worksheet for which you want to clear the print area.
    2. On the Page Layout tab, in the Page Setup group, click Clear Print Area.

    You can see these steps here: https://support.office.com/en-us/article/define-or-clear-a-print-area-on-a-worksheet-2e5992fa-f201-41a1-9f39-370ff14deca1?ui=en-US&rs=en-US&ad=US#bmclearprintarea

    You can see this visualized here: http://www.solveyourtech.com/how-clear-print-area-excel-2010/

    Cheers,
    Dan [MS]

  15. Allow saving filters

    As a biz user, we filter sheets all the time ... and very often run through switching filters repeatedly. I mean that given a multiple columns, we might filter a few columns to see what the data says then someone else using the sheet may filter differently, and then we want to return to the original set of filters.

    The feature request is to save a snapshot of the filter choices with a name, so that users can prepare several combinations of filters and switch between them easily.

    This is particularly useful when the underlying data changes.

    Essentially, as a…

    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  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →

    Hi Rivan,

    If you are using AutoFilters for your filters, check out “Custom Views” which are accessible on the View ribbon, and allow you to save your filter settings.

    Cheers,
    Dan [MS]

  16. Protect some cells so that it dosn't accidently change by typing

    Some cells contain data that are final and should not change by accidently pressing a key, for example student's marks in exam.
    after entering such data I would like to be able to protect some cells, and I can unprotect later if I want. like in drawing applications you can lock a shape or layer

    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 →
  17. In Excel, when I had to change a word or a number, at the top of the sheet, I could do it, now I have to retype everything in the cell

    Fix Excel, so when you have to change a word, number or sentence within a cell you can do it without retyping all the information in the cell. I used to be able to do it, but it is no longer possible.

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

    This is still possible.

    1. Select the cell
    2. Select the part of the content you want to change in the formula bar (above the grid)
    3. Change that part of the content and hit

    Hope that helps,
    Dan [MS]

  18. auto border

    An automatic function that would put borders in your table in an automatic way.

    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 →

    You can do this a couple ways -

    1. If you apply a table style that has a border, you’ll get a border on your tables

    2. You can take #1 a step further by defining a table style (or customizing an existing one) to have a border you like, and then you can set that table style as the default table style.

    Of course, you can also add a border around your table using the border button on the ribbon too (but it’s not automatic, and takes two clicks per table).

    Cheers,
    Dan [MS]

  19. Fix problem where formulas display rather than their results, when this option has not been selected.

    Every now and then a formula displays rather than the result of the formula. I realize there is an option for this; however; on occasion it happens to a particular cell or range of cells when this option has not been selected. The rest of the worksheet functions properly. This has been an ongoing problem for years.

    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 →

    Hi, This happens when a cell is formatted as Text prior to entering a formula. Since formatting a cell as text is an explicit operation, Excel doesn’t “automatically change that formatting” when you enter a formula.

    Cheers,
    Dan [MS]

  20. Add gradient fill as a cell fill option

    The ability to fill a range of cells with a gradient color would allow for a greater level of creativity and a professional polished finished product.

    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 →

    One and Two color gradient fills are already supported. To add one,

    1. Select the cell you want to fill
    2. Press Ctrl+1 to bring up the Format Cell dialog
    3. Click on the Fill tab, then “Fill Effects…”

    Now you can create your gradient.

    Hope that helps,
    Dan [MS]

  • Don't see your idea?

Feedback and Knowledge Base