1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

    Yours,
    Chandoo
  2. 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...

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

Discussion in 'The Lounge' started by Luwak, Nov 11, 2018.

  1. Luwak

    Luwak New Member

    Messages:
    15
    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!
    ThrottleWorks and Hui like this.
  2. AlanSidman

    AlanSidman Active Member

    Messages:
    413
    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.
    ThrottleWorks and Luwak like this.
  3. Hui

    Hui Excel Ninja Staff Member

    Messages:
    11,671
    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
    ThrottleWorks and AlanSidman like this.
  4. Peter Bartholomew

    Peter Bartholomew Well-Known Member

    Messages:
    523
    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)
    Luwak, ThrottleWorks and Khalid NGO like this.

Share This Page