Missing Rows

[BWolf]

Opened a file noticed my formula was not working. Noticed that I have rows missing. No idea where they went.

I have row 300, then 301, then it goes to 539??

Is there a way to find my missing rows?

 

[Trouttrap2]

Do you have hidden rows? highlight rows 301 to 539. Right click > unhide.

 

[BWolf]

Did that....nothing happens.

 

[Rick Rothstein]

Just in case it makes a difference in some way (it probably won't, but it can't hurt to try), select all the cells (click the blank upper right corner where the row headers meet the column headers), then right click the row headers and click Unhide on the popup menu that appears.

 

[BWolf]

Tried that...still the same....no change.

Is there a way to insert a screen shot here?

 

[MARK858]

Have you got the Autofilter turned on? (Under the Data tab in 2007+)

 

[BWolf]

Feel like a dummy....had the filter on....was a long today!