Unable to expand cells in Excel

Question

Within my Excel spreadsheet there are many cells that although they contain data, they do not respond when I try to automatically resize them. I've tried auto-fit, auto-hide (turning it off), etc.

Here is an image to show you what I am talking about

The only way that works is to resize manually or double-click when the resize button displays.

Solution

Select the rows surrounding them and then right click and Unhide.

Comments

[user3088649]

Thanks for the recommendation, doesn't work sadly

[user3088649]

Aha! got it - you need to re-hide them all and then unhide and it works. Thank you