excel tip

Add More Than One New Row Or Column

As you build and add to your spreadsheet, it’s essential to be able to add multiple rows or columns at once rather than going the manual route. To start, pick the area where you want to add a new batch of rows or columns, then click and drag the highlight over the number of lines you want to add (e.g., highlight seven rows to add seven). Right-click and choose “Insert” from the drop down menu to insert rows above the row or to the left of the column you selected.