Forum Discussion
manual formula writting
Hello
I've been facing an issue with formula for 2 days ago. When i manual write this =A2+B2 then press enter ti turns to ='A2'+'B2' which results with an error.
But if I select cells with arrow keys it show =(l)1(c)1 and it works.
How can i switch back to be able to write manually?
Thank for any help
2 Replies
Open Excel and click on the "File" tab.
Go to "Options".
Switch to the "Document review" tab and select "Autocorrect options".
Remove all ticks in the "Autocorrect" tab and confirm with "OK".
Turn automatic completion of cell entries on or off
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote any reply if it helps please, as it will be beneficial to more Community members reading here.
