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. Make Conditional Formatting Rules Editor window sizable.

    Make Conditional Formatting Rules Editor window sizable.

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

    We’ll send you updates on this idea

    29 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →

    Thank you for taking your time to suggest and vote for “make conditional formatting rules editor window sizeable”. While this is an interesting suggestion, we don’t think that we’ll be able to work on this in the near future. When our plans are updated we will re-open voting and you will be notified.​

  2. Fix the "There's a problem with the clipboard" issue

    The issue with "There's a problem with the clipboard..." while copy and pasting is still as issue. I was using Office 2010 and there was no problem. I am now using Office 365 and this issue is prevalent. It manifests itself when pasting a value from a cell containing a formula and disappears when disabling Live Preview. I was able to copy and paste "normal" cell contents fine before the error message appears so the official response of "another program has locked the clipboard" doesn't really hold up. It looks more like Excel has locked the clipboard from itself.

    There…

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

    We’ll send you updates on this idea

    40 comments  ·  Flag idea as inappropriate…  ·  Admin →

    Thank you for voting for “there’s a problem with the clipboard” issue. I this this refers to this error dialog: “There’s a problem with the clipboard, but you can still paste your content within this workbook."

    When Excel shows this dialog after a copy (CTRL+C) action, it means that another app has a lock on the system clipboard. In this situation you can still paste within Excel. However you cannot paste to another app like Word or Outlook which uses the clipboard.

    A while ago we made some improvements for Office365 users so that this error message only shows once per Excel instance. This was based on customer feedback – the design change prevents it popping up multiple successive times when the clipboard is locked. We have also considered never showing the error dialog, but there was user feedback that this message is informative and helpful in some cases.

    Should…

  3. Add Get Parameter button to Power Query and avoid Privacy / Formula.Firewall problems

    It's fantastic that you can pick up named ranges in Excel and pass them to Power Query as parameters. However the process is cumbersome and often results in Formula.Firewall warnings or other issues.

    This leads to having to switch Privacy Levels to "Ignore" or having to write a query within a query rather than nice and clean "parameter" queries.

    It would really simplify things if we could quickly create parameter queries (including a drop down to select parameter type) and that these queries would be immune from the Privacy warnings.

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

    We’ll send you updates on this idea

    12 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →

    Hi all,

    Thank you for taking your time to suggest and vote for adding Get Parameter button to Power Query. We do think that this suggestion has merit but we don’t think that we’ll be able to devote time to it in the near future. When our plans are updated we will re-open voting and you will be notified.

    Thanks,
    Guy Hunkin
    Excel Program Manager

  4. Setting Autofill Default

    Setting Autofill Default

    No option to set AutoFill default to the option you want.
    Even for numbers or dates you should be able to use "Copy Cells" in stead of "Fill series"

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

    We’ll send you updates on this idea

    52 comments  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
  5. Open multiple files with the same file name

    Allow excel to open files with the same name but different location at the same time

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

    We’ll send you updates on this idea

    4 comments  ·  Opening and Saving Files  ·  Flag idea as inappropriate…  ·  Admin →
  6. Pin worksheet tab

    I would like a simple option to allow you to pin worksheets so they are always available in the workbook irrespective of the number of worksheets there are.

    I.e. when you right click the worksheet tab there is an option to pin so you can quickly gain access when you have a large number of worksheets.

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

    We’ll send you updates on this idea

    10 comments  ·  Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…  ·  Admin →
  7. Filtering: Show count in filter box and add navigation buttons

    Filtering:

    When filter button is pressed on any column, the drop down menu should -


    1. Show number of recurrences of each unique value displayed in the drop down list, in brackets on the right side of each unique value, in grey font. This will be very helpful in knowing, by just dropping down filter menu, how many records are there for each of unique values shown in the filter drop down list. Currently we have to filter each value and run a countif formula in a help column or look at the bottom line that shows how many records are…

    50 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 →
  8. Format cell as a checkbox (TRUE, FALSE)

    Offer a format that displays the boolean value of a cell as a checked box if TRUE, unchecked box if FALSE, grayed box if text or other nonbool.

    Bonus: Toggle value OnClick would be intuitive.

    Lots of uses for this. Current options are awkward for users. Yes/No dropdown is not as good as a checkbox for touch/mobile.

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

    We’ll send you updates on this idea

    31 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  9. recent filters

    Have a Control with the most recent filters (last 5 to 10 filters), so the filters can be reapplied to an existing table.

    This should enable power users to work faster and Archive more in Excel.

    37 votes
    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 →
  10. Make the Go To box SCALABLE

    Formulas / Trace Dependents / make the resulting list box SCALABLE.

    It is 100% useless if the full name of the referenced cells cannot be seen in their entirety, which is usually the case.

    I know others have been asking for this for YEARS.

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

    We’ll send you updates on this idea

    3 comments  ·  Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…  ·  Admin →
  11. Allow the option to list pinned files either alphabetically or by recent use.

    Excel 2016 switched the order of the pinned files from alphabetical to most recently used. IMHO, that was a big improvement. Apparent;y that change has been reversed.

    Pre-2016 I only pinned 4 of 5 files that were hard to find or only used monthly. Files I used Daily I pulled from the recently used files.

    In 2016 I switched to pinning about 20 files. The ones I used daily or weekly are always near the top. The ones I use monthly are farther down but easier to find than going to the various directories.

    For me, going back to the…

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

    We’ll send you updates on this idea

    27 comments  ·  Opening and Saving Files  ·  Flag idea as inappropriate…  ·  Admin →
  12. Enable Headers and Footers to include variables based on a cell reference

    It would be great if a cell reference could be used within a header and/or footer

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

    We’ll send you updates on this idea

    5 comments  ·  Printing  ·  Flag idea as inappropriate…  ·  Admin →
  13. Fill Handle For Worksheet Copy

    If I have a worksheet called January and I Ctrl+Drag that sheet to make a copy, Excel should automatically call it February. Use the same logic as the Fill Handle (support months, weekdays, and any custom list).

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

    We’ll send you updates on this idea

    12 comments  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →

    Thank you for taking your time to suggest and vote for the “fill handle for worksheet copy”. While this is a good suggestion, we are not likely to be able to devote time to it in the near future. When our plans are updated we will re-open voting and you will be notified.​

  14. Display Status Bar of Inactive Window 2016 Excel

    In Excel 2010 we were able to highlight numbers and have their sums displayed in the grey status bar towards the bottom of the sheet. Working with 2 monitors, this feature was very helpful.

    After upgrading to Excel 2016 the status bar of the non active/selected workbook disappears instead of the sum being viewable of the non active workbook.

    The feature was helpful for at least 2 open excel instances where we can view the sum of the non active workbook and it would be great to have back instead of being forced to click in out of each workbook…

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

    We’ll send you updates on this idea

    33 comments  ·  Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…  ·  Admin →
  15. Enable Merged Cell Sorting

    For rows or columns that contain merged cells, all rows or columns associated with the merged cells should be treated and sorted as 1 row or column.

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

    We’ll send you updates on this idea

    7 comments  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
  16. 471 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    114 comments  ·  Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…  ·  Admin →

    Thank you for taking your time to suggest and vote for this. We do think that this suggestion has merit but we don’t think that we’ll be able to devote time to it in the near future. When our plans are updated we will re-open voting and you will be notified.

  17. Filtered Columns - change colour of icon

    When a filter is applied in a header row, the filtered column(s) gets a "Funnel" icon to indicate that it has been filtered. In a row where multiple filters have been applied, if, in addition to having the funnel icon, the "filtered" icons came in a different colour - say a limited choice of colours for the user to pick from - then that would make the filtered columns easier to spot. For a user looking for the first time at a file and wanting to find what columns have been filtered, having the "filtered" icons in a different colour…

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

    We’ll send you updates on this idea

    5 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  18. Watermark

    Add a Watermark Tool with the same functionality as MS Word

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

    We’ll send you updates on this idea

    20 comments  ·  Printing  ·  Flag idea as inappropriate…  ·  Admin →
  19. Give us a "Center Across Selection" option for the Vertical text alignment

    "Center Across Selection" is available for Horizontal text alignment but not for Vertical text alignment.

    This would be useful for heading columns where the text is rotated through 90 degrees and spans more than one row.

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

    We’ll send you updates on this idea

    10 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  20. VLookup and Inserting Columns: VLookup should increment the col_index_num when you insert a new column in the range.

    When you insert a column and it affects the range referred to by a vlookup, the table range updates but the column index number does not. The column index number should increase with the table range so that the same column is pulled. I can't think of a scenario where inserting columns in a table but not updating the column index is a user's intended course of action.

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

    We’ll send you updates on this idea

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

    Since the XLOOKUP function is now available in Excel to O365 subscribers, we recommend using it to accomplish what you need to do. With XLOOKUP, there’s no index number. You provide a range reference, so it will automatically adjust if you insert a column that causes the range to move.

← Previous 1
  • Don't see your idea?

Feedback and Knowledge Base