Feedback by UserVoice

Excel for Windows (Desktop Application)

Update: Microsoft will be moving away from UserVoice sites on a product-by-product basis throughout the 2021 calendar year. We will leverage 1st party solutions for customer feedback. Learn more

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. under data toolbar, data type is not there.

    data type such as stock , option is not there, kindly add it.

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    Thank you, we really appreciate you taking the time to write up this piece of feedback.

    In order to access data types that link to external sources of data such as Bing, Wolfram Alpha, and more, you must meet these requirements:
    - Have an active Microsoft 365 subscription
    - Have the English editing language added to Office Language Preferences.

    Thank you,
    The Excel Team

  2. Default the Power Query formula bar as on

    In the Power Query editor window the formula bar is defaulted as off. This is the first thing I tell people to turn on as it’s key to avoiding unintended errors and future proofing your code.

    As Gil Raviv says in his book, “ Enabling the formula bar is fundamental to avoid the pitfalls”

    64 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    6 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  3. Rich Data Types - Extract Text

    Currently, Rich Data Types can be used in formulae to extract derived data (e.g.: for a Geography data type of a city, say "Seattle", in cell A2, you can use "=A2.[Country/region]" to get a text value of "United States". However, I cannot seem to extract the value itself ("Seattle") into a text string in another cell.

    I suggest this because Rich Data Types cannot be imported into Power Query, which while an issue in and of itself, wouldn't be so bad if I could extract the string into another field and import that instead. Alas, I can do neither.

    Could…

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  4. 'Film, TV and Music' 'Data Type'

    I'm not sure if this would be a common use case but I keep a tracking list of the T.V series' and Movies I watch in excel.

    I use it to track the seasons that have been released, which seasons I've watched, when the next season is due, etc.

    A lot of the fields are taken directly from wikipedia or some other website if wikipedia doesn't contain it (rarely the case).

    It would be amazing if I could select these titles as a data type and have all the fields available to me the same way the fields are available…

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    Thank you for your feedback! Movie and Music are two new data types coming from the partnership with Wolfram Alpha (https://support.microsoft.com/en-us/office/what-linked-data-types-are-available-in-excel-6510ab58-52f6-4368-ba0f-6a76c0190772).
    Please note that data types from Wolfram Alpha are gradually being rolled out to subscribers. If you want to use them now, you must be in the Beta channel on the Insiders Program.

  5. Add currency data type to the new Data Types

    Add Currencies to the new Data Types along with Stocks and Geography so we can get current exchange rates, symbols, etc. for various currencies.

    8 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →

    Hello, thank you for your feedback. We currently support currency rates through the Stock data type. Try converting cells that contain currency rates such as “USD/EUR” to a Stock data type (Ribbon > Data tab > Data types gallery > Stock) to obtain information like price, change, and more.

    Thanks!
    Elisabetta C.

  6. Option to get old text data import wizard

    The new data import editor has some major flaws:

    First, it takes 100 times longer to import some simple 500 rows of data
    Second, the date format selection for columns (e.g. I want to convert MM/DD/YYYY format to DD.MM.YYYY)

    I understand that the new import editor has some advantages but I do not need any of the new functions it has. The old text data import wizard could do everything I needed it do do.

    38 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    41 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  7. Warn users when they will lose formatting saving to CSV

    I know a lot of people hated the warning when saving a workbook as CSV. Now that the warning has been removed, if you open a CSV file, make formatting changes and save the file - the formatting is lost with no warning at all.

    34 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    32 comments  ·  Opening and Saving Files  ·  Flag idea as inappropriate…  ·  Admin →

    As mentioned in one of the comments, you can get a warning when working with CSV files. Just go to Excel Options > Save > under the Save Workbooks section, enable the option to “Show data loss warning when editing comma delimited files”.

    Thanks – Steve [Microsoft Excel]

  8. Power Pivot allow drill down to more than 1000 rows

    Double clicking on a value in Power Pivot creates an extract limited to 1,000 rows.

    Would be great to expand this to 100,000 +

    13 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    14 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  9. spell check

    As ms word is having spell check function, i suggest you to add the same to MS Excel

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  10. 39 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    9 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  11. Allow more than 1 instance in Excel 2016

    Can you please bring back the ability to open more than 1 instance of Excel? Currently when I have a macro running, I am unable to utilize Excel because of this new setup. In the older versions of Excel, it was nice to be able to choose how many instances you wanted to open.

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    4 comments  ·  Opening and Saving Files  ·  Flag idea as inappropriate…  ·  Admin →

    Hi,

    This is already supported. To start a new Excel instance, press Windows+R (Run), then type “Excel /x” without quotes.

    You’ll get a new process that will be isolated from other Excel instances.

    Cheers,
    Dan [MS]

  12. Be able to turn off auto-conversion of fractions and words into dates

    When I import data in the format of a fraction #/#, excel automatically converts this into a date. This is unnecessary and should not be a default operation. At least, there should be a simple way to undo this.

    I work with biological data, and there are gene names like "Oct1", and these get converted into dates, causing errors in data analysis.

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    4 comments  ·  Data Import  ·  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 → ’Oct1, 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]

  13. Center Wrapped Text Without Left Offset that Occurs Now

    When you Wrap Text in a cell in excel and center, the text is distinctly further to the left whether or not there is any wrapping occurring, not centered as it would be if you manually spit the text into two cells and used the built-in centering.

    Make wrapped text center without the offset.

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    This is already supported.

    After you wrap text in a cell, click on the “Align Center” button, and the text will align in the middle of the cell

    Cheers,
    Dan [MS]

  14. need new workbook copy protection

    We need a higher level of workbook and worksheet protection perhaps set to the user ids own computer and allowed devices. This way excel documents with hidden formulas, code etc can be shared to people outside that network without worrying about special details (secrets) getting into the wrong hands. Currently workbook passwords can be unlocked with code, etc.

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  Opening and Saving Files  ·  Flag idea as inappropriate…  ·  Admin →

    Hi,

    There are two ways to get strong encryption and protection of Excel files:

    1. DRM (Click on File > Info > Protect Workbook > Restrict Access) can be used to only allow certain users to access a file.

    2. Workbook Protection (Click on File > Info > Protect Workbook > Encrypt with Password) can be used to encrypt a file. When set, only users with the password can open the file to see the contents.

    Cheers,
    Dan [MS]

  15. colour cells

    Be able to calculate the occurrences of cells with coloured background.

    2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →

    Hi Amy,

    This is already possible in Excel today.

    1. Press Ctrl+F to open the find dialog.
    2. Click “Advanced”
    3. Click on the “Format” button and select the format (cell colour) you want to count
    4. Click Find All

    The find dialog will list the count of occurrences of that formatting that you selected.

    Cheers,
    Dan [MS]

  16. I think the default way to format a time should be HH:MM:SS.000

    Currently the default time format is MM:SS.0 which I don't find helpful because I don't know which hour the time is from. Alternatively we should able to set a default time format for Excel

    3 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    The default time format is taken from your system time format. In US English, it is h:mm:ss AM/PM

    (actually it is [$-x-systime]h:mm:ss AM/PM)

    Cheers,
    Dan [MS]

  17. Ctrl+Tab to switch between worksheets

    Just as we use Alt+Tab to switch between two workbooks, let Ctrl+Tab switch between two worksheets in a workbook.

    65 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    already supported  ·  34 comments  ·  Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…  ·  Admin →
  18. Ability to both freeze colums AND rows at the same time

    Ability to both freeze colums AND rows at the same time would be fantastic. Also, not just the top row or first colum, I want to be able to choose from where the freeze panes starts.

    When scrolling down, the frozen colums can roll up. But when sliding sideways, the colum remains put and the frozen rows slide along. Can't be that hard, to do?

    2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    5 comments  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →

    Hi Shanna,

    This is already supported. To freeze both rows and columns in Excel 2016, do the following:

    1. Put your cell selection in the cell below the row you want “frozen” and to the right of the last column you want “frozen” (said another way – put it in the first cell that you want to be able to scroll either direction – C5 for instance)
    2. On the View Ribbon, choose Freeze Panes > Freeze Panes.

    That should do it.

    Cheers,
    Dan [MS]

  19. Bring back the Split Box

    You used to have a split box above/to the side of the scroll bars. This went in 2013 for some reason - there was no justification:
    https://support.office.com/en-us/article/Discontinued-features-and-changed-functionality-in-Excel-2013-c417e377-26c6-4f43-be6d-16718dd75ffa#__toc342560933

    Please can we have this back?

    9 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    While the split control is no longer above the scroll bars, it is still available in Excel. To add it to your Ribbon or QAT, you can:

    1. Start Excel
    2. File > Options > Customize (QAT or Ribbon)
    3. Choose commands from “All Commands”
    4. Find the “Split Window” command
    5. Add it to your QAT (or to the ribbon).

    Hope that helps!

    Dan [MS]

  20. Add calculation options to grand totals

    It'd be great if we can have multiple calculation options to the grand total for rows and columns. In other words, get grand totals to show not just the sum but also give the ability to count, average...etc

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →

    Hi John,

    Kenneth beat me to it, but this is already possible today with Excel – the Grand Total will show whatever aggregation you’re using for the column. To change that,

    1. In the PivotTable Fields pane, click on one of your fields in the Values section.
    2. Choose Value Field Settings.
    3. In the scrollable list that appears, choose a calculation type other than Sum.

    Hope that helps,
    Dan [MS]

← Previous 1 3 4 5 6
  • Don't see your idea?

Feedback and Knowledge Base