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. vlookup till

    VLOOKUP( ,,,0) - Exact match
    VLOOKUP( ,,,1) - Approximate by excess
    PROPOSE => VLOOKUP( ,,,-1) - TILL - Approximate by default

    Example: if the values are till 100 then 0% discount, if the values are till 500 then 1% discount if the values are till 900 then, 10% discount and if the values are till 1100, then 15% is discount?

    2 votes
    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. 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  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  3. Equally colored semi-colon as parentheses when editing nested functions

    If the semi-colons are equally colored as the parentheses when editing nested functions it become more readable during editing or debugging.

    Other suggestions would be highlighting the function you are editing in the nest or show it in bold.

    Please feel free to share your thoughts below if you have other suggestions regarding more readability of nested functions.

    Cheers!

    2 votes
    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 →
  4. COUNTIFS / SUMIFS with OR - COUNTOR, SUMOR

    Countifs or Sumifs function use all criteria as AND. Instead 2 more formula can be added such that all criteria are treated as OR. Suggested Names of Formula are
    COUNTOR, SUMOR

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

    We’ll send you updates on this idea

    3 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  5. I would like to be able to "Flash" data or background color to draw attention to a cell if a certain condition is met.

    I would like to be able to "Flash" data or background color to draw attention to a cell if a certain condition is met.

    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 →
  6. 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 →
  7. Show ALL links in 'Edit links' window

    1) It'd be practical, if ALL external data references are shown in the 'data' tab of the ribbon.

    Currently, if a pivot table uses external data, this is not showing up here, but only in the 'data' section of the 'PivotTable Analyze' tab of the ribbon.

    2) Side note: overall consistency.

    This is probably asking a lot, but I don't understand why the 'edit links' button is greyed out when there are no external links (not counting those to pivot tables), but the 'queries & connections' button is not greyed out when there are no queries or connections used. Wouldn't…

    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 →
  8. Value.timestampMs.2

    1531785519996 is the tmestamp i'm trying to convert into actual date and time

    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 →
  9. 'Automatic" IF before other functions

    In order to produce the best-looking spread sheets, almost all my formulas start off with "=IF(Controlcell="","",do whatever).. This ensures that if there is no data in the Controlcell, then the target cell remains blank. Is it possible that a cell/column/row setting such as "cell(s) with numeric zero contents are left blank"? It won't make much difference to performance either way, but it sure will increase the convenience factor.

    The attached file, which I created specially simply as an example for this submission, shows what I have to do: the top half is plain and the bottom half with all the…

    2 votes
    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 →
  10. Excel should create "if" "then" statement that involves vlookup.

    Excel should create "if" "then" statement that involves vlookup.

    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 →
  11. Allow the use Structured References in Textbox

    Enable Excel to link Text Boxes (Textboxes) to table values using Structured Table References.
    Currently, linking the textbox to a defined name that contains a structured table reference results in a "Reference isn't valid" message.

    Attempting to link the textbox directly to a structured reference results in an error stating "This formula is missing a range reference or a defined name"

    To reproduce this behavior:
    Set up RangeName: PC01_ID
    RangeName Formula: =Table_Progress_Chart_01[[#Totals],[Slice 2]]

    Try linking a text box to: =PC01_ID

    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 →
  12. Function box layout

    The way the functions are displayed in Excel for Windows is really easy to navigate by topics. Excel for Mac you have to scroll and cannot filter the functions by functionality.
    Can you make it available, similar to what we have for Windows?

    Thanks!

    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 →
  13. For stock data, in addition to PE,it would VERY useful to have also others metrics such as P/B, P/S, P/FCF, etc. (for industry + company)

    For stock data, in addition to PE, it would VERY useful to have also others metrics such as P/B, P/S, P/FCF, etc. (for both the company and its sector and or peers)

    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 →
  14. Excel/Outlook Hyperlink

    Is it possible to create a hyperlink in Excel which, when clicked, opens up a new email in Outlook with a default message already typed up? I know you can have a create a hyperlink which opens a new email with just the email address and subject listed, but I was hoping to have an message populate with Outlook when the hyperlink in Excel is clicked. Thanks!

    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  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  15. Your "Amortization" template in Excel contains a small error.

    The total of the principal (column H) paid back is less that the amount of the original loan (cell E3) since the final interest portion owning with the final payment ((I36) is deducted from the outstanding balance rather than being added to it to determine the final payment. Small difference but needs to be corrected.

    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 →
  16. Toggle Relative/Absolute for Structured References

    When referencing a table column, it's cumbersome to add the additional square brackets and repeat the column name to make the reference absolute.

    It'd be great if the F4 shortcut could also work in this, so toggling
    tablename[ColName] --> tablename[[ColName]:[ColName]] --> tablename[ColName], or, when referencing the same row from within the table,
    @[ColName] --> [@[ColName]:[ColName]] --> @[ColName]

    Many thanks,

    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 →
  17. SUM COLOR SPECIFIC CELL

    SUM COLOR SPECIFIC CELL AT ANY TABLE AND SELECT ANY COLOR DO YOU WANT SUM IT OR COUNT IT MERGE SPECIFIC COLOR I WANT AND MAKE IT WITH ADDINS BUT WE WANT IT FX

    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  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  18. Protect Formulas on sheet and workbook

    I create a tables with reference to another sheets for others to use. I use formulas and would like to protect only cells with formulas, leaving everything else available unlock. Currently, if i use function to "protect" selected cell, my table gets lock and not growing with addition of a new line at the bottom. It would be VERY nice if i can protect all cells that contain formulas and protect it with one password. Thank you for listening.

    2 votes
    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 →
  19. creare una formula nuova

    creare una formula o una funzione che permetta di bloccare il valore di risposta quando avviene la corrispondenza tra una casella con un collegamento DDE e una casella con un valore fisso.

    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 →
  20. Consolidate error with Linking

    When you use LINK, the SUM function adds hidden rows and gives an incorrect total.

    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