Every time I enter “HCl” into a cell and press enter, the program converts it to Hcl, believing I made a capitalization error. How do I prevent it from happening?
You can also include the “HCl” in the exceptions list of the Autocorrect Options. There are exceptions like CDs…
‘Tools’ > ‘AutoCorrect Options …’ > ‘Options’ : Switch off second option ‘Correct TWo INitial CApitals’
Is that for the file, or for each sheet?
It’s for the AutoCorrect feature as running on your system. It won’t be saved and passed on with the document. (Hope my old experiences don’t lead me wrong!)