Unable to insert a new row in Excel 2007

Hi please see attachment i keep getting this error message when i try to insert a new line.

Aany ideas

thank you
error.doc
happyexchangeAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
andrewssd3Connect With a Mentor Commented:
Did this help you?
0
 
andrewssd3Commented:
Excel thinks you have data in all the rows in your workbook.  If you do what the message says and press ctrl-End, you will probably find yourself on the last row.  This can happen for various reasons - you might actually have a value on the last line, or Excel might not have readjusted its used range properly, which can be caused by formatting.  In either case, select all the rows from the real end of your data to the bottom of the workbook, and delete them - don't Clear the contents, actually delete the rows by right clicking and selecting Delete.

This should give you space to insert rows.
0
 
andrewssd3Commented:
Where I have said 'workbook' above I obviously mean 'worksheet' - brain not working too well this afternoon, I fear
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.