This is because Excel inserts the same number of rows as the initial rows selected.Įxample #4–Insert Multiple Rows Using “Ctrl+Plus Sign (+)” or “Ctrl+Shift+Plus Sign (+)” For inserting multiple rows, one must know beforehand the number of rows to be inserted. Let us consider an example to understand the insertion of multiple rows Insertion Of Multiple Rows The top four methods to insert multiple rows are in excel are - Using INSERT Option, Using shortcut Key - shift + space bar, Copy & Paste Method, Using the Name Box. #Excel hotkey insert row how to#How to Insert Multiple Rows Using a Shortcut Key? It works only in the modern versions of Excel. Note: The shortcut “ALT+I+R” does not work in all the versions of Excel. With this insertion, the entries of the initial row 6 shift to row 7. A blank row 6 is inserted, as shown in the following image. Step 2: Press the keys “ALT+I+R” to insert a new row. Alternatively, one can select the entire row 6 with the help of “Shift+spacebar.” We have selected cell A6, as shown in the following image. The steps to insert a row with the shortcut “Alt+I+R” are listed as follows: Working on the data of example #1, we want to insert a new row 6 with the shortcut “Alt+I+R.” Since we want to insert excel row 6, we select the option “entire row.” A new, blank row 6 is inserted, as shown in the following image. Entire column: This inserts a new column to the immediate left of the selected cell (selected in step 1).Entire row: This inserts a new row preceding the row of the selected cell (selected in step 1).Shift cells down: This shifts the content of the selected cell (selected in step 1) to the immediately following cell. Shift cells right: This shifts the content of the selected cell (selected in step 1) to the cell on the immediate right.Step 2: The “insert” dialog box displays the following options: However, if a row is selected, these shortcuts insert a new row directly. Note 2: If a cell is selected prior to pressing the preceding shortcuts (entered in step 1), the “insert” dialog box is displayed. The shortcut “Ctrl+Shift+plus sign (+)” works on all the regular keyboards. Note 1: The shortcut “Ctrl+plus sign (+)” works with keyboards having a numeric pad on the right side. The succeeding image shows the result of using the former shortcut. The “insert” dialog box opens with both these shortcuts. Press the keys “Ctrl+plus sign (+)” or “Ctrl+Shift+plus sign (+).” The keys of each shortcut must be pressed together. The steps to insert a row with the “insert” dialog box are listed as follows: Working on the data of example #1, we want to insert a new row 6 with the “insert” dialog box. Use the format painter icon from the “clipboard” group of the Home tab of Excel.Įxample #2–Insert a Row Using the “Insert” Dialog Box.Select the newly inserted row, right-click and select “format cells” from the context menu. In case it does not appear, one can format the newly inserted row in either of the following ways: Note: The paintbrush icon may not appear each time a new row is inserted. Based on this selection, the newly inserted row (row 6) is formatted. One can select any of the preceding styles. Clear formatting: This removes the formatting of row 6.Format same as below: This applies the formatting of the immediately following row (row 7) to row 6.Format same as above: This applies the formatting of the immediately preceding row (row 5) to row 6.The formatting styles displayed are explained as follows: Thereafter, click the drop-down arrow, as shown in the succeeding image. To format the new row 6, hover the mouse over the paintbrush icon.Moreover, a paintbrush icon appears immediately below the newly inserted row (row 6). With the insertion of the new row 6, the entries of the initial row 6 are shifted downwards to row 7. This new row is shown in the following image. A blank row 6 is inserted with both the preceding shortcuts (entered in step 2).Note 2: The shortcut “Ctrl+Shift+plus sign (+)” works on devices which do not have a separate numeric keypad. #Excel hotkey insert row plus#For this shortcut to work, press the “Ctrl” key from the regular keyboard and the plus sign (+) from the number pad. Note 1: The shortcut “Ctrl+plus sign (+)” works only on those devices which have a numeric keypad (number pad) to the right of a regular keyboard. In the succeeding image, we have applied the former shortcut.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |