Make all Cell Styles small thumbnails so they don't take up so much real estate on the ribbon.1 vote
I have to include errors in the data so that it will not plot in a chart. However I also want to get Min, Max, Average, etc, but all these will return errors because the data has errors. Can this be fixed so that any errors are ignored, especially with Min and Max.1 vote
Add check box in tools to disable/enable mouse scroll zoom. Like most window apps, Excel can be zoomed in/out by holding down control key and scrolling mouse wheel. Currently, I don't believe there is a way to disable this feature.1 vote
Do you know my blog
Sorry, it is written in German - but there you find about more than 300 Items of strange things, bugs, contradictions, bad translation, bad design, ... in Excel.
On the page "Schade / geht nicht, Leute" (sorry, but it dosn't work, guys) I mention about almost 100 items, that people like to have, but there not inside Excel.1 vote
As Kenneth mentioned, we like to track one item per idea. Please open ideas for any of the items in the list below that you’d like to have voted on by the community.
Is it possible to split by using a foreign language text?1 vote
Dear Excel User Thank you very much for your time and passion in submitting this feature request. We are doing our best to respond to suggestions that get at least 20 votes. However, we are closing ideas with fewer than 5 supporters that have had no activity for more than 60 days, with the intention of freeing up your votes. Please resubmit your idea if you think it’s super important.
The chart wizard made it much easier to pick chart area and to chart data transposed. I'm sure it's possible to chart transposed but I no longer know how to do it.1 vote
How IF statements currently work:
A1=3; B1=2; C1=1;
IF(A1>B1>C1, "True", "False") Results: True
IF(C1<B1<A1, "True", "False") Results: False
Both these statements should be true, but the second one gives the wrong results. For situations like this the logic statements are only correct if the > symbol is used; otherwise the true and false statements get flipped.0 votes
Given the way Excel evaluates formulas, which is from left to right, this isn’t going to change. Here’s what happens:
IF (C1<B1<A1, “True”, “False”)
IF (1<2<A1, “True”, “False”)
IF (TRUE<3, “True”, “False”) <— you can see how the next check will fail (be false)
IF (FALSE, “True”, “False”)
The way to write this function so that Excel will do the right thing is:
IF (AND (C1<B1, B1<A1), TRUE, FALSE)
Hope that helps,
(sorry for the wonky formatting, apparently there’s some UserVoice markup I have to work around)
COUNTIFS can do exactly what COUNTIF does and more. The only disadvantages are writing the extra "S" and possibly a negligible hit in performance due to COUNTIFS using variable-length argument lists. My suggestion is to make COUNTIF work like COUNTIFS and make COUNTIFS a compatibility function.
I can't say the same for SUMIF and AVERAGEIF, since these functions allow the omission of their last argument, which can be a nice perk over their -IFS counterparts on the (very) rare occasion.0 votes
- Don't see your idea?