Problem with Arrow Keys in Microsoft Excel

 

Problem: Problem: When I click on the button, the button moves around, but the cursor box does not move around. It's a good idea, but I can not get it.

Solution: SCROLL LOCK button on your keyboard. On my keyboard, it's on the upper right hand corner, near the INS, DEL, HOME and END buttons, and it's labeled 'SCROLL LOCK'. Click that button once, and you should move out of the scroll lock mode. Now, the arrow keys should allow you to move around in your spreadsheet, which is the default beahvior in microft excel (XP, 2003, 2007, should not matter).

MS Excel Formula Error "Character is Equal(=) or minus(-) sign

 MS Excel Formula Error "Character is Equal(=) or minus(-) sign

This issue happen due to the difference between you keyboard and location (Region).

Like currently we are in Netherlands and we are trying to do vlookup in excel. But we are getting error anyways..

So, to identify the problem we just try this in excel

=12,000/1000 = 0,012

So to overcome this problem try to have close look in option of vlookup as shown below.

Here we have to us ";" instead of "," because of Region or location.

So, by this way you can resolve the issue. Hope this will help you.
In case you find other issue please do let us know. Thanks!!!!!