How to Automatically Replace Text in Microsoft Excel

Date:2022-11-24 Author:Sandra

If you are always typing your company name repeatedly, or a very long name in Excel. You can actually use a very quick way to avoid typing repeatedly.

Go To File And Choose Options.

How to Automatically Replace Text in Microsoft Excel

Select Proofing in the list and click on AutoCorrect Options.

Automatically Replace Text

For example, if we want to get ‘My Office Tricks’ quickly, we can just type ‘mot’ in the cell. So we replace mot with My Office Tricks and hit Add.

How to Automatically Replace Text in Microsoft Excel
How to Automatically Replace Text in Microsoft Excel

Oh, that’s quite easy. Hope this helps. Please feel free to leave your comments and Suggestions too.

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

Your email address will not be published. Required fields are marked *