You can use your favorite social network to register or link an existing account:
Or use your email address to register without a social network:
Sign in with these social networks:
Or enter your username and password
Forgot your password?
Yes, please link my existing account with for quick, secure access.
No, I would like to create a new account with my profile information.
At the beginning of the year, I wrote a blog post called What's up with those wacky keyboard keys? In it, I answered a question from a lady named Barbara in Cape Cod ("The Cod" some friends of mine who used to live there call it) about some of the keys on her keyboard that mystified (read: annoyed) her: SysRq, PrtScn, and ScrLk.
Apparently SOME of you, whom I'm reticent to name (Keith and Rayney), wrote in to ask basically this question: When they were in Excel, why were the arrow keys not jumping from one cell to the other? Why were they just moving the entire spreadsheet up, down, to the left or right? They asked this question in the form of a comment on a post I wrote last September called Change where the cursor moves after entering data in Excel. In this post I explained how to change the cursor direction when pressing Enter. But as Keith said in his comment: "The tip you mention above seems close, but no cigar."
Well, Keith and Rayney, although I answered your question right there on the post, I'm never really sure if anyone checks back. I mean, I know we're all really busy and we've got a lot of thing to do, but if you ask a question and want an answer... Well, anyway, here is the very complex answer:
Turn off the ScrLk (Scroll Lock) key, meaning press it so the little green light on the keyboard is not lit. (On my keyboard—that you can see here—when the ScrLk key is ON the little green light that is lit up is above an arrow icon; it may be different on your computer; just press the ScrLk key a few times and see where it indicates if it's off or on.)
I'm almost 100% positive that will work.
And so, you may ask, if this button wreaks so much havoc, why does it even exist? What's it for? I actually don't know. And do I researched it on the Great Oracle of Information and Misinformation: The Internet.
Well, we already know that it keeps you from moving from one cell to the other. And on that note, as it turns out, many of computer keyboards have done away with it because it's just a remnant of the old IBM PC keyboard meant to lock all scrolling techniques. But why? WHY lock scrolling altogether? When would you ever want to do that? Keith and Rayney don't want to do it and I imagine most of you don't either. (I know I don't; I enjoy the freedom—no, the right—to scroll as I please.)
This is what I found out:
And so, as it turns out, the ScrLk key is both a hooligan and a helpful friend. Just depends on what you want to do today.
Crabby's Find of the Week: I love photography. While not a *real* photographer myself, I have do a *real* appreciation for people who are. Todd Selby is one of my favorites and I just wanted to share with you some of his extraordinary work.
Not finding the help you need from the various channels you've tried? Microsoft Answers is where you're most likely to solve your nagging problem.
I found that little gem some time ago, in Excel as you say it is most often, checking for an row by ScrollLock 30 or 40 rows down you have all the rows moving up or down and you can observe across the row. Clicking it one cell per row at a time is a waste.
PS Talking about pictures still have that one of you out there on the entrance wall by the Microsoft sign.
@ChidesterSr: That pictureof me? Of boy - that was about...5 or 6 yers ago! You DO know that it came from a bunch of videos I did back then...right? Som eof them are here: www.youtube.com/.../CrabbyOfficeLady (They're a little goofy but certainly were fun to make!)