• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Excel pet peeves

Luwak

New Member
While we agree that Excel is pretty awesome, things can always be improved. Let's share some pet peeves and hopefully workarounds to limit their impact. Here is one of mine: the Paste Special menu containing radio buttons instead of checkboxes so that it can take several repeated pastes to get the result that you want.

Looking forward to a solution for this and to read others' pet peeves!
 

AlanSidman

Active Member
Eliminate the ability to merge cells. It creates more issues than it solves. Should be used only for presentation. Never for analysis. Only the folks in Redmond can fix this. You, however, can avoid this like the plague.
 

Hui

Excel Ninja
Staff member
Eliminate the ability to merge cells. It creates more issues than it solves. Should be used only for presentation. Never for analysis. Only the folks in Redmond can fix this. You, however, can avoid this like the plague.
You can use Centre Across Selection to achieve the same result without the issues associated with Merge.
It is a shame that Centre Across Selection isn't available in the Merge Dialog in the Toolbar
 

Peter Bartholomew

Well-Known Member
My peeves are not going to be fixed; it is simply not possible to turn back time. For me, misnamed functions grate.

INDEX - this function uses indices as 2nd and 3rd parameters but returns an reference to a range (or an element of an array), usually a cell but sometimes a row or column. In any case, the normal mathematical convention, would be to use
= rangeName( 1, 2 )
rather than
= INDEX(rangeName, 1, 2 )

ROWS - returns a count of rows, not a collection of rows. Perhaps
= ROWCOUNT(rangeName)
would be a truer description. A proper function ROWS would be useful because one could then aggregate 2-dimension ranges to give a column of row-totals
= SUM(ROWS(rangeName)) :(

So it goes on with CELL, ROW, COLUMN …

It is a good thing the math functions don't follow the same 'convention' of naming functions by their key parameter, otherwise we might have the function
= ANGLE("sin", angle)
 
Top