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.
Tips
How-to
News
Videos
Stories
So...Kathy wants to know how to change the cursor direction in Excel when she presses Enter. Turns out it's a simple little setting:
(There's more information on all your options when moving the cursor here.)
Now if you're using Excel 2010 or 2007, don't forget that you can add Options command to your Quick Access Toolbar for easy access. (Tip: When adding Options to the QAT, in the Choose commands from drop-down, choose File Tab; it's in there.)
Thanks, Kathy; I always learn new things from my readers and I found this to be one handy tip!
— Crabby
Comments: (16) Collapse
Is there a fix to the cursor randomly jumping to a new location? If I hesitate in email or Word 2007 it randomly jumps to a new location as I am typing. Doesn't seem to happen in Excel or PowerPoint, but I don't use them as much. This only started happening when I bought a new Toshiba and upgraded to Office 2007. So I don't know where the porblem lies.
Grace: Is it a laptop? Could your hands, plams, fingers be unknowingly brushing the touch pad? Some touchpads are EXTREMELY sensitive. There's this 3rd party software called TouchFreeze (which I don't endorse since I've only heard about it) code.google.com/.../touchfreeze - it disables the Touchpad while you're typing. Give it a try!
I learning Excel in a College course, and I feel like I am getting it, except the (IF) functions, they confuse the hell out of me. Did someone come up with those in their spare time just to make us simple folk suffer???? just wondering....Anyway, I am just finishing up with Excel and about to go on to Access, what's the difference??? P.S., is there an easier way to learn (IF) functions for Excel by the way, and is Access going to be really difficult? Thank you, and I LOVE your post, nothing like crabby lady first thing in the morning for a good laugh, especially when you don't want to be working!!! Thanks for keeping it real, and all the miserable and angry (men) can go (Bleep) themselves, their just angry because their hair is falling out! :)~ Mary
Is there a way to add a button to the quick access toolbar to change the direction the cursor moves in? I found a direction button and added it but it is dimmed and I can't figure out how to get it to work.
In Excel 2007 it is the Home menu not the File menu. And the option is called Excel Options not Editing Options (and you don't need to go into any other menus first).
@Dave: Excel 2010: I didn't say File menu; I said press the Office button INSTEAD of the File menu. That is the way to get to Options > Edvanced > Editing Options.. Check again...
Don’t stop blogging! It’s nice to read a sane commentary for once.
Thanks for the great Office tips! In my version of Excel 2007 the arrow keys move the view, like moving the horizontal or vertical sliders, but I'd like to use them to move the cursor from cell to cell instead. I can't find where to make this change - any ideas?
Smachdab - isn't this what I wrote about in this post?
Click the Office Button, and then:
1.Click File > Options > Advanced > Editing Options .
2.Now, below the heading Editing Options you'll see After pressing Enter, move selection and below that, in the Direction drop down box is where you can make your choice.
Hi, Excel has now decided, when I view a spread sheet and try to cursor (the little arrow keys) through field to move the whole spead sheet and keep the cursor on the same highlighted field! Why? How do I get back to being able to cursor through my fields?
@Rayney: Is the tip above not working for you> Because from your description (which is a tad hard to understand) that is what I'm gathering. Can you rewrite this and expain?
"When I view a spread sheet and try to cursor (the little arrow keys) through field to move the whole spead sheet and keep the cursor on the same highlighted field."
It seems like text is missing b/c you say, "when I view a spreadsheet and try to cursor..." you don't say what happens...
Crabby - I have the exact same problem as Rayney. Perhaps I can explain better: If I place my cursor in a cell, say "C769", for example, what I would like to have happen is for the spreadsheet to stay where it is and for the arrow keys to move the cursor to different cells. Pressing the "right" arrow should move the cursor to C770, then C771, etc. Instead, what happens is this: the cursor stays in the exact same cell and the spreadsheet itself translates off the screen and out of view. How do Rayney and I fix this problem?! The tip you mention above seems close, but no cigar.
@Keith and Rayney: Turn OFF the ScrLk button on our keyboard. I'm pretty sure that simple trick will solve your issue... Will you let me know???
When I place my cursor on a cell it highlights the one below. How do I get the cursor to highlight the cell under the cursor?
@Tony: I don't quite get what yo'ure saying: you say the cell under the cursor is highlighted ...and then you ask how to highlight the one under your cursor. What's the diff?
Comments: (loading) Collapse