News for hackers. Stuff that matters.
Re:Some Excel users pop F1 off their keyboards (2012) by WorldMaker on Friday September 22, 2017 @12:17PM (#15313477)
Keep in mind there's evolutionary momentum at work here, too. The standard uses of F1 and F2 especially that are at play in the discussion here date back to some of the earliest PC tools. Volkswriter supposedly used F1 for help as far back as 1982, and it was standardized in the 1987 IBM Common User Access guidelines (which also standardized things like F5 for Refresh before web browsers burnt that shortcut in all our brains): https://en.wikipedia.org/wiki/IBM_Common_User_Access

So it is very hard to trade-off the momentum of a three decades old standard just to delight particular subsets of power users.

Not to mention the other side of it: why was help so slow and aggravating? Were there ways to make it non-modal and faster. Unsurprisingly, that's been the focus where Office has tried to make an impact, trying to speed up Help and make it less obnoxious over the years, rather than change up a three decade old keyboard shortcut.

Re:Some Excel users pop F1 off their keyboards (2012) by mfoy_ on Friday September 22, 2017 @04:47PM (#15315645)
They could have acknowledged that F1 is "help" and really slow / annoying, so putting a much useful function onto F2 was probably a bad idea. They could have put what F2 did onto a different shortcut.

For instance, they could make F2 something that was infrequently useful and unintrusive, then made F3 do what F2 did. So if you mispress, you don't do the even worse F1 thing.

Re:Some Excel users pop F1 off their keyboards (2012) by Stratoscope on Friday September 22, 2017 @07:41PM (#15316947)
One thing to keep in mind is that some of these shortcut keys predated the modern AT-style keyboard with the function keys across the top. They were introduced way back in the day of the original PC keyboard with function keys in two columns at the left. F1 and F2 were side by side at the top of these columns, and they were very easy to distinguish from each other and hit reliably. F2 was just about the easiest function key for a touch typist to hit.

http://www.vintage-computer.com/images/83key.jpg

http://www.vintage-computer.com/ibm_pc.shtml

Re:Some Excel users pop F1 off their keyboards (2012) by WorldMaker on Friday September 22, 2017 @05:31PM (#15316019)
Again, per the link prior: this standard predates even Office itself. They could have not followed the standard, but then they would have angered users for not following standards used elsewhere in PC applications at the time.

F2 has long been "Rename Object" and F3 has long been "Find" (though Excel in this case doesn't use it for that, but that's another matter). Did IBM do enough user studies at the time? I'm not sure IBM could have found a user study to predict the order of those choices being irritating to Excel users two and half decades later.

Even then, too, the IBM CUA I pointed to was partly synthetic, pulling in commonalities from apps at the time of its writing. Given F2 is nearly universal as "Rename Object" [1], I've got a feeling it predates the IBM CUA by quite a bit in some heavily used applications, but I'm not a historian.

Office never existed in a vacuum, and the function keys have had common meanings for decades. Microsoft used a mix of the IBM CUA guidelines and presumably what they were seeing from the competition (Lotus 1-2-3 and VisiCalc especially for Excel early in its history). If they put the useful function of F2 somewhere else, they would have broken the muscle memory of so many other PC users, even early in Excel's history. If they moved it today there might be riots, some rioting even by the same people removing F1 keys from keyboards.

[1] You can see it on this chart and compare it with most of its neighbors: https://en.wikipedia.org/wiki/Table_of_keyboard_shortcuts