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. Please provide a delete special option which enables users to delete only the formats,values,formula or validation.

    Just like the paste special option which enables users to paste the values formula or formats, A delete option for all individual aspects will be really helpful.For example:-If a user just wants to delete a value but not the formula he has to delete the whole thing and retype it again.So this feature can enable them to delete only the aspect they want

    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 →

    Hi Praveen,

    This functionality already exists in Excel (but a bit hidden). To take advantage of it, you can:

    1. Select the range you want to delete an aspect of
    2. On the Home Ribbon > in the Editing chunk (right side of the ribbon) > Clear drop down, choose what it is that you want to clear.

    Hope that helps,
    Dan [MS]

  2. Please return "Ctrl+{" or "Ctrl+[" to follow link (ref to precedent cell) used in formula!!!!!!

    I'm a financial analyst and it's very hard to check big financial models with a lot of formulas and spend time of arrows.

    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,

    Ctrl+{a and Ctrl+[ should still work to follow dependencies (I just tried in the most recent version of Excel 2016).

    Can you let me know what version of Excel you’re using where the behavior isn’t working anymore?

    Cheers,
    Dan [MS]

  3. Allow me to format with "" and insert /n

    Can you allow me to format text with "" Example "John Doe" Also, can you create button that inserts a \n where I need 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  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →

    Hi George,

    You can already format text with quotes (but maybe I’m misunderstanding what type of formatting you’d like to see – please clarify).

    For inserting a new line, you can press Alt+Enter

    Cheers,
    Dan [MS]

  4. paste as text

    excel is missing one important function: PASTE AS TEXT...

    for various reasons pasting with excel intelligent guessing the type of data in the pasted cells do not work well, although there is no error in that (doing unexpected conversions of pasted data)...

    what I need is the functionality to say to excel: paste all data as text into appropriate cells (and I will later edit it and correct and convert data)

    also, convert-text-to-columns should have that functionality... yes, I am aware that I can use that functionality at the column level, but I would also like to be able to…

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

    This is already supported, if I understand what you’re looking for. Look for Paste Special > Values (if you copied from Excel) or Paste as Text (if you copied from another app).

    Cheers,
    Dan [MS]

  5. Grouping/Outlining [-] Button should be at the top (or both bottom and top)

    Currently, when you group rows using the grouping and outlining feature, the [-] toggle for the group shows up only at the last row of the group. This means that after you click on the [+] button, the [-] doesn't replace the [+] button but shows up at the bottom of the list. This requires the user to scroll down to find the bottom row of the group and click on [-]. And then scroll back up to find the top row again.

    When quickly expanding and contracting groups, it would require a lot less mouse movement and scrolling if…

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

    We’ll send you updates on this idea

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

    This is already doable using the outlining options. Additionally – you can click anywhere on the outlining line to expand/collapse.

    Cheers,
    Dan [MS]

  6. Standard Customized Charts

    I am currently using Office 2010, I would love to have the possibility to create, for example, my personal line chart, with the dimension, layout, axes formats and so on stuff already standardized.
    Something like a "Browse for template" but for charts :)

    Cheers!

    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 →

    You can already create a “chart template format” and apply that to charts that you create in the future. To do it, follow these steps (from Excel 2016, but I think the 2010 steps are the same/similar):

    1. Create the chart you want (all the series, etc.)
    2. Format the chart the way you want it formatted (colors, font sizes, etc.)
    3. Right click on the chart and choose “Save as Template…” in the context menu. Save the crtx file in the suggested location.

    4. Now, create a new chart, give it all the data you want, but don’t worry about formatting anything.
    5. Select the chart and on the Chart Tools > Design Ribbon, choose Change Chart Type
    6. In the Change Chart Type dialog, select the “All Charts” tab at the top
    7. In the list of chart types on the left, choose “Templates”

    Now, you’ll see the…

  7. Circular Errors

    I had to look all over the worksheet headers to find an option that would show the cell being questioned. You get this error when you are about to save and leave a worksheet. I do not usually have time to go hunting for it at that point. Need a quicker way to identify the specific problem cell.

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

    Hi,

    This is already supported in Excel.

    Go to the Formulas tab, Error Checking, Circular References. You’ll get a list of cells involved in circular references.

    Cheers,
    Dan [MS]

  8. You could bring back the pathway on the tool bar to creat new work books. YOU TOOK THAT OFF AND IT MAKES IT VERY DIFFICULT.

    wE WERE ABLE TO CLIK ONTO NEW WORK ON LEFT SIDE OF TOOL BAR AND IT COPIED AND MADE NEW WORK BOOK INSTANTLY

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

    We’ll send you updates on this idea

    2 comments  ·  Application Errors  ·  Flag idea as inappropriate…  ·  Admin →

    Hi,

    This is already supported by customizing the QAT and adding the “Document Location” control to it.

    To do that:
    1. File > Options > Quick Access Toolbar
    2. In “Choose commands from” select “All commands”
    3. Find the “Document Location” command and add it to the QAT by clicking the “Add >>” button.

    Hope that helps,
    Dan [MS]

  9. When saving a new file or using "Save as", list all the file names in the folder that is selected, not just files that Excel knows.

    I often create related files for the same topic. For example, I may create a word document and then want to create a related Excel file that contains related data, and I want to give both the same name. I would like to see this capability in all the Office products. These products used to work this way.

    3 votes
    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 →
  10. Use Office standard of Ctr+Shift+C/V to cut & paste cell style

    Many Office apps allow you to select text style with a Ctrl+Shift+C, and paste it with Ctrl+Shift+V. Implementing this in Excel for the Format Painter would eliminate a relatively slow mouse-heavy operation.

    3 votes
    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 →

    Excel already supports this. Simply Ctrl+C to copy the format you want, and then Ctrl+Alt+V, T to paste formatting. (That’s Past Special > Formats)

    Cheers,
    Dan [MS]

  11. Create short cut for creating dynamic Charts in excel 2016

    Create short cut for creating dynamic Charts in excel 2016.
    The current process is long and not comfortable. in my opinion an easy way will make it a must.

    This is how you do it in the old way http://www.criticaltosuccess.com/dynamic-charts-in-excel-resize-with-offset-function-named-ranges/

    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 →

    This has been supported for the last several versions of Excel if you use a Table as your data source for the chart.

    Thanks,
    Scott [MSFT]

  12. Make Excel window grabbing (and moving) painless

    I just upgraded from Excel 2007 to 2016 on Win10. I am amazed how the user interface has degraded. I just spent about 5 minutes trying to grab the Excel window I'd moved to the top of my monitor's screen (so that workbook was visible while I was in another application) and I couldn't do it! At ALL!! I had to close it down from the bottom menu bar! MAJOR FAILURE! There's so much garbage up on the top that you've literally sacrificed usability for mostly useless abilities. Keeping the ability to "link" while dumping the ability to move the…

    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 →

    Moving Excel using the top (green by default) bar is already supported, and works the same as it has in previous versions. If you can link to a video that shows the problem you’re having, we’ll be more than happy to take a look.

    Cheers,
    Dan [MS]

  13. Columns

    At the moment the worksheet columns only have the corresponding letter at the top. If it were to somehow have the corresponding number equivalent many VB users would appreciate it.
    How it could work - while mouse is hovering over the Letter "Z" would display a "26" and so on.

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

    We’ll send you updates on this idea

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

    Hi,

    This is already possible, using R1C1-style references. To enable them,

    1. Go to File > Options > Formulas.
    2. Under “Working with formulas”, check the “R1C1 reference style” check box

    Hope that helps,
    Dan [MS]

  14. Move command - the ability to select a row or column and insert it automitacally. If anyone remembers Visacalc or SuperCalc, they had this

    Move command - the ability to select a row or column and insert it automitacaly. If anyone remembers Visacalc or SuperCalc, they had this

    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 →

    It is already supported to cut > paste, or drag-to-move a range of cells within a spreadhsheet.

    Maybe a bit more detail would let us know if this is a new idea that you have!

    Cheers,
    Dan [MS]

  15. Functionality

    Making this version as functional as previous versions. Can't use arrows keys to navigate between cells. Keyboard functionality is non-existent. I've gotta stop what I'm doing to use the mouse to navigate anywhere but to the cell below. WORTHLESS!! A VERY DISAPPOINTED USER!!! (Excel has always been my fav program. I even do my lesson plans in it rather than a word processor.)

    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 →

    Excel 2016 allows the various keyboard functionality that you’ve mentioned. Please add more detail if there are items that you’re still running into.

    Cheers,
    Dan [MS]

  16. 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 →
  17. 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  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →

    As long as you’re using functionality that exists in previous versions, macros should be backward compatible.

    If you have a specific problem, please feel free to post it on UserVoice or on answers.microsoft.com.

    Cheers,
    Dan [MS]

  18. 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  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  19. Windows 10 does not allow me to place the commas on accounting values where i want to sometimes

    I must always be able to format giving me the commas after three places in accounting and currency format

    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 use a custom number format to place the comma, if the built-in ones don’t work for you. If you’re having trouble even with custom formats, please upload a copy of the file that shows this issue, or list out the specific steps that reproduce the issue, so we can look into it.

    cheers,
    Dan [MS]

  20. 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 →
  • Don't see your idea?

Feedback and Knowledge Base