Entering row in Excel - error


  1. Posts : 5
    Windows 10 Home
       #1

    Entering row in Excel - error


    Entering row in Excel - error-excelrow.png

    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
      My Computer


  2. Posts : 1,567
    Windows 10 Pro
       #2

    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.
      My Computer


  3. Posts : 25,075
    10 Home x64 (21H2) (10 Pro on 2nd pc)
       #3

    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.
      My Computers


 

  Related Discussions
Our Sites
Site Links
About Us
Windows 10 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 10" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd
All times are GMT -5. The time now is 14:34.
Find Us




Windows 10 Forums