Feedback by UserVoice

Kenneth Barber

My feedback

  1. 173 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kenneth Barber supported this idea  · 
  2. 143 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kenneth Barber supported this idea  · 
  3. 90 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kenneth Barber supported this idea  · 
  4. 312 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Kenneth Barber commented  · 

    The problem with using a user-defined function in VBA is that the workbook needs to be macro-enabled. Also, VBA is slowly being abandoned, so that is not a long-term solution.

    An error occurred while saving the comment
    Kenneth Barber commented  · 

    Frank, the Text To Columns feature produces a static output, cannot be used in formulas, and must be initiated manually. It is good, but it isn't enough. That is why everyone wants a SPLIT/TEXTSPLIT function.

    Kenneth Barber supported this idea  · 
  5. 58 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Kenneth Barber commented  · 

    In my opinion, dates should be their own data type, similar to stocks and geography. That data type could be 64-bit Unix time or ticks, and both formats extend well before 1900.
    https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/38778028-add-64-bit-unix-time-as-a-data-type

    Kenneth Barber supported this idea  · 
    An error occurred while saving the comment
    Kenneth Barber commented  · 

    It should hopefully be an easy fix for Microsoft. All dates are non-negative numbers, so just allow for negative dates.

  6. 2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Kenneth Barber commented  · 

    @leigh
    My suggestion was to suggest simplifications, not force them on the user. It would be the user's choice to take the suggestion or not.

    Kenneth Barber supported this idea  · 
    An error occurred while saving the comment
    Kenneth Barber commented  · 

    Yes! BumbleBee (not to be confused with Bumblebee) is on the right track! However, its default set of rules is limited.

    Kenneth Barber shared this idea  · 
  7. 7 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Excel for Windows (Desktop Application) » Other  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Kenneth Barber commented  · 

    A major part of the "etc." is spam and requests with lots of swearing.

    Kenneth Barber supported this idea  · 
  8. 54 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kenneth Barber supported this idea  · 
  9. 22 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Kenneth Barber commented  · 

    Currently, the width/height of an autofitted column/row depends on the zoom level, so if you want to be able to undo/redo an autofit perfectly, you also need to keep track of the zoom level.

    For this suggestion to be completed, these suggestions would need to be completed first:
    https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/18320665-update-autofit-row-height-feature-to-work-at-any-z
    https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/10781310-zoom-scaling-desync-between-cells-and-font

    Kenneth Barber supported this idea  · 
  10. 22 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kenneth Barber supported this idea  · 
  11. 3,693 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Good news! We’ve started working on this suggestion, and we’re currently testing the improved scrolling experience in our lab. It will allow you to stop partway through the row or column. The sheet will no longer need to snap to the top and left edge of the cells. Since scrolling is such a fundamental and highly used action in Excel, it may take a while to get it right. We hope to have it ready within a few months, but can’t provide an exact target date just yet. Thanks again for all your support and patience for this long awaited improvement.

    We’ll post an update here when we start rolling it out for you to try. It will be made available to Office Insiders first. Here’s how you can join – https://insider.office.com/en-us/join/windows.

    Thanks – Steve [Microsoft Excel]

    Kenneth Barber supported this idea  · 
    An error occurred while saving the comment
    Kenneth Barber commented  · 

    Duplicate of:
    https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/9769824-have-excel-scroll-better-when-there-are-large-cell

    Also, the jumping of multiple lines at a time when using the scroll wheel is due to your mouse setting, not Excel. Go to Control Panel, Mouse, Wheel tab and change the settings there.

  12. 1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kenneth Barber shared this idea  · 
  13. 1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kenneth Barber shared this idea  · 
  14. 2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
  15. 41 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Kenneth Barber commented  · 

    More specifically, this is in beta. The LAMBDA function lets you define your own function, and you can give it a name in the Name Manager.

    It would be nice if the LAMBDA function supported variable-length argument lists (e.g. like my XNOR and RMS examples above) and optional arguments, but that can be saved for another suggestion, possibly for another function. The LAMBDA function as it currently is still adds a lot of expressive power to Excel's formula language.

    Kenneth Barber supported this idea  · 
    An error occurred while saving the comment
    Kenneth Barber commented  · 

    To prevent potential conflicts with the names of future functions, perhaps all UDFs can have the prefix "UDF.". For example, UDF.YESTERDAY().

    An error occurred while saving the comment An error occurred while saving the comment
    Kenneth Barber commented  · 

    If Microsoft collects data on commonly used user-defined functions, then they can determine some of the functions that they should add as built-in ones without having to ask people what they would like.

    Kenneth Barber shared this idea  · 
  16. 3 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Kenneth Barber commented  · 

    Can you do something like this? I don't have the right version of Excel to test this.
    LET(FACTORIAL,LAMBDA(n,IF(n=0,1,n*FACTORIAL(n - 1))),FACTORIAL)

  17. 1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Kenneth Barber commented  · 

    Angela, the 1st argument of VLOOKUP is supposed to be a single value or a reference to a single cell. You have a reference to a whole column in there.

    Also, I would prefer if your comment was relevant to the suggestion that I posted. UserVoice is for suggestions, not questions. Lastly, I don't think that the company that you work for would appreciate you sharing their confidential information like that.

    Kenneth Barber shared this idea  · 
  18. 6 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Kenneth Barber commented  · 

    I just learned about ticks. They are also 64-bit but span from the start of the year 1 to the end of the year 9999 and have a precision down to 100 nanoseconds. Since 64-bit Unix time does not support subseconds and Excel does support subseconds, ticks might be a better successor to Excel's serial numbers.

    More about ticks:
    https://docs.microsoft.com/en-us/dotnet/api/system.datetime.ticks?view=netcore-3.1

    An error occurred while saving the comment An error occurred while saving the comment
    Kenneth Barber commented  · 
    Kenneth Barber shared this idea  · 
  19. 11 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kenneth Barber supported this idea  · 
  20. 13 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kenneth Barber supported this idea  · 
← Previous 1 3 4 5 43 44

Feedback and Knowledge Base