Feedback by UserVoice

Roy

My feedback

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

    We’ll send you updates on this idea

    Hi all,

    We have been working on this, and wanted to get your feedback on how you see this feature fitting into your workflow. We have a quick one question survey for you to give us your thoughts on the look and keyboard shortcuts we have at this time. Please see here for more: aka.ms/datePickerSurvey

    Thanks!
    Blake, Excel Product Team

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

    We’ll send you updates on this idea

    Roy supported this idea  · 
  3. 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]

    Roy commented  · 

    Oh, and an Add-In could create those NR's one specifies if they do not already exist. Further ease our pain.

    Roy commented  · 

    I don't use VBA much, and when I do I'm more like a "hunt and peck" typist than a "touch" typist, so to speak. So I don't know the tools it has for addressing CF. I DO know that CF is not attached to cells in the way normal formatting is, i.e.: the tools for formatting and working with formatting don't even reveal its presence, apparently.

    However, the places that say that last part seem to indicate it CAN be addressed, so perhaps there is a reasonable minimum of tools. If so, it seems an instruction to define a range to apply the CF to would be near the top of the "these be basic" list.

    Assuming so, one could create NR's for all the "applies to" boxes that could change, or simply all that are in one's CF (I know, that'd be a bear for some folks' CF-ing, but even still, this would greatly simplify their making sure the ranges stay right), and write a macro that changes the "applies to" for all rules by applying the appropriate NR to each.

    If a standalone macro, one could run it any time, especially right after a change one made that one feared would change things. It could be called from an OnOpen macro to make sure they are set right upon opening the file.

    So whatever happens, running it would simply reset them all to their NR's: I know Excel will instantly convert them, but who would care at that point? They'd be right, either way. Oh, "drag and drop" orphans would be lost, but again, who among us cares? We are not the people doing that.

    Someone with the skills and time could write an add-in that might list the rules interactively, let you define the NR's to use and where, and provide the macro to update them whenever along with an option for OnOpen.

    And someone at Excel could do that too, offered along with distributions the way the Analysis ToolPak is (Why would anyone ever not want that loaded? Why is it an option to load rather than to unload when first installing?).

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

    We’ll send you updates on this idea

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

    We’ll send you updates on this idea

    Roy commented  · 

    THIS function would be the engine forcing the wrap function to run again and again: so NO NEW work would need done on the wrap functions. For all Excel would know, nothing unusual happened.

    So FIND() runs to an error on argument 1 in the list, then i sheld open to run again on argument 2, and so on, only being allowed to close when the first success is found, or all items failed and the error is to be returned. NO new programming for FIND() though, as the LIST() function does all the necessary re-running before returning control to FIND().

    Roy commented  · 

    Jeez, and typos too. I blame this entry box.

    Roy commented  · 

    Oops... if they do this one, the very first error entering it is in the above... dropped a ")"...

    Roy shared this idea  · 
  6. 1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Roy commented  · 

    If you mean how do you make its color red in the formula editing bar, you can't. Excel completely controls what happens there and gives us nothing.

    If you mean how to make its color red if it is the result of the formula, and is teh value currently displayed in the cell, you just need to change the cell's number format a "custom format" (absolute last choice in the list of kinds of number formatting available, then edit it as so:

    #,##0.00;[Red]-#,##0.00

    (Where I put the "#,##0.00" strings you would put whatever your chosen format is. The magic is done after the semicolon — ; — when you put in the "[Red]" part.)

    Excel gives us four basic formatting divisions for numbers: the first is positive numbers, the second is negative numbers, the third is zero, and the fourth is text and you tell Excel a section is complete using the semicolon. So:

    positive;negative;zero;text

    However, you can actually use them more particularly to your taste, that is just the built-in idea. For example, the first part is usually called the part for positive numbers but it is really a comparison: [>0]. Excel is just trying to be helpful: you can put any other comparison there instead but have to spell it out, so to speak. So your first part could be [<100] followed by a format, and your second could be [>=100] and so on (you might have the first use the color Blue and the second use Green: positive values would then be either Blue (modest positive values) or Green (high positive values) achieving the effect of conditional formatting without using the nasty, messed up beast they call conditional formatting) and then use the third area for negative number formatting and so on.

    All that can easily be found on the internet. Just touching on it lightly to give you the incentive to look it up. It is a very handy thing, especially for the purpose you are asking about.

    Also, not often mentioned are two other things on the subject. If you use the TEXT() function, you can include this kind of idea in the format specified. The second, I guess I won't really go into as it's a bit complicated, but there is a really nice feature for international spreadsheet use.

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

    We’ll send you updates on this idea

    Roy commented  · 

    Actually, never noticed the example file before.

    @Narendra: No need to "--" the LEFT() function as its result from this data is a true number if the data is a true number (and the way it is crafted, much of the point is to allow it to be exactly that), or, while returned as text Excel will still evaluate it as a number in any formula relying upon it.

    Also, whether text or number, the way things are formed for the example, the comparisons work as text OR numbers.

    Same idea for the YEAR() formula you show. No need for the "--" trick.

    That said, one WOULD need to know whether the result would be returned as number or text for setting up the comparison: if number, use IF() to compare to a number (say, 2020), if text, it has to be compared to a string (say, "2020"). So the need for the "--" trick is to simplify the comparison rather than using something like an OR() to test both ways at once, or even testing the kind of value (ISTEXT(), etc. to pick the comparison, to show how ridiculously complicated one could get. The "--" neatly handles all that with great simplicity and works on the returned data whether it is a number or text.

    @Alex T.: That comparison being done with all the IF()'s (column M) that need added to every year... you can simplify it amazingly using a VLOOKUP() on a table with the "year break" values in column 1 and the year to return in column 2. Use "TRUE" for the last argument and set up the table accordingly. VLOOKUP then performs all the comparisons so you can drop out all the IF()'s.

    Roy commented  · 

    Or use string functions if the data is well-formed, or uniquely so for the string of choice.

    But we do it SO often... it should be a feature, not a series of workarounds and data conditioning.

    How will they ever do computing the way Sci-Fi does, just talking to computers, if everything has to be spelled out, debugged, tested, then bug-fixed every use and all data requests have to imagine every way data could be adulterated?

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

    We’ll send you updates on this idea

    Roy commented  · 

    Just press (and release) "Alt" by itself and those go away wiuthout mouse activity, etc.

    Chances are you are using the shortcut and not releasing Alt in time causing it to "happen" again, displaying the available shortcuts which are in the displayed ribbon region.

    You can press Alt anytime, once, by itself, to see the same thing, and press and release it once again to make them go away.

  9. 3 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Roy commented  · 

    Just press (and release) "Alt" by itself and those go away wiuthout mouse activity, etc.

    Chances are you are using the shortcut and not releasing Alt in time causing it to "happen" again, displaying the available shortcuts which are in the displayed ribbon region.

    You can press Alt anytime, once, by itself, to see the same thing, and press and release it once again to make them go away.

  10. 3 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    We’ll send you updates on this idea

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

    We’ll send you updates on this idea

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

    We’ll send you updates on this idea

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

    We’ll send you updates on this idea

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

    We’ll send you updates on this idea

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

    We’ll send you updates on this idea

    Roy commented  · 

    Hard drives are huge and cloud storages people use are infinite.

    This could work like the Recycle Bin in Windows, except in a counterpoint kind of way. (RB doesn't save old versions of files, just literally deleted ones.)

    When you save a file, insted of overwriting the old one, it would "move" it (actually, just change its location information in Windows) to a new Excel Archive (and Word Archive and so on!) then write the newly saving version as if it had actually overwritten the old one.

    Nothing current need change for this, they'd just add on a capability. Like they did when they created AutoSave: it didn't change any existing feature, just added one.

    Actually, it'd be nice to still be able to overwrite by choice sometimes. But that seems like it'd be a teensy little bit of extra easily fitted in.

    And then one could have a dozen old versions. With access like we have to the Recycle Bin, one could set a variety of maintenace methods (i.e.: auto-deletion of older versions, with fine controls like keep no more than three of a file, or delete nothing newer than three years, or what-have-you, rather than gross ones like EVERYTHING, no matter how stupid it is to do so, after some length of time) and life could sparkle again...

    Roy 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

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

    We’ll send you updates on this idea

    Roy commented  · 

    Maybe it could be made a part of setting calculation to manual.

    You need to do this, you set Calc to manual, do your thing/s, set it back to auto and see how you did (do the errors roll in or is everyting jake?)

    If it could be tied into the manual Calc feature, that might be an easy way to achieve it.

    Roy commented  · 

    That IS obnoxious, and the workaround that works now did not for many years. YOu had to replace "=" with something like "k=" and do the F&R-ing, then remove the "k"...

    Should be an Option to click in F&R, like all the other Options available. Then it holds the cells being changed in abeyance, lets you do several operations, leaving the function box if need be and returning. Only when one clicks Finished would it check for broken formulas.

    Preach it brother!

    Roy supported this idea  · 
  19. 2 votes
    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 →
    Roy commented  · 

    Yeah, it'd be nice.

    I wished formatting could be specified as an addition to formulas, and pictured a string added for doing so (With, say, square brackets to make it clearly that.)

    But having a sample formatted cell somewhere, and specifying simply the formatting of that cell, would be even easier. And of course, that would work nicely for this.

    Even better would be if it also brought with it internal cell formatiing, where one letter is red while the others are black, for example.

    Harder would be cells that were like... LEFT(A1,3) but if it brought in-cell formatting it could format as those three characters are formatted.

    Roy 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

    Roy commented  · 

    (Sigh... ) 15 years ago it used to do precisely this...

    And with implicit intersection you could use those labels ("Use column headers as labels") like so:

    =East 1998

    to get (in this example) sales for the East region in 1998 without building Named Ranges.

    Now, with the new array formulas (spill formulas), they tout the idea that implicit intersection is completely going away too.

    You eveil people! Just use Tables, period! Get with it! Seems to be their thinking...

    Roy supported this idea  · 

Feedback and Knowledge Base