Select the row directly under the area you want to add a new row. Either 1.
right click the selected row and then select "insert" or 2. after selecting
the row goto insert>rows. This is for xl03 or older for xl07 maybe some one
that speaks 07 will instruct you.
Select the row number where you want to insert the row and press Ctrl++
(control plus).
You can't insert a row through a pivot table, not if the spreadsheet is
protected (in most cases).
If you are getting an error message after you try our suggestions, quote the
error message for us.
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.