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

enter image description here

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


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

  • Thanks for the recommendation, doesn't work sadly – user3088649 Sep 29 '14 at 17:10
  • Aha! got it - you need to re-hide them all and then unhide and it works. Thank you – user3088649 Sep 29 '14 at 17:13

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.