In Microsoft Excel, there are a number of features that users can take advantage of to make using the spreadsheet application easy. AutoCorrect and AutoComplete are examples of these features. In an application that focuses on numbers like Excel, it can be easy to overlook that sometimes text may be needed for naming or formulating. Therefore, features such as AutoCorrect and AutoComplete ensure the accuracy of the text is very important.
While both features are related to ensuring text accuracy, they should not be confused with each other. Both features serve different purposes and to understand their differences and usage read below.
What is AutoCorrect in Microsoft Excel
When you type in Microsoft Excel, you may mistype some words. Unlike Microsoft Word, Excel won’t make it easy for you to identify this error by underlining it in red or blue. As such, unless spell checking is performed later or you detect errors manually, these errors can be ignored. One way to prevent errors is through the use of AutoCorrect.
The AutoCorrect feature helps correct typos, typos, and capitalization as you type. In Excel, the AutoCorrect feature has a standard list of misspelled words and symbols that it uses to correct errors. Users can also add to this list. Here’s how to enable AutoCorrect in Microsoft Excel.
How to Enable AutoCorrect in Microsoft Excel
To manage the AutoCorrect feature in Microsoft Excel, you should do the following:
Step 1: Click the Start button on the Taskbar and type outstanding to search for apps.
Step 2: From the results, click on the Microsoft Excel document or application to open it.
Step 3: On the Microsoft Ribbon, click the File tab.
Step 4: In the File screen, click the More Options tab to launch the Excel Options dialog box.
Step 5: In the Excel Options dialog box, click the Proofing menu.
Step 6: On the Proofing page, click the AutoCorrect Options button to launch the AutoCorrect Options dialog box.
Step 7: To make sure AutoCorrect works as you type in Excel, check the following boxes:
- Correct TWO FULL CAPTCHAs
- Capitalize the first letter of a sentence
- Capitalize the name of the day
- Fix accidental use of cAPS LOCK . key
- Replace text as you type
For the Replace text as you type option, there is a table after the option where you can view the different alternatives. You can add to this list by typing in the Replace and With boxes.
Step 8: Click OK to save your changes and close the dialog box.
What is AutoComplete in Microsoft Excel?
If you have repeated instances of certain words in your Excel file, you can have Excel complete these words as you type them. This is the function of the AutoComplete feature in Excel. Microsoft Excel will complete the text entries you start typing in a column if the first few letters match an entry that already exists in that column.
How to enable AutoComplete in Microsoft Excel
Here’s how to enable AutoComplete in Microsoft Excel:
Step 1: Click the Start button on the Taskbar and type outstanding to search for apps.
Step 2: From the results, click on the Microsoft Excel document or application to open it.
Step 3: On the Microsoft Ribbon, click the File tab.
Step 4: In the File screen, click the More Options tab to launch the Excel Options dialog box.
Step 5: In the Excel Options dialog box, click the Advanced menu in the left sidebar.
Step 6: Scroll down to the Editing options section in the right pane and check the box next to ‘Enable AutoFill for cell values.’
Step 7: Check the box next to Flash Fill.
Flash Fill automatically fills your data when it senses a pattern. For example, separate first and last names with commas. Excel should easily replicate this using flash fill.
Step 8: Click OK to save your changes and close the dialog window.
Split text or data in Microsoft Excel
If you want to save time when performing data entry tasks in Excel, Flash Fill is an important function to enable when managing your AutoFill settings. However, Flash Fill is just one example of how you can copy data or split text in Microsoft Excel. Other methods include using the Excel Separator function and even Power Query.
Categories: How to
Source: thpttranhungdao.edu.vn/en/
