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. The F4 function key

    The F4 function key no longer insert the $ to lock in cell locations. Fix it.

    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 →
  2. Allow Excel to create a back-up file exctly as WORD does.

    WORD actually saves a Back-up file to the directory you are using and it creates it every few minutes, or however you decided. EXCEL does not. It says it creates a back-up file but it rarely can be found and when it is found, it is not the most recent version.

    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 →

    Excel does this as well. You can find the location of these backup files (and configure how often they are created) under File > Options > Save. There you will find the “AutoRecover file location” and other related settings.

    Cheers,
    Dan [MS]

  3. 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  ·  Collaboration and Sharing  ·  Flag idea as inappropriate…  ·  Admin →

    Hi,

    To use the same file on multiple computers, we’d suggest storing the file on OneDrive.com. Excel (on any computer, mobile device, or browser) can then access the file.

    To learn more, visit onedrive.com

    Cheers,
    Dan [MS]

  4. SQL query tools integration

    Ability to run SQL queries, being able to select / union select from multiple worksheets

    Using the same SQL tool, updated / insert records in other worksheets ( tabs)

    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 →
  5. Normalize ribbons between office applications

    Ribbons were an OK response to menu creep, but each Office application was optimized separately. Instead they should be optimized for the Office experience, not the Excel or Outlook experience. As an example, there should be one place to find spelling and grammar and it should be the same for every office application. We learn to use office as a whole not individual applications.

    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 →

    In general, common functionality is already on common ribbon tabs in Office. For instance, spelling and grammar are on the Review ribbon tab, across Office.

    Cheers,
    Dan [MS]

  6. Add the capability to add chart labels attached to one or more data points comparable to the third party add-in XY chart labels.

    It would be useful to attached labels to key data points to explain a key system change affecting the data. These labels would need to float with the graph rather than moving an existing text box. The third party add-in XY-labels does a decent job but could be easier to use.

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

    We’ll send you updates on this idea

  7. The replace function has been put into the background where it is harder to locate. Office 2000 was much better.

    Make the replace option much more readily available.(i.e. as a visible option)

    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 →
  8. Ability to open multiple instances of Excel instead of opening just new window in the same instance (enable SDI)

    In Excel 2010 I was able to open a new instance of excel when one instance was busy running VBA macros which take a long time. In this new instance I was able to open other spreadsheets without a problem and work with them while the other instance was busy running VBA macros. Now in excel 2016 if I open a new excel while one of them is running I only get a new windows in the same instance and this window is also busy and I'm not able to open a new spreadsheet to work in while the other…

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

    Hi Borut,

    This is already supported – you can start a new Excel instance (process) by doing the following:

    1. Click Start (or Windows Key+R)
    2. Type “Excel /x” (without quotes)
    3. (or Run)

    That should start up a new instance of Excel. You can use it to open a second file that won’t “block” on already open workbooks.

    Cheers
    ,Dan [MS]

  9. Can't Paste Link with New Excel 2016 Chart Types

    Created Chart with one of new Excel 2016 Chart Types
    Want to Paste Link into Word document
    But Paste Link is grayed out
    Created different Chart with a different one of the new Excel 2016 Chart Types
    Same result - Paste Link is grayed out
    Created different Chart with one of the old Chart Types and Past Link is there

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

    Paste Link is the default for the new chart types in Office 2016 and its the only option right now. As such, the chart pasted into Word should update if the data in the source Excel document is changed. Currently, the new chart types do not support Embedding the entire workbook.

    Thanks,
    Scott [MSFT]

  10. Navigation by using arrows in waterfall chart doesn't work and it rather moves the actual chart

    Navigation by using arrows in waterfall chart doesn't work and it rather moves the actual chart

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

    Navigation of the new chart types is supported but the model has changed. The arrow keys are now used for nudging.

    The new model is the following. When a chart is selected, hit “Enter” to move the selection to the top level parent objects within the chart. Use the “Tab” key to cycle through each of the parent objects. To get to the children of the parent object; e.g. data points in the series, hit the “Enter” key, then continue traversing the child items with the “Tab” key.

    Thanks,
    Scott [MSFT]

  11. Bring back the remove Hyperlink button

    Please bring back the "Remove Hyperlink" button on the right click cell menu.

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

    We’ll send you updates on this idea

    already supported  ·  1 comment  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  12. Kill formulas from calc, reverse of F9

    Kill formula calc; reverse of F9 hotkey and/or toolbar button

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

    We’ll send you updates on this idea

    already supported  ·  0 comments  ·  Performance  ·  Flag idea as inappropriate…  ·  Admin →
  13. Open new excel documents in new windows so that window management actually works

    Opening a document will not create a new window, and navigating multiple excel sheets is a pain. Please add an option to open all new documents as separate windows.

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

    We’ll send you updates on this idea

    already supported  ·  7 comments  ·  Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…  ·  Admin →
  14. There needs to be a "track changes" button like the one on Microsoft word.

    Word has an icon and ability to track changes to your document. This needs to be installed on Excel instead of leaving comments. This makes it easy to work with when sending an excel document to other people.

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

    We’ll send you updates on this idea

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

    There is already a track changes button on the Review tab of the ribbon (enable it by first selecting “share workbook”).

    However, selecting this item does limit the types of changes you can make in your workbook, so you may find that it’s not as useful as you’d like.

    Longer term, we want to build a system that tracks changes made by users via a service so that you can go back to any point in time in a spreadsheet’s life.

    Cheers,
    Dan [MS]

  15. Add a search field in Customize the Ribbon

    It is hard to find commands when you don't know how they are named.

    A search box that filters all commands for a given phrase would be very helpful.

    E.g. when I enter "shape" in that search box I want to see only commands that contains "shape" anywhere in there name.

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

    Hi Andreas,

    This is already supported. In the ribbon, you’ll see a lightbulb icon with the text “Tell me what you want to do.” If you type the command you want to perform there, it will filter all commands (like “Shape”) and show you a list of the relevant ones.

    Hope that helps,
    Dan [MS]

  16. Chart - logrithmic scale

    Please allow for charting using a log scale (not in v2010). Thanks.

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

    We’ll send you updates on this idea

  17. date format is impossible to change

    When typing in a date such as this: "7/15" it is impossible to make this value show up in a new worksheet as 7/15/currentYear in a format I want. It will always show up as "15-jul" or "dd-mmm". Yes, the date will be correct, it will also be correct for the USA, but it's not in a visual format that I like and I have to manually change the cell format because there's no universal way to make this setting.

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

    We’ll send you updates on this idea

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

    Hi,

    This is already supported in Excel today. Right click the cell, select Format Cells > Number tab > Date, and then choose the date format you’d like.

    Hope that helps,
    Dan [MS]

  18. Bring back the ability to design your own button image

    Excel 2003 & prior allowed the user to add a button to their toolbar and then edit/redesign the image thereon by changing the colour of the pixels. However, since XL2007 users are limited to a very poor choice of fixed images that requires an obscure mind to relate them to any macro they create!

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

    We’ll send you updates on this idea

    already supported  ·  4 comments  ·  Flag idea as inappropriate…  ·  Admin →
  19. I teach statistics why can't I have a "Mean" function.

    It would be easier to type and would tie-into Stats language. This is so easy. A function labeled "MEAN".

    2 votes
    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 →
  20. Allow VLookup to accept functions e.g. Max($B$1:$B$10)

    Allow VLookup/HLookup to accept functions e.g. MAX($B$1:$B$10) as the look up value. It currently returns #REF! whether using exact or approximate value.

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

Feedback and Knowledge Base