Home  >  Article  >  Topics  >  How to insert rows at intervals in batches in excel

How to insert rows at intervals in batches in excel

coldplay.xixi
coldplay.xixiOriginal
2021-01-04 16:17:4554858browse

How to insert rows at intervals in excel: First, right-click to open the table in Excel; then select a row and press Ctrl, and continue to left-click to select other rows; finally, after selecting the row, right-click and select Just plug it in.

How to insert rows at intervals in batches in excel

The operating environment of this article: Windows 7 system, Microsoft Office Excel 2010 version, Dell G3 computer.

How to insert rows at intervals in excel:

1. First, right-click to open the table in Excel.

How to insert rows at intervals in batches in excel

#2. Press Ctrl after selecting a row, and continue left-clicking to select other rows.

How to insert rows at intervals in batches in excel

#3. After selecting the row, right-click and select Insert.

How to insert rows at intervals in batches in excel

#4. According to the above steps, you can insert rows at intervals in batches in Excel.

How to insert rows at intervals in batches in excel

Related learning recommendations: excel tutorial

The above is the detailed content of How to insert rows at intervals in batches in excel. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn