How to handle "Missing data" in Excel tables

When we enter data into spreadsheet Excel, it sometimes takes place at the end of a row or column, but found that the front less input one or two data, resulting in the entire row or column of data and the row or column in front of the corresponding relationship dislocation, such as the omission of the Mengqing English score is 109, but recorded as Zhang Jie's achievement 106, And Zhang Jie's score is 106, but recorded as a Wang fan of the results of 105 .... (Figure 1) When this happens, if only a few data we can be directly from the new input, but if it is dozens of, hundreds of and the data is more complex, you need to think of other ways to solve.

Figure 1: Missing input column

1. Right-click the E3 cell (106 points), left click Insert, select Move cell down in the Open Insert dialog box, and then click OK to empty the E3 cell, and its original data is pushed to the E4 cell ... and then it's all over. In which we directly input Mengqing's English score 109 on the line. (Figure 2)

Figure 2: Click "Move Cell Down"

2, select the E3 cell (106) to the E14 cell, and then point to the top border of the selected area (the left and right borders are OK, but it's not easy to find the drag position), and when the mouse pointer changes to four to move the arrow down, drag down to the E4 cell and let go. So the entire selection is moved down a cell, the missing data of the E3 cell to empty out, we in which directly enter Mengqing's English score 109 on the line. (Figure 3)

Figure 3: Direct input of Mengqing English results can be

3, enter the Mengqing score 109 in a cell outside the table data region, and then hold down one SHIFT key, then point to 109 on any border of the cell, and the mouse pointer changes to four when you move the arrow and hold down the left mouse button and drag to the E3 cell. Let go when a dashed capital letter H appears on the top border of the E3 cell. This inserts 109 of the data into the E3 cell, and moves it down one cell, along with the column of data that starts at cell E4. (Figure 4)

Figure 4: Final effect

How, the three "regret medicine" is not worth a buy.

Note : More wonderful tutorials Please pay attention to the triple Office software tutorial section, triple Computer office group: 189034526 welcome you to join