Many thanks to all who responded i have since figured it out so for the
benifit of those with a similar problem
1, manually locate a cell i.e. B1
2, selct format, row, unhide
3, this shows row 1 you can now select the entire row and unhide the
remaining rows

good luck

"Mark" wrote:

i have been sent a work book where one of the sheets is blank it appears that
all of the cells have been selected and then hidden is there any way i can
get them back?