Forum Discussion
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...
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
Hunch: if there are multiple tables on the same sheet, they sometimes get in each others way
- Yes but this problem just start and do you have a suggestion on how to fix the issue?
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)
