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. a new hotkey for copy cell values

    we need a hotkey for copy cell values. ctrl+c copies cell. but usually we need to copy the "text" or "number" that stored in the cell.

    1 vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →

    Hi Setan,

    Good news – This is already supported in Excel, but it’s done as part of Paste, rather than as part of Copy.

    1. Select the range you want to copy values from
    2. Ctrl+C
    3. Select where you want to Paste
    4. Ctrl+Alt+V (Paste Special)
    5. Choose “Values”

    The reason we do this is so that you don’t need to make the decision about what you want to paste until you actually do the paste operation, and you can paste several different things with one copy operation (you could paste values and formatting for example).

    Hope that helps,
    Dan [MS]

  2. 1 vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Flag idea as inappropriate…  ·  Admin →

    This is already supported in Excel. All you need to do is put an equal sign before the numbers you want to calculate. So, if you do =15.95/.79, you’ll get the result of that calculation in the cell.

    Hope that helps,
    Dan [MS]

  3. Excel convert signs

    It would be really efficient to have a functionality in Excel to be able to convert the numbers sign (Positive to Negative, Absolute) and also to convert data formatted as 15.15- to -15.15 (That is the sign is on the right where it should be on the left)

    1 vote
    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 →

    Hi,

    This is already supported. To convert signs,

    1. Type -1 in a cell
    2. Copy the cell that contains -1
    3. Select the range you want to convert
    3. On the Ribbon, choose Paste Special (or press Ctrl+Alt+V)
    4. Choose Multiply

    That will convert all numbers in the selected range to the opposite sign.

    Cheers,
    Dan [MS]

  4. 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…)
    Password icon
    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]

  5. 39 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    10 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  6. Add default formatting to File-Options

    Add default formatting to File-Options. I prefer my spreadsheet format to be vertically aligned to TOP, CENTERED and WRAP. I have to adjust this on every new spreadsheet. Add the initial format to File-Options where the user could set it up according to their preferences. Then, we would only have to modify exceptions.

    1 vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  7. 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…)
    Password icon
    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]

  8. desired cells are to be visible in a flooting window over excel sheet to monitor changes during modifying the data entered

    while modifying / entering data, related cells values will be changed at bottom/top/righ/left of the table and desired cell values required to be monitor by scrolling top/bottom/left/righ. for easy facilitate arrange desired cells in flooting window over excel sheet to observe the changes while modifying / entering data.

    1 vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    Hi,

    This functionality is already supported in Excel through something called the “Watch Window.” To use it:

    1. On the Formulas ribbon, click “Watch Window”
    2. Click the “Add Watch” button
    3. Select the cell you want to watch the value of
    (repeat 2 and 3 if you’d like)

    Now, whenever cells you are watching change values, you’ll see those updated values in the Watch Window.

    Cheers,
    Dan [MS]

  9. Please add bold formula for some word in cell

    when I type a sentence in a cell, I need one or several words in the sentence to bold because the word is important. I wish there was a formula to thicken the word that until now I have not found in the set of formulas excel.

    1 vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    If you are typing a sentence in a cell (that is, you have the actual text in the cell), you can select any word(s)/character(s) in that text and press the [B] button on the ribbon (or use Ctrl+B) to make that selection Bold (or apply other formatting).

    Cheers,
    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…)
    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 →

    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. 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…)
    Password icon
    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]

  12. 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…)
    Password icon
    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]

  13. 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…)
    Password icon
    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.

  14. 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…)
    Password icon
    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]

  15. 1 vote
    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 →
  16. 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…)
    Password icon
    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]

  17. Make subscription versions of Office 365 work (make new features available) even when I'm not connected to the internet / am offline.

    In the past Office worked independently of the Internet. Now I'm forced to have an Internet connection to get anything done. I pay my annual fee and should be able to use all Office Products when offline.

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

    We’ll send you updates on this idea

    1 comment  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →

    Hi all,

    This isn’t an Excel specific issue (so there’s nothing we can do in Excel to change this), but I’ll try to give a bit of info here to be helpful.

    With Office 365, you don’t need to be connected to the internet at all times in order to use the “new” (subscription) functionality that is part of the monthly/annual fee. Office licensing has a “heartbeat” that checks your license and then caches that information locally for the times when you’re offline. That cache lasts for about a month – so as long as you connect to the internet monthly, you shouldn’t run into a problem where features aren’t working.

    That may not solve everyone’s problem (I realize there are some people with no internet connection at all, and a non-subscription version of Office may be better in those situations), but hopefully it helps a bit.

    Cheers,
    Dan [MS]

  18. 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…)
    Password icon
    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]

  19. 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…)
    Password icon
    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]

  20. 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…)
    Password icon
    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]

  • Don't see your idea?

Feedback and Knowledge Base