'Workbook Performance' Sets Me Back (Row Visibility?)

[rjbinney]

Alternate thread title: "AI Ate My Workbook!!!"

Dear Mr. Excel:

I have a worksheet. 5500 rows of data.

"Workbook Performance" popped up (never seen that before) and suggested I had over one million cells that needed optimizing.

Wow!

So instead of me taking rows 5501-end and Ctrl-Minusing them, I let the MSFT Bot do its thing.

It said it would "Remove Visibility" of those bottom rows.

Now my worksheet ENDS on Row 5501, and I CANNOT ADD A ROW BELOW IT! (Adding above and moving is a possibility, but there is data and formulas in those rows, natch.)

How do I get rows back? I've tried Find&Select=>Go To and =>Go To Special...

Thoughts?

 

[jkpieterse]

Hit control+A twice and select Home, Format, Hide & Unhide..., Unhide rows? Or perhaps their rowheights have been set to zero?

 

[rjbinney]

That's it!

I didn't do the Ctrl+A twice before, and that made the difference.

Thank you.