Excel blank row (column) insert and row copy

In daily work, you sometimes need to enter a list of Excel worksheets interlace (column) insert some blank rows or columns, such as the payroll data into the payroll must be done first, if a row (or a column) of the insertion, is very troublesome, you may use the Excel formula and function to try.

Suppose you have a payroll table as shown in Figure 1.

Figure 1

1. Insert a blank row (column) in a list of rows (columns)

Change the Insert blank row worksheet to the current worksheet, click A1 Cell, and enter the formula =if (MOD (ROW (), 2) =0, "", OFFSET (Payroll!). $A $1,int (ROW ()/2), COLUMN ()-1) ", select A1, Drag the fill handle to the right level to fill the data, and then drag the fill handle down until all the data appears to complete the alternate insertion of a blank row (and, of course, fill it down and then right), as shown in Figure 2. It. Phontol.com for the same reason, enter a formula in A1 on the Insert Empty column worksheet: =if (MOD (column (), 2) =0, "", OFFSET (Payroll! $A $1,row () -1,int (COLUMN ()/2))) ", Padding to the right and then to complete the column insert empty column, as shown in Figure 3.

Figure 2

Figure 3