Multiple rows will be inserted as shown below.įigure 14. The Office access key message will pop-up. Press the “Alt” key on the keyboard, followed by the letter “I”. Selecting rows where to insert multiple rows We will learn three keyboard shortcuts to insert multiple rows :įigure 12. Output: Insert multiple rows through copied cells Keyboard shortcuts to insert multiple rows The copied empty row will be inserted in rows 6 to 8.įigure 11. Right-click and select Insert Copied Cells. Select the rows where we want to insert multiple rows (rows 6 to 8). Select a blank row (row 10) and press Ctrl + C to copy the rowįigure 9. Output: Insert entire rows Insert copied cells to insert multiple rowsĪnother option is to copy a blank row and paste it anywhere in the worksheet. Ticking Entire row in menu optionsįigure 8. Select Entire row in order to insert multiple rows.įigure 7. When we click Insert, Excel will ask us to choose from four options. Suppose we only selected cells B7 and B8, and not the entire rows. Output: Insert multiple rows using menu options Select a few cells only and insert multiple rows The data originally in row 7 will now be in row 9 and two blank rows are inserted above it.įigure 5. Selecting rows where to insert multiple rowsįigure 4. Sample data to insert multiple rows Select and insert multiple rowsįigure 3. Suppose we want to insert two rows above row 7, we follow these steps:įigure 2. Note that Excel will insert rows above the rows that we select. Final result: How to insert multiple rows Menu options to insert multiple rows This article teaches us four different ways to insert multiple rows :įigure 1. One of the most basic functions we perform in Excel is inserting multiple rows, either to accommodate additional information or change the layout of our table.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |