removing sexist algorithms
Please can you allow "Mrs. and Mr." to be written in excel without excel autocorrecting to "Mrs. And Mr." because the traditional rules state that the man is first. I am writing letters to donors and I always put the donor in the first position and the associated donor in the second. Excel only auto capitalizes the "and" when it is in the Mrs. and Mr. position. This is a pain that it was written into the algorithm. And sexist. Thanks.
You are able to set the rules for when Office should not change the first letter of a sentence to a capital. You can add to the list of abbreviations which should behave as exceptions to the option “Capitalize first letter of sentences”.
Add “Mrs.” to the list of exceptions by these steps:
1. In Word, type “Mrs. and Mr.” and after it capitalizes “And”, backspace and fix it so that it’s lowercase “and”. This will add “Mrs.” as an exception so that the next word you type will no longer by capitalized.
2. Quit Word and restart Excel.
1. In Excel or Word, go to File > Options > Proofing > AutoCorrect Options… > Exceptions.
2. Type “mrs.” in the text field and click “Add”.
3. Click Ok, Ok, Ok.