A quick way to insert six rows at once in Excel

Subscriber Barb K. asks “When I need to insert lines in an Excel spreadsheet, I am doing it one line at a time. Is there an easier way to insert six rows at a time?”

Yes there is, although I find people often don’t discover this useful shortcut.  Simply select the six rows then right-click on the highlighted rows and select Insert.

Note that if the rows you want to add are not adjacent in the worksheet, you can select the first row then press and hold CTRL as you click on additional row headers.  With the non-adjacent rows selected, right-click on any of them and select Insert. Excel inserts a row above each of the rows you had selected.

Any questions, please let me know.