Tricks to import data in Excel fastest

Frequently use Excel to enter data, calculate and process data. If you enter data faster, the time spent on calculating and processing data will be more. There are many faster ways to import Excel data that you can use.

Frequently use Excel to enter data, calculate and process data. If you enter data faster, the time spent on calculating and processing data will be more. There are many faster ways to import Excel data that you can use.

The following article shows you some ways to import Excel data faster.

Enter the basic numbers

To enter the basic series faster, you need to enter the first 2 numbers in the series, for example, if you want to enter the number string from 1 to 10, separated by 1 unit, then you enter the first 2 values ​​as 1 and the next value is 2. You can also enter the sequence of numbers quickly 2 units, 3 units . for example 1 3 5 7 9 . or 2 4 6 8 . then you enter two prices Input values ​​2 consecutive cells. You enter the first two value boxes vertically if you want to enter the number string vertically and enter the first two values ​​horizontally if you want to enter the number string horizontally.

Then you select the two cells that have entered the value, move the mouse cursor to the lower right corner so the mouse pointer changes to a control button (plus sign). Hold down the left mouse button and drag the mouse pointer to the end of the cell you want to enter in the direction you entered the first two values.

Picture 1 of Tricks to import data in Excel fastest

When you release the mouse pointer, you will get the desired sequence of numbers.

Picture 2 of Tricks to import data in Excel fastest

Enter the date

Not only do you enter fast basic numbers, you can also enter consecutive numbers of the date quickly.

First, you enter the date in the first box, then you also drag the fill control button to the data fields to enter. Now the date value will change, you can click Auto Fill Options to choose to fill data by month or year instead of the default date.

Picture 3 of Tricks to import data in Excel fastest

Enter complex series of numbers

In addition to entering basic numbers and dates you can enter more complex series. If you want to enter an exponential string, then do the following:

First, you enter the first number in the series, select the first number box and move the mouse pointer to the lower right corner of the cell, right click and drag the control button down or to the side depending on how you enter the sequence of friend. After you drag all the boxes you need to enter, right-click, and a menu select Series to open the Series dialog box .

Picture 4 of Tricks to import data in Excel fastest

In the Series dialog box , select Growth in the Type section and enter the multiplier in the Step Value box . Then click OK .

Picture 5 of Tricks to import data in Excel fastest

So you quickly entered the exponential series.

Picture 6 of Tricks to import data in Excel fastest

Quick data entry with drop down list

When you use the drop-down list, instead of entering data for each cell in a field, you can quickly select the data from the drop-down list.

First, you need to create a drop down list to use it, select the data cells to create a drop down list and select the Data tab -> Data Validation .

Picture 7 of Tricks to import data in Excel fastest

Data Validation dialog box appears in the Settings tab, select List in Allow and enter the content you want to appear in the drop down list, each content is separated by commas and then click OK to create.

Picture 8 of Tricks to import data in Excel fastest

So you will not have to enter data in the cell containing the drop down list, but click on the triangle next to the cell to quickly select the data.

Picture 9 of Tricks to import data in Excel fastest

Enter data via the Form

First, you need to display the Form button on the Quick Access Toolbar . You can right-click on the Quick Access Toolbar and choose Customize Quick Access Toolbar .

Picture 10 of Tricks to import data in Excel fastest

The Quick Access Toolbar appears in the Excel Options dialog box , select Commands Not in the Ribbon in the Choose commands from section . Then select the form in the list below and click Add -> OK to add it to the Quick Access Toolbar .

Picture 11 of Tricks to import data in Excel fastest

So, you just need to select the area to enter data and select the Form button, the Form table will appear. You can select New and enter data then press Criteria to add data to the table. You will not need to spend a lot of time when entering data in a table space with a lot of data.

Picture 12 of Tricks to import data in Excel fastest

Hopefully, with some quick ways of importing Excel data, this tutorial will help you in the process of importing, calculating and processing data in Excel.

Good luck!

Update 19 May 2020
Category

System

Mac OS X

Hardware

Game

Tech info

Technology

Science

Life

Application

Electric

Program

Mobile