Donate SIGN UP

Excel

Avatar Image
Flavels | 20:41 Tue 13th Mar 2007 | Technology
4 Answers
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?
Gravatar

Answers

1 to 4 of 4rss feed

Best Answer

No best answer has yet been selected by Flavels. Once a best answer has been selected, it will be shown here.

For more on marking an answer as the "Best Answer", please visit our FAQ.
Need a bit more information. What happens if you try to insert a row (any error messages)?
How big (in megabytes) is the spreadsheet?
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.
Question Author
The message is that you can't insert a row as you are at the end. It would seem that the person that fiddled with it has somehow restricted the size.
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.

1 to 4 of 4rss feed

Do you know the answer?

Excel

Answer Question >>