Want to read more answers from other tech-savvy Stack Exchange users? Check out the full discussion thread here.
Have something to add to the explanation? Sound off in the comments.
(*) The Keyboard Right-Click Key looks like this: Keyboard Right-Click Key + I to insert a row.Shift + Space to select the current row.If you format your spreadsheet as a table, you do not even need to worry about copying your formulas. 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. You can type Alt, then I, then R and get the same effect. It is worth noting that this is a sequence, not necessarily keys to be pressed simultaneously ( see answer from ATG above). On personal computers, use the Keyboard Right-Click Key to emulate a right-click on the current selection.Īdditional note from ATG: Substituting C for R will insert a new column. Press Alt + I ( Insert), then press R ( Row). The following keyboard shortcut will insert one row above the active cell’s row: 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. Hit Enter to accept the default of Shift Cells Down.Go to the Home tab in Excel and click on the Insert icon. You'll see the number of the highlighted rows next to the last button. You can also select entire lines using the row number buttons.
With a single cell selected, hit Control + Shift + + ( Plus Sign) to insert a row. To do this, select the destination cells and use the Shift + Space shortcut to turn them into rows.Hit Control + Shift + + ( Plus Sign) to insert a row above the current row.With a single cell selected, hit Shift + Space to select the row.There are two options that I am aware of and both (unfortunately) require two steps. SuperUser contributors jstricker, ATG, KRyan, BillOer, and assylias have the answer for us. Is there an easy way to insert new rows in Excel using a keyboard? The Answer 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. I would rather not have to take my hands off the keyboard. Right-clicking on a row and selecting insert is fairly time consuming.
This key inserts a pivot chart into the existing sheet.SuperUser reader jstricker wants to know how to insert new rows in Excel using a keyboard instead of a mouse: To use this keyboard shortcut, you need to select a cell from the pivot table. (Bonus) Insert a Pivot Chart from a Pivot Table In this keyboard shortcut, you need to press the keys subsequently. Actually, it doesn’t hide the cell but filters them which you can clear after that from the filters options. Note: in Mac Excel 365, you can also use Control + T to convert a range to a table. To use this shortcut, first select the range of data you want to convert. This shortcut key will simply hide the selected cell or cells. This shortcut converts a range to an Excel Table. Just like you can create a group of items, this shortcut helps you ungroup those items from the group. All you need to do it select those six cells and use this shortcut key simply. Let say you have a pivot table with months and you want to group the first six or last six months. And if you are using the Excel 2007 version then you can use the Alt + N + V + T instead of this. To use this shortcut key make sure you have selected the source data or the active cell is from the source data.