To select multiple items in a group in Excel hold Ctrl then select each item in the group. You can also select from multiple groups by holding Ctrl as you click.

How to insert multiple rows in Excel. 1. Select the row below where you want the new rows to appear. 2. Right-click on the highlighted row, and then click Insert in the context menu.

If you wish to search the entire spreadsheet, do not select multiple cells. Hold the "Ctrl" key and press "F" to open the Find tab in the Find and Replace window. Enter the text you wish to find ...

Either way, Excel inserts a row above the current row or cell. To insert multiple rows, select multiple rows before inserting. For every selected row, Excel will insert a new row.