Excel behaves strangely
Thread poster: Heinrich Pesch

Heinrich Pesch  Identity Verified
Finland
Local time: 12:41
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
 
Boyan Brezinsky  Identity Verified
Bulgaria
Local time: 12:41
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
 

Heinrich Pesch  Identity Verified
Finland
Local time: 12:41
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
 

Pompeo Lattanzi
Italy
Local time: 11:41
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
 


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






CafeTran Espresso
You've never met a CAT tool this clever!

Translate faster & easier, using a sophisticated CAT tool built by a translator / developer. Accept jobs from clients who use SDL Trados, MemoQ, Wordfast & major CAT tools. Download and start using CafeTran Espresso -- for free

More info »
Protemos translation business management system
Create your account in minutes, and start working! 3-month trial for agencies, and free for freelancers!

The system lets you keep client/vendor database, with contacts and rates, manage projects and assign jobs to vendors, issue invoices, track payments, store and manage project files, generate business reports on turnover profit per client/manager etc.

More info »



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