How do you quickly recall cell rows from excel?

Question

I have a database set up that I use for work and I have lost over a thousand cell rows as they have ben squashed into one another.

Fom 1 to 217 are visible, then it goes straight from 217 to 1647, is there a quicker way to reinstate the 1430 cells not visible than clicking and dragging each one open 1430 times?

Appreciate any help.

Answer 1

Yes, select all those rows.

From the menu select format row height

change row height and there you go  

Answer 2

Are you sure they have not been 'hidden' ?  Try placing you mouse over 217, click and drag over 1647, then place your mouse inside the highlighted area, right click and 'Unhide'.