![]() ![]() We will select the entire row as shown in the picture below. Like before we will select row 7 using the left most number denoting the row number or selecting any cell in that row and pressing SHIFT + Spacebar. Method 3: Insert a New Row Using CTRL + SHIFT + Plus(+)Īgain we want to insert a new row above row 7. ![]() Here, we will get 3 new rows above row 7. Suppose we want to insert 3 new rows above row 7. Then press ALT + I + R to insert new rows above. If you want to insert multiple rows you will need to select the same number of rows. Method 2: Insert Multiple New Rows Using ALT + I + R Then press ALT + I + R to insert a new row above. Pressing SHIFT + Spacebar while B7 cell is activated will select the entire row 7. Pressing SHIFT + Spacebar will select the row of the active cell. Or you can use the keyboard shortcut SHIFT + Spacebar. You can do this by clicking the left most side number denoting the row. Method 1: Insert a New Row in Excel Using ALT + I + Rįirst, select the row above which you want to enter the new row. He will need to insert the new row between row 6 and row 7. Suppose, he has made an additional sale on the 26th of January which he forgot to insert. He will need to insert a new row to the record. Suppose, the shop owner has mistakenly forgotten to make an entry and he wishes to make it now. Methods to Insert Rows Using Shortcut.xlsmĦ Quick Methods to Insert a New Row in Excel ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |