If you don’t have the numeric keypad, press Control and Shift and plus key (+) on the regular keyboard.Once the entire row is selected, press Control and hit the plus key (+) from the numeric keypad.You can also select the entire row by simply clicking on the row number on the extreme left.Press Shift + Space-bar to select the entire row.Select the cell above which you want to insert multiple rows in Excel.You can insert multiple rows in Excel using more than one keyboard shortcut. In this tutorial, you’ll learn four different ways to do insert multiple rows in Excel. For example, you may want to insert a single row, or multiple rows that are all together, or multiple rows that are not together. Now there could be various situations where you need to insert rows in Excel. Inserting rows in Excel is one of the most basic stuff that we do almost everyday.
0 Comments
Leave a Reply. |