Windows 10: Entering row in Excel - error

Discus and support Entering row in Excel - error in Microsoft Office and 365 to solve the problem; [img] 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... Discussion in 'Microsoft Office and 365' started by mihaelamanaila1, Jan 4, 2018.

  1. Entering row in Excel - error


    Entering row in Excel - error [​IMG]


    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

    :)
     
    mihaelamanaila1, Jan 4, 2018
    #1

  2. not able to edit office documents (word/excel/ppt) in HTC mozart

    So I checked the file you supplied and get the same error Robert. It seems to me that the issue exists because of the formulas used in lines 26 and 48. There is an issue with the =SUMPRODUCT formula.

    If you delete those two rows and save the document it becomes editable. I am not an excel aficionado so I can't help you with the error but I am sure you can figure it out.

    Keep in mind that you are using a mobile version of excel and as such it may not have the capability of dealing with =SUMPRODUCT formula ... but then it might so give it a try.

    Try deleting those two rows and your document should become editable. Now fix the parameters entered in the formulas and possibility it might well work Robert.
     
    Jack Cook - aka Help_Line, Jan 4, 2018
    #2
  3. alan93 Win User
    Why does an Excel doc on sky drive not show all of the rows?

    I have an excel doc on my sky drive that has 1036 rows and 4 columns of info for each row.

    When I open it on my computer it displays all fine, but on the phone it stops displaying rows at 1036.

    Is this a phone memory issue and its only able to view tiny excel docs?
     
    alan93, Jan 4, 2018
    #3
  4. Word Man Win User

    Entering row in Excel - error

    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.
     
    Word Man, Jan 4, 2018
    #4
  5. Bree New Member
    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.
     
    Bree, Apr 5, 2018
    #5
Thema:

Entering row in Excel - error

Loading...
  1. Entering row in Excel - error - Similar Threads - Entering row Excel

  2. Excelling at failing Excel

    in Windows 10 Software and Apps
    Excelling at failing Excel: First off, I’m an Excel idiot. I use Word exclusively, and only use Excel when it’s someone else’s document and I don’t have a choice. Now would be one of those times. I do want to learn, but right now, I’m an idiot. At work, there’s an Excel spreadsheet that freezes when...
  3. taskbar changes sizes from 1 row to 2 rows,3 rows,4 rows ect after done gaming even when locked

    in Windows 10 Customization
    taskbar changes sizes from 1 row to 2 rows,3 rows,4 rows ect after done gaming even when locked: i have updated all my hardware and software but the taskbar changes sizes almost every time i get back from playing a game on steam or origin, and yes it is locked. maybe it bc i have to downsize my 3840x2160 desktop resolution to 1600x900 while playing most of my games and...
  4. 2 rows in taskbar how to you change back 1 row

    in Windows 10 Customization
    2 rows in taskbar how to you change back 1 row: 2 rows in taskbar how to you change back 1 row https://answers.microsoft.com/en-us/windows/forum/all/2-rows-in-taskbar-how-to-you-change-back-1-row/687a94e1-2ec7-469f-87b0-3475ae519b13
  5. Error 0x800704cf with Store and Excel

    in Windows 10 Network and Sharing
    Error 0x800704cf with Store and Excel: I had this issue for several days with Store and OneDrive access in Excel. Then, I realized to check the proxy configuration and there was nothing in Settings. At the end I checked with CMD using netsh winhttp show proxy and I got Current WinHTTP proxy settings:...
  6. Excel spaces between rows

    in Microsoft Office and 365
    Excel spaces between rows: Hi,, I have a col that is the result of an if function. =IF(H105="a",B105,"") Which results in a col of names in col O if there is an "a" in col H. But if it is not an "a" it is a space, how can I do it so that all the spaces are removed and I end up with a col of names with...
  7. error messages on entering woobox.com urls

    in Windows 10 Network and Sharing
    error messages on entering woobox.com urls: I am using windows 10 with Edge and everytime I go to a woobox.com url I get a message saying ERROR OCCURRED. Why is this happening...for example..https://www.woobox.com/9bujen..this happens everytime I go to a woobox.com url....
  8. Row printing in windows 10

    in Windows 10 Customization
    Row printing in windows 10: hi i am a vb.net programmer and new in this community . now i am working on project in vb.net which required print text file to dot metric printer, its using winspool.Drv API which work fine in windows 7, but when try to windows 10 it not working , there is no error...
  9. Excel Error Code (Tolik)

    in Microsoft Office and 365
    Excel Error Code (Tolik): I tried to open Excel and it said it was not installed. I have Windows Office 2016 installed and my Windows Word works just fine. I tried to open the app and it said Windows Excel is not installed......(Tolik) I am seeing the error code when I try to upload TraderXL from...
  10. Disable full row select

    in Windows 10 Support
    Disable full row select: Does anyone know how to disable full Row select in windows 10 creators update? I was able to do it before, but can’t figure it out in the creators update. 95905