Forum Discussion
Sfreides
Nov 13, 2023Copper Contributor
problems in a workbook add lines
I have a large multi tab workbook. Several of the sheets will not let me insert lines. I have done the following to solve it but nothing worked: sheet is no protected removed add-ins removed fi...
Sfreides
Copper Contributor
I tested this. If I go to sheet in the workbook that will not let me insert lines and control+end it takes me to the last line.
If I type new lines and go to A1 and type again control+end it go to the NEW last line.
If I go to another sheet in the same workbook and do the control+end it takes me past the last line of data. if I type on lines to make the last line past the original last line that the control+end it takes me to correct last line, but if I clear or delete the added lines it them sets the line the new last liine.
Stuart
If I type new lines and go to A1 and type again control+end it go to the NEW last line.
If I go to another sheet in the same workbook and do the control+end it takes me past the last line of data. if I type on lines to make the last line past the original last line that the control+end it takes me to correct last line, but if I clear or delete the added lines it them sets the line the new last liine.
Stuart
JKPieterse
Nov 15, 2023Silver Contributor
Hunch: if there are multiple tables on the same sheet, they sometimes get in each others way
- SfreidesNov 15, 2023Copper ContributorYes but this problem just start and do you have a suggestion on how to fix the issue?
- JKPieterseNov 16, 2023Silver Contributor
Sfreides I would really have to see one of the sheets. Can you perhaps copy one sheet for which it doesn't work, remove all data from that table and save that sheet it somewhere so we might download it? (of course after confirming the issue is still there)