Kingwood Underground
the heart and soul of our Kingwood, Texas family
Login - Create Account - Help
Clean out your garage on Kingwood bookoo! Or find local garage sales on Yard Sale Search.com
KU Live!

Ok...Calling All Excel Experts.....**Problem Solved!!**

who's talking here?

Zionist NightOwl 1
KWPlanner 5
txdaddy 2
angelbebe77 2
zapper007 2

     » send to friend     » save in my favorites     » flag dangerous topic flag as a dangerous topic

KWPlanner --- 17 years ago -

I'm guessing that one of my kids did something within Excel in the past few days that has changed the way the cursor moves when you enter data, and I can't figure out how to get it back to 'normal' for me. Previously, when I entered data into a cell and hit 'Enter', the data would populate in the cell and the cursor would automatically move one cell down. Now, all of a sudden, when I type data into a cell and hit 'Enter' the data populates the cell, but the cursor doesn't move one cell down....it just stays there. I have to hit 'Enter' twice now - once to enter the data and a second time to move one cell down. Any fixes/suggestions would be greatly appreciated! 

Zionist NightOwl --- 17 years ago -

From menu, select Tools/Options/Edit. From Excel's Help screen: When you press ENTER to finish working in a cell, Microsoft Excel moves the cursor one cell down by default. However, you can select the direction in which you want the cursor to move. On the Tools menu, click Options. On the Edit tab, do one of the following: To change the direction in which the cursor moves, select the Move selection after Enter check box, and then select a direction in the Direction box. To keep the cursor in the current cell, clear the Move selection after Enter check box. 

zapper007 --- 17 years ago -

To change which cell is selected next ------------------------------------ When you press ENTER to finish working in a cell, Microsoft Excel moves you to an adjacent cell or leaves you in the current cell. 1. On the Tools menu, click Options, and then click the Edit tab. 2. To move to an adjacent cell, select the Move selection after Enter check box, and then select a direction in the Direction box. 3. To stay in the current cell, clear the check box. Somebody cleared the "check box" 

KWPlanner --- 17 years ago -

On the Edit tab, do one of the following: To change the direction in which the cursor moves, select the Move selection after Enter check box, and then select a direction in the Direction box. I went and looked, and the box is checked along with the option of moving the cursor down after Enter. I even tried un-checking it, closing out, going back in and checking the box but it still just sits in the same cell. Thanks, though, Zion! 

KWPlanner --- 17 years ago -

Zapper, I did step #2 and it is still just populating the data and not moving one cell down - which is what is showing under the Edit tab within Options. Thanks as well! I appreciate the help.....now if I could just get Excel to work! lol 

angelbebe77 --- 17 years ago -

Try hitting your scroll lock key, sometimes looks like ScrLk. Excel gets crazy with the Enter key and arrow keys when the scroll lock is pushed. 

txdaddy --- 17 years ago -

do you have scroll lock engaged? 

KWPlanner --- 17 years ago -

Scroll lock key is not activated..... Lol...this is so frustrating. I'm sure it is some very basic step I'll kick myself for once I figure it out. Thanks, angel & txdaddy! 

zapper007 --- 17 years ago -

Try calling Excel Support. They will 1st verify your license info. 866-452-4755, or 800-936-5700. Good luck... 

angelbebe77 --- 17 years ago -

Might be a macro problem. I don't know Excel that well yet... my training is on Nov 20. If you still have a prob, PM me on the 19th and I'll ask in my class. LOL! 

txdaddy --- 17 years ago -

ok, i have tried to replicate what is happening to you and I cannot. i am sure it is some strange combo key thing that happened and it's so simple we are all gonna be pissed when we find out what happened. sorry for the deadend. 

KWPlanner --- 17 years ago -

I figured out the culprit, but I still don't know why Excel flipped out on me. The file I was modifying apparently had macros built into it. When I open the file Excel asks me if I want to Disable or Enable the macros. I have figured out that if I click on 'Disable Macros' I get the problem I mentioned in the first post. However, if I click on 'Enable Macros' everything works like a charm. Like I said, I don't know why that is but I don't care! lol All I know is that it works now. Thanks to all who offered advice! 

page 1
Login to add your comments!

see more discussions about...


Online now:
hit counters

Terms of Service - Privacy Policy - Ice Box

Kingwood Underground