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.
- Highlight a selection of the rows where you are wanting to add new rows.
- Once highlighted, hold down the ‘Shift’ key on your keyboard.
- Whilst holding down the ‘Shift’ key drag the fill handle up or down by however many new columns you are wanting to add.
- Once you release the fill handle your new rows will appear. Voilà!