How do I unsquish my Google Docs spreadsheet?
February 5, 2009 11:49 PM Subscribe
My Google spreadsheet collapsed itself in the middle somehow. How do I get it back?
Here's a screenshot showing that for some odd reason, a worksheet in Google Docs (spreadsheets) jumps from cell 20 to 200 and all my data within the hidden section is gone. I don't know how this happened but I'd like to somehow expand it to restore. How?
Here's a screenshot showing that for some odd reason, a worksheet in Google Docs (spreadsheets) jumps from cell 20 to 200 and all my data within the hidden section is gone. I don't know how this happened but I'd like to somehow expand it to restore. How?
If you don't have luck getting the data back within Google Docs itself you could try recover the data by exporting the spreadsheet to another format, then open it in either MS Office or Open Office.
Also, just to confirm, the rows aren't just hidden are they? i.e. Can't you just select both rows 20 and 201, right click and select un-hide rows?
posted by Gomez_in_the_South at 1:04 AM on February 6, 2009
Also, just to confirm, the rows aren't just hidden are they? i.e. Can't you just select both rows 20 and 201, right click and select un-hide rows?
posted by Gomez_in_the_South at 1:04 AM on February 6, 2009
Try this: select the two rows that have missing rows between them. In the "Format" menu, select "Row" and then "Unhide."
posted by not that girl at 11:08 AM on February 6, 2009
posted by not that girl at 11:08 AM on February 6, 2009
Response by poster: Oddly, I could never actually fix this, and ended up using safari instead.
posted by mathowie at 7:24 PM on March 8, 2009
posted by mathowie at 7:24 PM on March 8, 2009
This thread is closed to new comments.
If so, select across that range (say from row 19 to 202) and then resize those rows by dragging the edge of one of the labels. They should all resize to the new larger size. Then you can re-adjust as you need to.
Google SS's are kind of flaky sometimes. Too much Javascript trying to run that fancy UI all at once.
posted by rokusan at 11:55 PM on February 5, 2009