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!

4 ★ | 1 Vote

May be interested

  • Limit input values ​​using Data Validation in ExcelPhoto of Limit input values ​​using Data Validation in Excel
    to avoid data confusion, you should set a limit for the column of data cells to minimize the consequences of confusion. the following article will guide you in detail how to limit the value entered by data validation in excel.
  • Create and use animation effects in PowerPointPhoto of Create and use animation effects in PowerPoint
    create and use animation effects in powerpoint. step 1: to create the effect you first need to create a background for the animated object:
  • Insert and edit mathematical expressions in WordPhoto of Insert and edit mathematical expressions in Word
    introduce how to insert and edit mathematical expressions in word. step 1: go to insert - text - equation tab - select the mathematical expression to create.
  • Insert and edit flowcharts in WordPhoto of Insert and edit flowcharts in Word
    introduce how to insert and edit flowcharts in word. to insert a flowchart in the text, do the following: step 1: go to the insert - illustrator - smartart tab: step 2: the choose a smartart graphic dialog box appears - select the flow chart type - click ok.
  • Manipulating tables in WordPhoto of Manipulating tables in Word
    introduction to creating tables in word to create a table in word 2013, there are the following ways: method 1: put the mouse at the position where you want to insert the table - insert - table - move the mouse to select the number of rows and columns as shown: - the results have been created table - edit edit and enter n
  • Format borders and should be for tables in WordPhoto of Format borders and should be for tables in Word
    introducing the outline format and recommended for tables in word. - you can quickly format the borders and background colors for the table by clicking design - selecting the patterns that match your data content.