Excel blank row (column) insert and row copy

Source: Internet
Author: User

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.