Excel Not Working How To Fix It

You will find below the steps to fix the issue of Formula Not Working in Excel.

However, the formulas are not producing any result and they are just being displayed as Text strings.

If the Formula is enclosed in quote marks, Excel will treat the Formula as a Text string.

With these keys available for each direction, you can easily go from one cell to another with a single key-press.

In some cases, they even take you to the next worksheet instead of moving to the next cell in the line.

Excel Not Working How To Fix It

If youre frustrated by this behavior, youll probably want to find out how to fix it.

In most cases, youre just a single keystroke away from getting the keys to do what they should be doing.

For as long as it remains enabled, the keys wont do what theyre supposed to do.

Its because most modern equipment has done away with that button thinking most users just wont use it.

You can also use it on the occasions when your real keyboard gets broken or just wont function normally.

Therell be a key named ScrLk which should help you enable and disable scroll lock on your PC.

Click on it and itll disable the scroll lock if it was enabled before.

However, theres a workaround that uses an AppleScript to let you fix the issue in Excel on your Mac.

It then does what it needs to do to get the arrow keys to work in the Excel program.

Enter FixExcelKeys.applescript as the name of the file and save it.

Double-click on the newly created AppleScript file and it should fix the issue for you.

However, if you didnt have any luck with them, you might want to try a few more and see if they help you resolve the problem.

While it isnt directly related to Excel or arrow keys, its worth toggling it to see if it fixes the issue for you.

If you have any add-ins installed, you may want to disable them and see if the arrow keys then start working.

Click on the File menu at the top and select Options from the left sidebar.

Select Excel Add-ins from the dropdown menu and click on Go.

Over the last few years, hes written a number of tech articles on various online publications including but not limited to MakeTechEasier and Android AppStorm.

My name is Aseem Kishore and I am a full-time professional blogger.

I graduated from Emory University with a degree in Computer Science and Mathematics.

Excel For Mac Not Working