Excel behaves strangely
Thread poster: Heinrich Pesch

Heinrich Pesch  Identity Verified
Finland
Local time: 04:45
Member (2003)
Finnish to German
+ ...
Jun 5, 2008

Today I opened my Excel-file for bookkeeping and started to update it. But today I cannot fill in a cell and go to the next cell using arrow-right. When I hit arrow-right the table moves one column to the left in the Excel window, but the cursor stays in the edited cell. I have to hit return to get out.
Can anyone tell me what has happened and how to get back to the normal behaviour?
Regards
Heinrich


Direct link Reply with quote Turn social sharing on.
Like 3
 

Boyan Brezinsky  Identity Verified
Bulgaria
Local time: 04:45
English to Bulgarian
+ ...
ScrollLock Jun 5, 2008

You have pressed ScrollLock. Strangely, MS Excel is probably the only one of the widely used software applications in the PC/Windows world where ScrollLock has any effect.

Direct link Reply with quote Turn social sharing on.
Like 18
 

Heinrich Pesch  Identity Verified
Finland
Local time: 04:45
Member (2003)
Finnish to German
+ ...
TOPIC STARTER
Ok Jun 5, 2008

Yes, that was it. I did not even know there was such a key. Thanks for your fast help!

Direct link Reply with quote Turn social sharing on.
Like 17
 

Pompeo Lattanzi
Italy
Local time: 03:45
English to Italian
+ ...
It has its uses! Jun 5, 2008

bsb_2 wrote:

You have pressed ScrollLock. Strangely, MS Excel is probably the only one of the widely used software applications in the PC/Windows world where ScrollLock has any effect.


The scrollock is extremely useful, I would say essential, when you have to explore a (typically) large worksheet without losing you present position. This happens often if you modify the sheet regularly. Of course you can divide and lock windows too, but it would be too much work if all you need is a quick peek.
I also use another trick: I enter a "+", thereby starting a formula in the cell, then I go wandering wherever I need to. After I've found out whatever it was, typically in a very far worksheet, all I need to do is press "Esc" and I'm back to where I started instantly!


Direct link Reply with quote Turn social sharing on.
Like 13
 


To report site rules violations or get help, contact a site moderator:


You can also contact site staff by submitting a support request »

Excel behaves strangely

Advanced search






SDL Trados Studio 2017 only €495 / $595
Get the cheapest prices for SDL Trados Studio 2017 on ProZ.com

Join this translator’s group buy brought to you by ProZ.com and buy SDL Trados Studio 2017 Freelance for only €495 / $595 / £425 / ¥70,000 You will also receive FREE access to Studio 2019 when released.

More info »
PerfectIt consistency checker
Faster Checking, Greater Accuracy

PerfectIt helps deliver error-free documents. It improves consistency, ensures quality and helps to enforce style guides. It’s a powerful tool for pro users, and comes with the assurance of a 30-day money back guarantee.

More info »



Forums
  • All of ProZ.com
  • Term search
  • Jobs
  • Forums
  • Multiple search