Live data from Hacker News

Some Excel users pop F1 off their keyboards (2012)

businessinsider.com

61–70 of 219 posts

Re: Some Excel users pop F1 off their keyboards (2012)

#61
Business Insider has annoying anti-adblocker popups. Is there some way to block websites that do this?

I tried living without adblocker for a while, but I started getting some very not safe for work ads from dhgate all over the place. Just because I buy electronics doesn't mean I want ads for lingerie...

Re: Some Excel users pop F1 off their keyboards (2012)

#62
post #19

There are dozens of us. It's massively disrupting to the state of flow to miss a key by one, and suddenly another window pops up, but there's no text inside. It takes several seconds for the window to compose itself, and several more to close. I do keep the F1 key somewhere safe, to put back onto the keyboard, for the next keyboard user.

I do too. And the scroll lock and num lock too. And I added a sticker to let IT know that the keyboard isn't broken and shouldn't be replaced.

I came here to mention Scroll Lock which normally doesn't do much in Windows applications but I was utterly confused the other day when my Excel started behaving weirdly !

Re: Some Excel users pop F1 off their keyboards (2012)

#63
F2 is also rename on a host of Windows applications, including Windows Explorer.

I've popped it off more than once but couldn't get used to not hitting F3 instead of F2.

What I ended up doing was to rename Windows Help (winhlp32.exe at the time) to something else then copy and rename cmd.exe (or command.com, depending on how far back) to "winhlp32.exe". Now when I pressed F1 it would open a command window, much more useful and less intrusive if hit accidentally.

Re: Some Excel users pop F1 off their keyboards (2012)

#64

Back in my Engineer days, where I'd spend much of my time writing technical reports, I'd always remove the Insert key from my keyboard. It's sitting there in that block of six keys that you use all the time when editing text (home, end, page up/down, delete), and it's a little timebomb. You would invariably hit it by accident at some point and change your editor into "overwrite all my stuff" mode. It would usually ta…

I can't think of one time I've ever intentionally used the overwrite functionality either.

Re: Some Excel users pop F1 off their keyboards (2012)

#65

Business Insider has annoying anti-adblocker popups. Is there some way to block websites that do this? I tried living without adblocker for a while, but I started getting some very not safe for work ads from dhgate all over the place. Just because I buy electronics doesn't mean I want ads for lingerie...

Agreed. I actually got so irritated with this site, that I have added the simple blocker add in to chrome to block this site. I refuse to support them anymore. I dont care if they have something I want to read, Im not visiting that site ever again...

Re: Some Excel users pop F1 off their keyboards (2012)

#66

Back in my Engineer days, where I'd spend much of my time writing technical reports, I'd always remove the Insert key from my keyboard. It's sitting there in that block of six keys that you use all the time when editing text (home, end, page up/down, delete), and it's a little timebomb. You would invariably hit it by accident at some point and change your editor into "overwrite all my stuff" mode. It would usually ta…

I can't think of one time I've ever intentionally used the overwrite functionality either.

I vaguely recall using it a few times back in the day to edit things like fixed-format columnar text files. Now that sort of thing is easier with years worth of accumulated knowledge of tools, but I wasn't born with that knowledge.

Re: Some Excel users pop F1 off their keyboards (2012)

#67

Back in my Engineer days, where I'd spend much of my time writing technical reports, I'd always remove the Insert key from my keyboard. It's sitting there in that block of six keys that you use all the time when editing text (home, end, page up/down, delete), and it's a little timebomb. You would invariably hit it by accident at some point and change your editor into "overwrite all my stuff" mode. It would usually ta…

>laptops have ruined that old useful six-key block

For what it's worth, my Thinkpad definitely isn't ruined--it has a five key block containing the other keys you mentioned. Insert is over to the right in a four-key row (along with PrtSc, ScrLk, and Pause) that's above F9-F12

Re: Some Excel users pop F1 off their keyboards (2012)

#68

Earlier quoted context omitted.

Excel users don't think that way, I guess. Remapping keys requires a registry update on Windows, which many of my windows-at-work friends don't get access to. Even if they did, they might not trust themselves to make registry updates. Popping the key off is easy, secure, and effective.

A 2-line autohotkey script would be enough to disable the F1 key in just Excel. You can even compile it down to a single copyable binary.

But your users are all trained not to run random scripts or binaries, right? ...right? ;)

Re: Some Excel users pop F1 off their keyboards (2012)

#69
post #62
post #19

Earlier quoted context omitted.

I do too. And the scroll lock and num lock too. And I added a sticker to let IT know that the keyboard isn't broken and shouldn't be replaced.

I came here to mention Scroll Lock which normally doesn't do much in Windows applications but I was utterly confused the other day when my Excel started behaving weirdly !

Well, now you know what Scroll Lock is for, heh. :) It's done that in spreadsheets since the early versions of Lotus 1-2-3 for MSDOS.

Re: Some Excel users pop F1 off their keyboards (2012)

#70
post #66

Earlier quoted context omitted.

I can't think of one time I've ever intentionally used the overwrite functionality either.

I vaguely recall using it a few times back in the day to edit things like fixed-format columnar text files. Now that sort of thing is easier with years worth of accumulated knowledge of tools, but I wasn't born with that knowledge.

Until you hit backspace to correct something...
Post reply on HN