cheryl33 Posted February 20, 2007 Report Share Posted February 20, 2007 I'm working on a spreadsheet at work and for some reason i have lost rows 2 to 64! I have tried hiding/unhiding, freezing/unfreezing etc but nothing! can anyone help? Link to comment Share on other sites More sharing options...
Jemimap Posted February 20, 2007 Report Share Posted February 20, 2007 I'm working on a spreadsheet at work and for some reason i have lost rows 2 to 64! I have tried hiding/unhiding, freezing/unfreezing etc but nothing!can anyone help? Â Email it to me Cheryl and i'll have a look Link to comment Share on other sites More sharing options...
Sophie Posted February 20, 2007 Report Share Posted February 20, 2007 (edited) I have done this many times, and now hate Excel. If you look between 1 and 65, is there a thickish grey line? If you place your mouse in the lower number, close to the top, your pointer should turn into a bar with an arrow in it. If you move it around in box 65, it should, at one position, show a gap in the bar. If you double click when this shows, you should get one row back. You then have to repeat for each of the rest of the rows. Â Hopefully someone will have a better idea how to get them all back at once. Â ETA: This only works if they are actually hidden. IF something else has happened to them, then it won't work. Â Just found out how to unhide everythign that is hidden - select all, then go Format --> Row --> Unhide (or Column --> Unhide if its a hidden column). Edited February 20, 2007 by Sophie Link to comment Share on other sites More sharing options...
cheryl33 Posted February 20, 2007 Author Report Share Posted February 20, 2007 have emailed it to you Sam  Sophie, it wont let me do any of the stuff you suggested :-( Link to comment Share on other sites More sharing options...
Hayley Posted February 20, 2007 Report Share Posted February 20, 2007 (edited) I am on an Excel course at work tomorrow and can ask the trainer if you are still stuck - my email address at work is [email protected] Edited February 20, 2007 by Hayley Link to comment Share on other sites More sharing options...
Recommended Posts