![]() ![]() 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.With a single cell selected, hit Control + Shift + + ( Plus Sign) to insert a row.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. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |