Entering row in Excel - error

mihaelamanaila1 · 05 Jan 2018

Hello all,

So I'm trying to put together a table in Excel which i managed to do, however I need insert 3 lines at the top of the table(above the head of the tabel), but Excel won't allow it. Is anybody familiar with this sort of error? I've been browsing online but couldn't get a clear answer. Please find attachment to see what is says in the pop-up

Many thanks
Mihaela

Word Man · 05 Jan 2018

How many rows of the spreadsheet are you using? If every row has something in it, then you can't have any more rows. My version of Excel has 1,048,576 rows in a spreadsheet and I've never filled one.

If you go to the last row you think you are using and delete every row below that (if there are any), you should then be able to insert rows at the top.

Which version of Excel are you in? I think Excel 2003 and earlier only had 65536 rows available.

Bree · 05 Jan 2018

Word Man said:

If you go to the last row you think you are using...

In Excel the Ctrl+End key combination will take you to the last cell in the last row that you are actually using. You may have inadvertently put something in a row far beyond what you think you are using.