Microsoft Excel – Add new rows the easy way

In this tutorial we will be going through the adding of new rows to an Excel spreadsheet. This task often takes a lot longer than it should, find out how to carry this out efficiently in the steps below.

1. Highlight a selection of the rows where you are wanting to add new rows.
2. Once highlighted, hold down the ‘Shift’ key on your keyboard.
3. Whilst holding down the ‘Shift’ key drag the fill handle up or down by however many new columns you are wanting to add.
4. Once you release the fill handle your new rows will appear. Voilà!