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. Single Page Zoom

    When in Page Layout mode, have the option to zoom out on one page. Word has a "One Page" option in the zoom settings. Excel is default to "Multiple Pages" when zooming out and scrolling. Would be nice to see how the document will appear printed out.

    See attached for what is available in Word.

    28 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    4 comments  ·  Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…  ·  Admin →
  2. Add a CONTAINS("find_text","within_text") Function

    Excel's own documentation recommends pairing the ISNUMBER and SEARCH functions to accomplish this, but I still have team members asking on a regular basis for a function that returns whether a string is found within a given cell. An out of the box CONTAINS() function would go a long way for usability.

    8 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  3. Fix this problem: "sometimes you might find yourself with a workbook that has links you can’t find even though Excel tells you they exist. "

    Fix this ridiculous problem: "Sometimes you might find yourself with a workbook that has links you can’t find even though Excel tells you they exist."

    41 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    6 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  4. Please Please Please Bring Back MDI. SDI simply doesn't support the types of applications I have spent my career developing in Excel

    Please bring back MDI for Excel. SDI is really slow, and crashes when I run the apps I've developed over my career that rely on multiple workbooks loaded simultaneously. Or re release 2010 and just call it the version for the folks who rely on MDI and there are a lot of us!!!!!!

    11 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Performance  ·  Flag idea as inappropriate…  ·  Admin →
  5. Select Pivot Table by name

    I would like to have the possibility to select a PivotTable by name.

    In a PivotTable chart, the source tells you what is the PivotTable name but then, you have so select all your PivotTables one by one to find the correct PivotTable.
    So if you can add a tool that is able to select a PivotTable by name, it will save a lot of time.

    Thanks

    8 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  6. Turn OFF AutoSave feature permanently

    I'm frequently using saved files as templates. With the new AutoSave function my old files get overwritten as soon as I start editing the file. I have to save the new one immediately with another name otherwise I'll loose the old one. This is annoying.
    Pleas allow to deactivate AutoSave function in the Option settings.

    15 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Opening and Saving Files  ·  Flag idea as inappropriate…  ·  Admin →
  7. Random value generation

    Idea:
    Excel might have a built-in function for generating random values.
    Two 1-dimensional and identical long ranges can include inputs for both the values to be returned and the corresponding weights.
    E.g. ["apple","orange","apricot"] [10,20,30] -> 30/(10+20+30)=50%, 50% is the probability that the returned value is "apricot".

    Rationale:
    -This solution can help to generate datasets with predefined parameters. This can help in teaching, training and modeling activities.
    -The same approach can be applied for generating timestamps with predefined parameters. This could be utilized for data analysis (monthly, weekly, daily seasons, distributions etc.).

    25 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  8. Power Query Time Stamp of last updated Data

    Hi All,

    I import data using Power Query from multiple resources and Lots of time I have seen in Power Query that even though we click on Refresh All still not all tables refreshes the data in Power Query Editor.

    So I am looking for feature of option in Power Query that shows last data import date. So that user easily know if all the resources have been updated or not or when it last refreshed ?

    7 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  9. Expand Pivot Tables without overwriting existing data beneath or to the right of table

    With all the queries on the internet, we assume there is no built-in option to prevent pivot tables from overwriting data beneath the table during refresh and expansion. Is that correct?

    Given that Excel has options for 'inserting' rows, why in the world would Microsoft NOT provide a pivot table expansion/contraction option for inserting or deleting rows from within the refreshed table without overwriting data beneath or to the right of the table?

    It is also interesting that inserting rows into a regular Excel table, using the TAB key in the last row, can add rows by expanding the table…

    12 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  10. 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.

    279 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    8 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  11. Highlite Active row for easier navigation on sheet....

    I work with lots of lines and its tireing to try and track which row im on,
    Please try and Highlight the active row.

    12 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…  ·  Admin →
  12. Ordinal Position Function

    A function which returns ordinal position of one specific element in an array as a number. Alternative name occurrence.

    So for example if the array was like this
    A1 Dave
    A2 Fred
    A3 Jim
    A4 Dave

    Then Ordinal(A1:A4,A1) would return 1 eg the 1st Occurence of Dave
    Ordinal(A1:A4,A2) would return 1 eg the 1st Occurrence of Fred
    Ordinal(A1:A4,A3) would return 1 eg the 1st Occurence of Jim
    Ordinal(A1:A4,A4) would return 2 eg the 2nd Occurrence of Dave

    Function Format something like
    Ordinal(lookup array, lookup cell, optional reverse)
    Lookup array could be vertical with a width of 1 column or horizontal…

    2 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    4 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  13. Give users the ability to put the color back in all the Toolbar icons. The October 2018 white/blue icons are impossible to decipher.

    Give users the ability to put the color back in all the Toolbar icons. The October 2018 white/blue icons are impossible to decipher. Huge step backwards.

    20 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    7 comments  ·  Graphics  ·  Flag idea as inappropriate…  ·  Admin →
  14. Excel would be great if it added the "Change Case" drop down menue from Word to Excel

    By adding Word's "Change Case" options to Excel it would improve Excel's editing abilities and increase customer productivity adding value to the Excel product

    16 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
  15. Add Center Across Selection to the Merge & Center Drop-down

    Do you hate Merged Cells? Do you believe Merged Cells are evil? Do you curse every time your selection rectangle goes from one column to five columns just because you touched a merged cell? Do you constantly get workbooks from co-workers who continue to merge cells? Tired of not being able to Sort or Paste because someone merged a cell?

    Excel encourages people to use Merge & Center by offering it front-and-center on the Home tab. Thus, few people discover the (superior) Center Across Selection option on the Alignment tab of the Format Cells dialog.

    Currently, the Merge & Center…

    459 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    72 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  16. Watermark in Excel workbook

    Idea of insertion/ removal of Watermark in the excel sheet like in word is likely for some creative work

    4 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
  17. Allow column name to be used in vlookup

    Allow the VLOOKUP formula to recognise a column label in place of the column count. This is a sorely lacking functionality when referencing large data sets that can easily extend to column counts of 50 or more.

    Example: =VLOOKUP(A2,F:AM,AM,false) instead of =VLOOKUP(A2,F:AM,34,false)

    16 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    4 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  18. Power Query Active Directory Feature

    Hi All,

    I tried to use Active directory feature of Power Query but still not able to find any solution in any forum to speed up the downloading data.

    I have more than ~300,000 records to import (i.e. Distribution list contains each member list) from Active directory but it takes 12-~14 hrs to import using Power Query.

    Can we look into this feature why there is so much time taken by Power Query and How we optimize the same ?

    6 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  19. Add cell reference to Data Validation Messages (Input Message, Error Alert)

    Please add the ability to use cell references or formulas in the Data Validation Messages (Input Message, Error Alert).
    This would make possible to use variable contents.

    Thanks,
    Fernando Fernandes

    30 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  20. Make the Evaluate Formula dialog box re-sizable

    The evaluate formula box is unusable with large and/or CSE formulas. Please just make it re-sizeable. Thank you.

    38 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?

Feedback and Knowledge Base