Feedback by UserVoice

AdamV

My feedback

  1. 267 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    We’ve just merged two items that were both requests for the Median function in PivotTables. One had been for Windows, the other for Mac. When we get to this, we should actually make the addition on all platforms including Windows, Mac, Web, and others.

    AdamV supported this idea  · 
  2. 635 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    AdamV supported this idea  · 
  3. 858 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    This is a great suggestion, and we want to keep the interest going. Thanks to everyone who has already voted and commented on the suggestion to have an option for the default paste behavior in Excel.

    Sorry that we’ve been slow to comment and update the status on this one.

    Steve K [Excel]

    AdamV supported this idea  · 
  4. 832 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thanks for your support for this suggestion. As some of the comments have concluded, there are a few complex technical issues and considerations that have delayed this from being implemented.

    We do think that this suggestion has merit but we don’t think that we’ll be able to devote time to it in the near future.

    One of the primary reasons for this request was to have a better way to handle formula cells in line charts, and this can be accomplished using the option to show #N/A as an empty cell. You can use the NA() function in your formulas as appropriate, and choose the option to “Show cells with #N/A as an empty cell”. To find the option for your chart, go to the Select Data dialog for the chart, and click the Hidden and Empty Cells button.

    We know there are other scenarios where a proper NULL()…

    AdamV supported this idea  · 
  5. 884 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    AdamV supported this idea  · 
  6. 1,203 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thank you for taking the time to share your request for linking min/max values of a chart axis to the cell value! We think this suggestion has merit; however, we don’t expect to devote time to it in the near future. We will continue tracking votes and comments here, and will keep this suggestion under consideration for future development.

    Thank you again, and please keep sharing your thoughts!
    Auston [MSFT]

    AdamV supported this idea  · 
  7. 1,513 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thanks for logging this great suggestion, Zack, and to others for voting it up. We’ll prioritize this according to the number of votes, so if there’s more interest, please make sure to register your vote!

    Thanks

    Ashvini Sharma
    Lead Program Manager
    Excel

    AdamV supported this idea  · 
  8. 3 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    AdamV supported this idea  · 
  9. 5 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    AdamV commented  · 

    Annoyingly that clears the sort order too. If I have a multi-level sort set up I might want to change it slightly, but to have to start all over again is annoying.

    AdamV supported this idea  · 
  10. 144 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    AdamV commented  · 

    I also agree with Jan Karel that the dialog box should ask for a table name (but can default to Table1 etc just like PivotTables do).
    Also, why not ask if my data already has a total row? (not as common as headers, but still useful to ask at this point).

    An error occurred while saving the comment
    AdamV commented  · 

    No thanks. I have lots of data I export from a particular system which comes without headers (and the import process also does not require them as the format is fixed).
    When I convert to a table it is very useful for it to see that I have no headers, and insert a row for me to put names into. Depending on what I am doing I sometimes don't need to rename them, I might just want convenient filters, or quick formulas that are copied down for me. I don't want to lose my first row of data by mistaken assumptions that it is a header.

    This is more about understanding the existing criteria by which Excel "guesses" if you have a header or not. Some comments suggest using some basic heuristics, which Excel already does.
    Some examples which recognise headers:
    Top row is bold, italic or underlined* ("BIU" hereafter) and at least one other row is not (you can even have lots of bold or italic, even the majority, and headers are assumed, but not if all data is formatted the same)
    Actually, one cell of the top row is BIU, but not the whole of that column is enough - so if just the top left cell of all your data is bold, Excel assumes headers.
    Actually, pretty much any cell with formatting which does not match everything else will trigger headers. Number formats, cell colour, font name, size or colour all trigger it. (Borders have a special case). One cell anywhere which is red, or in currency format, will trigger headers.
    Top row of a column contains text, at least one other cell in that column contains a number or date (very common).
    Top row of a column contains a number, at least one other cell in that column has text or a date.
    These last two seem to work regardless of number formatting, so if everything is "General" it's fine. If everything is "Text" it works too (ie even if the numbers are formatted as text)

    Borders are very specific:
    If the top left cell (R1C1) has a bottom border, or the one below that (R2C1) has a top border (same thing), or (weirdly) if R2C1 has a *bottom* border, Excel assumes headers. All other borders, even in the top row, are irrelevant as far as I can see.

    A special case where Excel assumes no headers regardless of other 'triggers':
    One or more cells of the top row is blank (with non-blank cells elsewhere in that column)

    The single most common scenario I see where Excel does not identify a header row correctly is for a numeric column with a number or date as the heading. Most often a year as the heading but I could imagine dates too. For example, in a spreadsheet of actual sales, I may have columns for 2018, 2019, 2020. No more text needed in these labels as the whole context is "actual sales". Other columns are likely to be all text such as customer, product, region, etc. If everything is formatted as "general", no headers will be detected. Changing value cells to use number formatting rather than general would be enough to trigger headers (as would changing number of decimal places or changing to currency, for example).

    So the simplest fix is to learn that the shortcut for converting to a table is "Ctrl+B, then Ctrl+T" (or "Ctrl+B, then Ctrl+L" if you have the old muscle memory for Lists like I do).

    *PS: Only sociopaths use "underline" as formatting in spreadsheets, rather than cell borders.

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

    We’ll send you updates on this idea

    An error occurred while saving the comment
    AdamV commented  · 

    Have you considered using a Table for your data so you don't need to use "Freeze top row" anyway because the table headings and filters are shown instead of ABCD when you scroll down?

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

    We’ll send you updates on this idea

    An error occurred while saving the comment
    AdamV commented  · 

    @Kathy An alternative way for you to avoid this issue: use a Table for your data, then you can turn the filter arrows on or at at will - without turning off the filters themselves. In other words, you can apply a filter, then hide the arrows to see your headings, then show them again when you want to change the filter conditions.
    Making the arrows smaller is likely to be very fustrasting for touch screen users (often the spreadsheets I build are "consumed" by people on a range of devices, they are generally reading, not editing, but do need to sort and filter).
    Moving arrows to the headings is misleading when they only apply to one or another ranges on your sheet - if you have multiple ranges of data above one another, it would not be possible to choose between them. Again notice how tables move the whole of the heading and filters to replace ABCD etc when you scroll down and the table heading row goes off screen (so less need for freeze panes too).

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

    We’ll send you updates on this idea

    AdamV supported this idea  · 
  14. 1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    AdamV commented  · 

    You are missing the last parameter. Usage:
    IFERROR(some_formula, return this instead if there is an error returned by some_formula)

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

    We’ll send you updates on this idea

    An error occurred while saving the comment
    AdamV commented  · 

    Woudn't that be the same as CEILING and FLOOR functions which already exist?

  16. 14 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    AdamV supported this idea  · 
  17. 3 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    AdamV supported this idea  · 
  18. 7 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    AdamV supported this idea  · 
  19. 15 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    AdamV supported this idea  · 
  20. 7 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    AdamV supported this idea  · 
← Previous 1

Feedback and Knowledge Base