kilgor13

I definitely agree with you on this. I'm from Leeds and my first thought was that there isn't really a term for someone from Leeds, other than someone from Leeds!

Leodensian might be a term that existed at some point, or is by lack of an alternative, the default word, but it isn't actually used to the point where any person from Leeds would expect another person from Leeds to understand the term (let alone someone from elsewhere)

Now I think about it, I can't think of many names for citizens of the main yorkshire cities (York, Sheffield??). Perhaps "yorkshireman" or "yorkshirewoman" has been enough...

I mostly agree with you. Where the names are clear and obvious, naming is very helpful.

However, when it is no longer obvious what the name refers to, there is no more benefit than the original cell reference. In fact it is even worse because it's not immediately apparent where the cell is now the reference isn't showing. I often run into this problem with very large spreadsheets where every cell is named.

Our workplace has a strict "everything has to be named" in Excel and it really makes life much more difficult when working with extremely large calculations. Often I will want to know what a certain formula is doing. I will look at the formula. There are about 6 named cells that I have no idea what they refer to. I then have to use the drop down list (which includes about 500 names) to find the cell it refers to. Looking through this list is a lot slower than just reading the cell reference and looking at that cell. It's also quite easy to pick the wrong name in a list of 500, because there is likely to be a lot of similarly named cells.