microsoft+excel+training - Rows/columns in excel

Hi Joanna

Thank you for your question.

When you say 'enter multiple rows or columns' I am assuming you mean to insert more than one row or column at a time.

As an example, say you want to enter four rows above row 9 in your spreadsheet:

1. Select rows 9, 10, 11 and 12 (4 rows)
2. Right-click on top of your selection and choose Insert. This should insert 4 rows for you above row 9.

You can do the same thing with columns, you just need to select the number of columns you wish to insert, to the right of the point where you want them to appear in the spreadsheet. For example, selecting columns A and B then using the method above will insert two columns to the left of column A.

Amanda