Unhiding rows

Hi Victoria, You seem to have covered everything so I dont really have a great deal to offer, the select all button is found at the intersection of the row and column indicators, the little square where the 1 and A meet, clicking on that will select the entire worksheet, if it does all select; try menu command Format>Rows>Unhide. If you have already followed those steps, I cant think of anything else. I hope you crack it soon. regards Pete

When you select the rows by clicking and dragging on the row headers go slightly higher than A7 cell so that you drag over what would be the column row header. You'll see a little yellow box while you are dragging showing you how many rows you have selected. Once you go a little higher it will add in the 7 rows you have hidden. Your unhide option should now work.

Hi Victoria, Im glad that Raj managed to sort your problem, I am gutted, I considered Freeze Panes and tried it out on my test workbook, but when I Selected All and then used the Right Click Show all option, everything came back, so I assumed that was not the problem, just another example of "dont assume", still once again I'm pleased you got it resolved. Pete