Tricks to Import Data in Excel Fastest

This article provides a clear overview of Tricks to Import Data in Excel Fastest, with the main facts, useful context, and practical details organized for easy reading.

this guide 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 may need 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 may need to enter the number string vertically and enter the first two values horizontally if you may need 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 may need to enter in the direction you entered the first two values.

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

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.

Enter Complex Series of Numbers

In addition to entering basic numbers and dates you can enter more complex series. If you may need 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.

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

So you quickly entered the exponential series.

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 .

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

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

Enter Data Via the Form

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

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 .

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.