如果你是一个键盘忍者，那么你讨厌以任何理由把你的手从键盘上移开，除非没有其他选择。今天的超级用户问答帖子提供了多种方法来帮助沮丧的读者在使用microsoftexcel时双手放在键盘上。

今天的问答环节是由SuperUser提供的，SuperUser是Stack Exchange的一个分支，是一个由社区驱动的问答网站分组。

问题

超级用户读者jstricker想知道如何使用键盘而不是鼠标在Excel中**新行：

Right-clicking on a row and selecting insert is fairly time c***uming. I would rather not have to take my hands off the keyboard. How can I insert a new row above my current row using only the keyboard? I am primarily interested in inserting a single row at a time, but would also be interested in answers that address inserting multiple rows at a time.

有没有一种简单的方法可以使用键盘在Excel中**新行？

答案

超级用户贡献者jstricker、ATG、KRyan、BillOer和assylias为我们提供了答案。首先，jstricker：

There are two opti*** that I am aware of and both (unfortunately) require two steps.

Option 1

1. With a single cell selected, hit Shift + Space to select the row.
2. Hit Control + Shift + + (Plus Sign) to insert a row above the current row.

Option 2

1. With a single cell selected, hit Control + Shift + + (Plus Sign) to insert a row.
2. Hit Enter to accept the default of Shift Cells Down.

If inserting many rows at once, I think the first option is the best since you can repeat the second step without having to re-select the row.

接下来是ATG的回答：

The following keyboard shortcut will insert one row above the active cell’s row:

Press Alt + I (Insert), then press R (Row).

On personal computers, use the Keyboard Right-Click Key to emulate a right-click on the current selection.

Additional note from ATG: Substituting C for R will insert a new column.

克鲁恩的回答是：

It is worth noting that this is a sequence, not necessarily keys to be pressed simultaneously (see answer from ATG above). You can type Alt, then I, then R and get the same effect.

接着是比洛尔的回答：

You can also select multiple rows and then right-click to insert rows, or you can insert one row and then use Ctrl + Y as many times as you need to insert rows. If you format your spreadsheet as a table, you do not even need to worry about copying your formulas.

亚西莉亚最后的回答是：

On Windows I use:

1. Shift + Space to select the current row.
2. Keyboard Right-Click Key + I to insert a row.

(*) The Keyboard Right-Click Key looks like this:

有什么要补充的解释吗？在评论中发出声音。想从其他精通技术的Stack Exchange用户那里了解更多答案吗？在这里查看完整的讨论主题。