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 |