Feedback by UserVoice

Kenneth Barber

My feedback

  1. 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  · 
  2. 5 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  · 
  3. 44 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. 21 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  · 
  5. 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  · 
  6. 3,618 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

    I’m happy to let you know that we are in the planning stages to make Excel for Windows scroll without jumping to the edge of the cell so you’ll be able to scroll smoothly. We don’t yet have a target date, but wanted to tell you about our plans.

    We appreciate all the votes and comments supporting this suggestion.

    Thanks – Steve K [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.

  7. 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  · 
  8. 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  · 
  9. 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
  10. 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  · 
  11. 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)

  12. 298 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  · 

    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  · 
  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

    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  · 
  14. 5 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  · 
  15. 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  · 
  16. 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  · 
  17. 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

    Kenneth Barber supported this idea  · 
  18. 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

    Kenneth Barber supported this idea  · 
  19. 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  · 

    The problem with a "full name" button is that there are multiple ways of showing a full name. For example, for me, you can have "Kenneth Barber" or "Barber, Kenneth". Besides, the formulas to derive these are fairly straightforward. If A1 contains the first name and B1 contains the last name, then the formulas are:
    =A1&" "&B1
    =B1&", "&A1

    Thomas K missed the space in his formula.

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

← Previous 1 3 4 5 43 44

Feedback and Knowledge Base