Feedback by UserVoice

Kevin Osborn

My feedback

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

    We’ll send you updates on this idea

    Kevin Osborn shared this idea  · 
  2. 24 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kevin Osborn commented  · 

    users should have the ability to resize every dialogue box!!!!!!

    Kevin Osborn supported this idea  · 
  3. 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  ·  Excel for Windows (Desktop Application) » Other  ·  Flag idea as inappropriate…  ·  Admin →
    Kevin Osborn commented  · 

    I generally echo your sentiment with one comment. Anything in the title bar should have a setting to hide it / remove it from the title bar. That allows some users to have quick access toolbar in the title bar while others like yourself can hide it.

    The annoying part is the other "non-removable" items such as user name, search, upcoming features, toolbar access options.

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

    We’ll send you updates on this idea

    Kevin Osborn shared this idea  · 
  5. 286 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thanks for the suggestion Levi! We’ll be taking a look at this along with some other asks around conditional formatting. It’s a big help to see the things with the most votes, particularly within areas like formatting. So please keep the votes coming for things you want us to do sooner!

    Thanks,
    John [MS XL]

    Kevin Osborn commented  · 

    CF is very powerful but seems left behind. Here is my list of needs for CF.
    - Make window resizable
    - Don't fragment rules when cut/copy/paste/insert/delete rows
    - Make formulas work like regular formulas (error checking, auto complete, result preview, volatile only if formula used is volatile)
    - Allow referencing of named ranges and structured table reference
    - Make search/find feature look inside CF formulas

    Kevin Osborn supported this idea  · 
  6. 98 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kevin Osborn commented  · 

    This suggestion is accepting votes so I encourage everyone to go vote here and also add you comments to give more support to improving CF.

    https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/8778211-improve-the-conditional-formatting-manager?page=3&per_page=20

    Kevin Osborn commented  · 

    Conditional formatting is arguably the most "left behind" area in Excel.
    - Make conditional formatting rules editor window sizable >> Yes
    - Make live preview >> Yes
    - Make formulas work like real formulas (auto complete, error checking, allow named ranges and structured reference, make them follow normal volatility rules based on the formulas used) >> Yes
    - Additions/Subtractions/Moving ranges should not fragment the CF ranges >> Yes

  7. 104 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kevin Osborn commented  · 

    An improvement to the suggestion would be to list the cells where the #REF would occur similar to Find All so that the user can click on the list and change the formula that would result in #REF and then come back to delete the cell or make the changes that would cause the #REF.

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

    We’ll send you updates on this idea

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

    We’ll send you updates on this idea

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

    We’ll send you updates on this idea

    Kevin Osborn commented  · 

    Actually if MS fixed (improved) dynamic arrays such that it can be placed inside a table the totals would be there via the table total row. Unfortunately at this time since a dynamic array cannot exist inside a table we have this problem as well as losing the ability to used structured reference for dynamic arrays (which are essentially a table).

  11. 19 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kevin Osborn commented  · 

    I understand where you are going with this but I'm not going to vote it up. IMO a better solution is to allow 1 dynamic array function inside a table. Not only will this address your issue with sum/count/avg for columns because tables can have a "total" row but it will also fix the deficiency in dynamic arrays whereby structured/table reference cannot be used to reference a column in a dynamic array so the developer is forced to revert back to column numbers. Similarly instead of having sum, count, average rows I'd rather see a "Row Total" added to tables (similar to column totals).

  12. 30 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kevin Osborn supported this idea  · 
  13. 29 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    We’ll send you updates on this idea

    Kevin Osborn shared this idea  · 
  15. 70 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kevin Osborn commented  · 

    I think there may be an issue with the phrasing of this request. I just got access to dynamic array functions and the problem is this.

    Before dynamic arrays we all created formulas to populate a column within a table with a list of data (many times unique) and lets call this ColA within Table1. Then we would create other columns via formulas based on [ColA] so [ColC] = [@ColA] * [@ColB] for a simple example. Structured reference made this awesome when tables have many columns. Then elsewhere in the spreadsheet we could use structured reference to look up values from Table1 (e.g. =SUMIFS(Table1[ColC],Table1[ColD]&"<>") ).

    Now with array formulas we can create a unique list A2 = SORT(UNIQUE(Table2[ColX])) and it will spill down column A. Then other columns (e.g. column B) we can create a formula B2 = IF(A2# = "Red",1,0) and this too will spill. So we have kind of created a 2 dimensional structure (i.e. a table) but we have no ability inside nor outside this "array formula created 2 dimensional structure" to use structure reference (i.e. column name) so we have to go back to remembering columns by column letter and we lose autocomplete that goes along with structured reference.

    So kudos for array formulas but what it looks like I will be doing until this is addressed is creating a helper column outside my table with the key information (i.e. the SORT(UNIQUE(***)) ) and then inside ColA of Table1 is the formula = Z2, = Z3, =Z4 etc.

    Give this some serious thought Microsoft. I realize you'll need to limit a table to 1 dynamic array formula per table or the dynamic arrays could conflict one another in the spill range. Without this you have seriously limited the usefulness of dynamic arrays.

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

    We’ll send you updates on this idea

    Kevin Osborn 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

    Kevin Osborn commented  · 

    Very interesting idea. Thanks for posting. It would need to be an optional parameter of course. And in some cases it would eliminate the need to add conditional formatting. I like it!

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

    We’ll send you updates on this idea

    Kevin Osborn supported this idea  · 
  19. 1,033 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

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

    We’ll send you updates on this idea

    Kevin Osborn supported this idea  · 
← Previous 1 3 4

Feedback and Knowledge Base