How to speed up input in Excel
To perform the calculation in Excel, the first thing you need to do is input the worksheet. This job does not require much intelligence but requires high input speed. The following article will guide you in detail how to accelerate input in Excel
To speed up your input, you can use abbreviations instead of what you need to type. Choose words, phrases that appear frequently or how often you use them to replace them with abbreviations, which speeds up your input a lot.
Step 1: On the card File -> select Option:
How to speed up input in Excel Picture 1
Step 2: A dialog box appears showing Proofing -> AutoCorrect Options .
How to speed up input in Excel Picture 2
Step 3: The AutoCorrect English dialog box appears. Enter a replacement phrase for the content that should be presented in the replace section , the phrase needs to be displayed in the Width section . For example, you want to enter the word ttpm instead of the phrase to display TipsMake.com. Next, click Add:
How to speed up input in Excel Picture 3
Step 4: Cum the acronym is added to the list -> click OK:
How to speed up input in Excel Picture 4
Return to the spreadsheet, enter the abbreviation:
How to speed up input in Excel Picture 5
Pressing the Enter key results in:
How to speed up input in Excel Picture 6
To delete abbreviations, click the phrase to delete -> Delete:
How to speed up input in Excel Picture 7
Above is a detailed guide on how to speed up input in Excel, hoping to help you. Good luck!
You should read it
- Instructions on how to create input forms in Excel extremely fast and simple
- How to turn off content suggestions on Excel
- How to number columns automatically in Excel
- The input () function in Python
- Learn Google Input Tools, download Google Input Tools (Version 10.1.0.3)
- Limit input values using Data Validation in Excel
- How to fix Excel file is slow, speed up processing for Excel file
- How to format dates in Excel
- How to create an Excel formula in Notepad ++
- How to indent the line in Excel
- How to insert text into images in Excel
- MS Excel 2007 - Lesson 7: Create Macros in Excel 2007