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. Allow Relative References in Conditional Formatting Formulas

    The ability to use formulas in conditional formatting is a great feature.
    Unfortunately only absolute cell references are permitted in the formulas, and not relative cell references.
    For example, I often want to apply red/yellow/green conditional formatting based on the value of an adjacent cell.
    For example the formula >=2*$A$1 can be used with green formatting to highlight cells with values that are twice the value of cell A1.
    What I want is the ability to use a reference like >=2*A$1 which will compare to the first cell of each column (A1, B1, C1, etc), rather than comparing everything to…

    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 →

    Hi,

    This is already supported.

    To make a conditional format relative, define it on a single cell, using the relative formula that you’d like it to use (like the one in your idea, if you want it to adjust across columns).

    This will format the cell on which the conditional format is applied.

    Then, in the “Applies To” range in the Conditional Formatting Manager, change the range from that original cell, to the range on which you’d like the CF applied.

    That will adjust (according to the referencing you’ve specified) the conditional formatting rule for each of the cells in that range.

    Cheers,
    Dan [MS]

  2. 1 vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    4 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →

    This is already supported in Excel 2010 and later when using PivotTables based on data from Analysis Services (or other write-back enabled OLAP providers).

    Cheers,
    Dan [MS]

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

    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]

  4. Smart Selecting

    Excel needs to have a smart select feature. Select All (CTRL-A) should only select rows/columns that have data instead of the entire sheet (through column ZZ?)

    An example of a tasks I am doing. I have say 14 columns of data with 300 rows. I want to be able to select all of those columns and rows to convert them to a table. Select-A would be ideal; however, doing so, selects the entire sheet which therefore converts the entire sheet entire a table (takes a long time to do so). This process warns the individual prior to but would be…

    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 →

    This is already supported if selection is in a range of data (within the larger sheet). Ctrl+A will select the continuous range of data the first time you press it, and then if you press it again, it will select the entire sheet.

    Cheers,
    Dan [MS]

  5. 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 →
  6. Time not as Time of day

    Excel has plenty of number formats and time functions, however there is no way to have times (for athletes tracking times etc.) with longer decimals in the seconds position. I want to have cells formatted as hh:mm:ss.### given that "#" is a number representing the partial seconds after the decimal. Clearly I can use the apostrophe to input these times as text, but then I cannot use functions to find how much time has passed. Excel needs to have more time formats that do not necessarily correspond with the time of day, and that allow for fractional seconds beyond one…

    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 →

    Excel already supports showing fractional seconds. To get them, you can use the following number format:

    hh:mm:ss.000

    (you can also omit the hh:mm if you just want seconds)

    Hope that helps,
    Dan [MS]

  7. Pivot table refresh - any way to keep it from re-sizing the width of columns??

    I always have to resize the columns after refreshing.
    I have some instances where i have to refresh after changing input and i have 2 grids below the pivot and any time i refresh it messes up the column widths so i have to keep resizing. It is annoying. Add a way to lock the column width so this wont happen every time i refresh.

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

    Hi,

    This is already supported. After you initially create the PivotTable, you can do the following:

    1. right click on the PivotTable and choose PivotTable Options…
    2. On the Layout & Format tab, make sure that “Autofit column widths on update” is unchecked.

    In the future, The best place to ask this question is the Excel area of answers.microsoft.com – specifically the Windows Excel Desktop area ( http://answers.microsoft.com/en-us/office/forum/office_2016-excel-os_device_win10desk?sort=lastreplydate&dir=desc&tab=threads&status=all&mod=&modAge=&advFil=&postedAfter=&postedBefore=&threadType=all&tm=1456878400400&auth=1 )

    We’ve got folks over there who can help with questions like this, and we’re trying to keep the UserVoice site for new product ideas.

    Hope that helps,

    Dan [MS]

  8. Filter Boxed Colored when Active

    When you have a filter box active, can the box be coloured so it is easier to see which columns have filters on them that are active and which are not?

    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  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →

    Hi Ben,

    I think the idea you’re asking for is already supported (slightly differently than your suggestion) in current versions of Excel 2016 (or O365).

    When you filter an AutoFilter, Table, or PivotTable in current versions, the filter box (we call it the ‘Filter Drop down’) will show both the down arrow, as well as a filter icon in it. You can then look to see what columns have that filter icon in them to know what’s being filtered.

    Let me know if you were thinking of something else, or if you’re not seeing that behavior.

    Cheers,
    Dan [MS]

    PS – in previous versions of Excel, when a filter was applied, the down arrow in the Filter Drop Down would change from black to blue (which we thought was a bit too subtle, so we added the additional icon.

  9. 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]

  10. CTRL F shortcut in excel 2016 has been removed. Please can this shortcut be brought back.

    CTRL F shortcut in excel 2016 has been removed. Please can this shortcut be brought back.

    1 vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    Hi,

    Ctrl+F (Find) still exists in current buidls of Excel 2016. If you’re experiencing issues with it, please post the version of Excel (found under File > Office Account) you are using.

    Thanks,
    Dan [MS]

  11. 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]

  12. 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]

  13. 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…

  14. 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
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

  15. Excel as default for .tsv files.

    I used to be able to set Excel as the defaul application for opening .tsv files (which is the default format for exporting some of our finance files from other apps). Now I have to save as a WordPad file, and then open that file and copy/paste into Excel in order to get the data into columns for sums, etc. This is a huge waste of time when it can be done automatically. Please bring back this capability.

    1 vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    This is not Excel functionality, but rather Windows, and is doable already. To associate .TSV files with Excel, do the following:

    1. Find a TSV file on your computer.
    2. Right click on the TSV file and select “Open with…” (and if a menu appears, select “choose and app”)
    3. Check the box to “Always use this app to open .tsv files”
    4. Select Excel in the list of apps at the top of the dialog, or browse for Excel if it’s not listed there.
    5. Click OK.

    That should do it for you. In the future, answers.microsoft.com is a better place for questions like this.

    Cheers,
    Dan [MS]

  16. 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
    Sign in
    (thinking…)
    Sign in with: facebook google
    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]

  17. Allow users to disable date grouping in PivotTables

    Please make functionality "improvements" with the ability to choose when to use them. Excel now "auto-groups" certain data in pivot tables. I don't need or want this most of the time, but I can't turn it off. Now I'm in a bind where I need to process several reports and have to figure out how to work with this new forced "enhancement"

    1 vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    Hi Nicole,

    Good news – this is already supported in Excel. To turn off Date Grouping in PivotTables, go to File > Options > Advanced, scroll down to the “Data” section, and toggle the “Disable automatic grouping of Date/Time columns in PivotTables.”

    Cheers,
    Dan [MS]

  18. 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]

  19. 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]

  20. 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]

  • Don't see your idea?

Feedback and Knowledge Base