Quickly add Excel blank lines to make the table more refreshing

When we are dealing with the table, if the dense line into a piece, it is very inconvenient to watch. Adding a blank row to a table can certainly make the table more refreshing, with the traditional method of using the CTRL key to click the Row button, and then clicking the "Insert" command on the shortcut menu to add it, but if you're working with thousands of tables, you need a more efficient way to do that. Now let's do it together.

1. Add Secondary column cells

The most efficient way to quickly add an empty row is by using a secondary column cell, finding an empty column outside the data area, and then randomly entering a number in the first cell, such as the number "1." Empty the cell below "1". Then select the two cells, hold down the CTRL key, and drag the fill handle down to fill until the table needs to add the end of the blank line.

　　

2. Edit settings for secondary columns

After the secondary column is pulled down to the end, stay selected, and then leave the selection at this point, select Edit → position in the toolbar, open the Position dialog box, select the position criteria feature item, and then change the setting in the???

　　

3. Select entire row in the Insert command

When you have finished setting, click on the confirmation key, the empty cell in the original selection area will be selected. When you right-click on the selected cell, select Insert, select Entire row in the feature, and when you click OK, Excel automatically adds a blank line to each blank line in the secondary column.

　　

4. Select Constants to add all the blank rows of the content

Select all the cells that you have manipulated, and then in the toolbar, perform edit → position, open the Locate dialog box, select Position criteria, and select constants in the Locate Criteria dialog box. The "1" cell in the original selection will be selected after "OK". At this point, right-click on the selected cell, select Insert, and then select Entire row in the dialog box, and after OK, add a blank line on each row of the selected cell. At the end of the production, remove the secondary column that you added earlier, and the blank line is all done.