How to Turn Read Only Off in Excel

The tutorial explains how to effectively use AutoCorrect in Excel and how to stop it completely or just disable for specific words.

Excel AutoCorrect is designed to correct misspelled words automatically equally you blazon, but in fact information technology is more than than just correction. You tin can utilise this characteristic to change abbreviations to full text or supervene upon curt codes with longer phrases. It can even insert check marks, bullet points and other special symbols on the fly without yous having to access annihilation. This tutorial will teach yous how to do all this and more than.

• Excel AutoCorrect options
• How to turn off AutoCorrect in Excel
• Disable AutoCorrect for certain words
• Undo AutoCorrect in Excel
• Add, alter and delete AutoCorrect entries
• Insert special symbols using AutoCorrect

Excel AutoCorrect options

To have more command over how Excel performs autocorrection in your worksheets, open up the AutoCorrect dialog:

• In Excel 2016, Excel 2013 and Excel 2010, click File > Options, select Proofing on the left-paw pane, and click AutoCorrect Options.
• In Excel 2007, click the Office button > Options > Proofing > AutoCorrect Options.

The AutoCorrect dialog will testify upward and you tin can switch between the four tabs to enable or disable specific corrections.

AutoCorrect

On this tab, you can view the list of typical typos, misspellings and symbols that AutoCorrect uses past default. Y'all can alter and delete whatever of the existing entries also as add together your ain ones. Additionally, you tin can turn options on or off the following options.

The commencement pick controls the autocorrect logo (lightning commodities) that appears after each automatic correction:

• Show AutoCorrect Options buttons - shows or hides the autocorrect logo.

Please note that the autocorrect button does not appear in Excel anyway, clearing this box prevents the lightning bolt from appearing in Word and another applications.

The next four options command the automatic correction of capitalization:

• Right 2 Initial Capitals - changes the second majuscule letter to lowercase.
• Capitalize kickoff letter of judgement - capitalizes the first letter after a period (full stop).
• Capitalize names of days - self-explanatory
• Correct adventitious apply of cAPS LOCK primal - fixes words in which the first alphabetic character is lowercase and the other letters are uppercase.

The last option enables or disables all automatic corrections:

• Replace text equally you type - turns AutoCorrect off and on.

Tips and notes:

• Text included in formulas and hyperlinks is not automatically corrected.
• Every change y'all made in Excel AutoCorrect options applies to all workbooks.
• To prevent automatic capitalization subsequently some abbreviation or acronym that ends with a menses, add it to the Exceptions list. For this, click the Exceptions… button, type the abbreviation nether Don't capitalize after and click the Add push button.
• Non to correct ii initial uppercase letters, for example "IDs", click Exceptions, switch to the INitial CAps tab, type the give-and-take nether Don't right, and click Add.

AutoFormat as you lot type

On this tab, you tin can disable the post-obit options, which are enabled in Excel by default:

• Cyberspace and network paths with hyperlinks - turns text that represents URLs and network paths into clickable hyperlinks. To disable automatic cosmos of hyperlinks in Excel, clear this box.
• Include new row and columns in table - once you lot blazon anything in a column or row adjacent to your tabular array, such column or row is included in the table automatically. To stop the automatic expansion of tables, clear this box.
• Fill formulas in tables to create calculated columns - uncheck this option if you want to forbid the automated replication of formulas in Excel tables.

AutoCorrect actions

By default, additional actions are disabled. To plow them on, select the Enable boosted actions in the right-click carte du jour box, and then select the action yous desire to enable in the list.

For Microsoft Excel, merely the Engagement (XML) action is available, which opens your Outlook calendar on a given date:

To trigger the activeness, correct-click a date in a prison cell, point to Boosted Cell Actions, and click Testify my Calendar:

Math AutoCorrect

This tab controls the automated insertion of special symbols in Excel equations (Insert tab > Symbols group > Equation):

Please note that the math conversions only work in equations, merely not in cells. Notwithstanding, there is a macro that allows using Math AutoCorrect exterior math regions.

How to stop AutoCorrect in Excel

It may sound strange, but AutoCorrect in Excel is not always a do good. For example, yous may want to insert a product lawmaking similar "i-ANC", only it is automatically changed to "1-Can" each time because Excel believes you've misspelled the discussion "can".

To preclude all automated changes made by AutoCorrect, merely plow it off:

1. Open the AutoCorrect dialog by clicking File > Options > Proofing > AutoCorrect Options.
2. Depending on what corrections you want to finish, uncheck the following boxes on the AutoCorrect tab:
   • Articulate the Replace text as you type box to disable all automatic replacements of text.
   • Clear some or all check boxes that command automatic capitalization.

How to plow off AutoCorrect for certain words

In many situations, yous may not desire to stop autocorrect in Excel completely, but disable it for particular words. For example, you lot tin can keep Excel from changing (c) to the copyright symbol ©.

To stop auto-correcting a specific word, this is what y'all need to do:

1. Open the AutoCorrect dialog (File > Options > Proofing > AutoCorrect Options).
2. Select the entry you want to disable and click the Delete button.

The screenshot below shows how to turn off the autocorrect of (c):

Instead of deleting, y'all tin supercede (c) with (c). For this, type (c) into the With box, and click Replace.

If you lot decide to render autocorrect (c) to copyright in the future, all you'll take to exercise is open up the AutoCorrect dialog and put © in the With box again.

In a similar manner, you can turn off autocorrect for other words and characters, for example, forestall irresolute (R) to ®.

Tip. If you lot have difficulties with finding the entry of interest in the auto-right list, type the word in the Supervene upon box and Excel will highlight the respective entry.

How to undo AutoCorrect in Excel

Sometimes, you may need to prevent autocorrect of a specific entry just one time. In Microsoft Word, you'd merely printing Ctrl + Z to undo the modify. In Excel, this deletes the entire cell value instead of reverting the correction. Is in that location a way to undo AutoCorrect in Excel? Yep, here's how you tin do this:

1. Type a space later the value that is auto-corrected.
2. Without doing anything else, press Ctrl + Z to undo the correction.

For instance, to disengage the autocorrect of (c) to copyright, blazon (c) and then type a space. Excel performs the car-correction, and y'all immediately printing Ctrl + Z to have (c) back:

How to add together, change, and delete AutoCorrect entry

In some situations, you may want to extend the standard list of misspellings used by Excel AutoCorrect. Equally an example, let see how we can forcefulness Excel to replace the initials (JS) with the total name (John Smith) automatically.

1. Click File > Options > Proofing > AutoCorrect Options.
2. In the AutoCorrect dialog box, enter the text to be replaced in the Replace box, and the text to replace with in the With box.
3. Click the Add button.
4. Click OK twice to close both dialogs.

In this example, nosotros are adding an entry that volition automatically replace "js" or "JS" with "John Smith":

If yous'd like to modify some entry, select it in the listing, type the new text in the With box, and click the Replace button:

To delete an AutoCorrect entry (predefined or your own ane), select information technology in the list, and click Delete.

Note. Excel shares the AutoCorrect list with some other Function applications such equally Give-and-take and PowerPoint. And so, any new entries that you have added in Excel will also work in other Office applications.

How to insert special symbols using AutoCorrect

To have Excel insert a tick marking, bullet bespeak or another special symbol for you automatically, simply add information technology to the AutoCorrect list. Hither's how:

1. Insert a special symbol of interest in a prison cell (Insert tab > Symbols group > Symbols).
2. Select the inserted symbol and press Ctrl + C to copy it.
3. Click File > Options > Proofing > AutoCorrect Options.
4. In the AutoCorrect dialog, do the following:
   • In the With box, type the text that you want to associate with the symbol.
   • In the Supplant box, press Ctrl + Five and paste the copied symbol.
5. Click the Add button.
6. Click OK twice.

The screenshot below shows how yous can create an motorcar-correct entry to insert a bullet signal in Excel automatically:

And now, whenever you type bullet1 in a cell, information technology volition immediately be replaced with a bullet point:

Tip. Exist sure to use some unique word to name your entry. If you use a common give-and-take, you lot'd often need to revert auto corrections not just in Excel, but in other Part applications.

That's how yous use, adjust and stop AutoCorrect in Excel. I thanks for reading and hope to see y'all on our blog next week!

You may also be interested in

clarkbeind2000.blogspot.com

Source: https://www.ablebits.com/office-addins-blog/2018/08/22/customize-stop-autocorrect-excel/