excel 多行插入_在Excel中插入多行

最新推荐文章于 2022-07-06 10:34:04 发布

culiao2169

最新推荐文章于 2022-07-06 10:34:04 发布

阅读量1.2k

点赞数

文章标签：列表 excel vba .net 开发工具

原文链接：https://contexturesblog.com/archives/2010/07/14/insert-more-than-one-row-in-excel/

版权

excel 多行插入

If you've used Excel for a while, you have lots of skills that you might assume everyone else shares. For example, you probably know how to insert more than one row in Excel, without adding them one at a time. If not, here's how to do that.

如果您使用Excel已有一段时间，那么您可能会假设其他所有人都有很多技能。例如，您可能知道如何在Excel中插入多个行，而不一次添加一个行。如果没有，请按照以下步骤操作。

Excel问题 (Excel Question)

Lots of us are self-taught in Excel, and might have missed learning a shortcut or two. Recently, I saw this plea on Twitter:

我们中的许多人都是在Excel中自学成才，可能错过了学习一两个快捷键的机会。最近，我在Twitter上看到了这个请求：

Can anyone help pls? can't work out how to add a LOT of new rows in Excel between existing data, rather than 1 at a time – ?? Many thanks!

谁能帮忙？不能解决如何在Excel中的现有数据之间添加很多新行，而不是一次添加1条？非常感谢！

For that person, and anyone else who needs to know, here's the solution.

对于那个人，以及任何其他需要知道的人，这就是解决方案。

使用鼠标快捷方式插入单行 (Insert a Single Row with a Mouse Shortcut)

You can quickly insert a single row in Excel by using a mouse shortcut.

您可以使用鼠标快捷方式在Excel中快速插入一行。

Right-click on the row button, in the row below the point where you want the new row inserted. For example, if you want a blank row added between rows 3 and 4, right-click on the row 4 button.
右键单击要插入新行的点下方的行中的行按钮。例如，如果要在第3行和第4行之间添加空白行，请右键单击第4行按钮。
Then, in the pop-up menu, click Insert
然后，在弹出菜单中，单击“插入”。

用鼠标快捷键插入行 (Insert Rows with Mouse Shortcut)

You're not limited to adding one row at a time -- you can quickly add multiple rows in Excel by using a mouse shortcut.

您不仅限于一次添加一行，还可以使用鼠标快捷键在Excel中快速添加多行。

Firstly, drag over several row buttons, to select the same number of rows that you want to add. For example, select rows 4 to 7, if you want to add 4 blank rows above row 4
首先，拖移几个行按钮，以选择要添加的相同行数。例如，如果要在第4行上方添加4个空白行，请选择第4至7行
Secondly, as you drag, a pop-up (highlighted in green below) will show the number of rows currently selected.
其次，当您拖动鼠标时，一个弹出窗口(下面以绿色突出显示)将显示当前选定的行数。

Then, after you select the number of row that you want to add, right-click on a row button, for one of the selected rows.
然后，在选择了要添加的行数之后，右键单击行按钮以找到所选行之一。
Finally, in the pop-up menu, click Insert
最后，在弹出菜单中，单击“插入”。