I have a large spreadsheet that I regularly add rows to. Somehow or another someone has fiddled with it and now the spreadsheet will not allow any more rows to be added and ends at row 2150! The screen below this is not grided but shaded grey. Can anyone help?
Can you copy and paste the infomration into another file or worksheet? So it is back to normal. should be 65000 rows if you hit shift and the down arrow it shows you the length and then hit shift up arrpw to get back.
I suspect that the answer is quite a simple one. I think that someone has hidden the rows below 2150. If you click the small box at the top left of the worksheet to the left of the A(so it will select the entire sheet), then select format>rows>unhide.
I expect all will be well.