# Excel Quest: How to keep rows from collapsing after save and then reopening **URL:** \ **Category:** Factual Questions\ **Created:** [May 16, 2019, 3:12pm UTC](https://boards.straightdope.com/t/excel-quest-how-to-keep-rows-from-collapsing-after-save-and-then-reopening/834058 "2019-05-16T15:12:52Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![Si\_Amigo](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/si_amigo/32/2877_2.png) [@Si\_Amigo](https://boards.straightdope.com/u/Si_Amigo)\ **Post date:** [May 16, 2019, 3:12pm UTC](https://boards.straightdope.com/t/excel-quest-how-to-keep-rows-from-collapsing-after-save-and-then-reopening/834058/1 "2019-05-16T15:12:52Z")
I am having an issue in Excel 2013 where I physically shrank some rows down instead of hiding them. Must have saved them that way one time. Now when I physically drag them back open and do a save they do not come back opened up, they are back to the shrank rows and people cannot see them without me telling them to unshrink those rows. Very frustrating. Any suggestions other than in the future don’t shrink the rows, just hide them? ---
**Author:** ![KneadToKnow](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/kneadtoknow/32/3999_2.png) [@KneadToKnow](https://boards.straightdope.com/u/KneadToKnow)\ **Post date:** [May 16, 2019, 3:18pm UTC](https://boards.straightdope.com/t/excel-quest-how-to-keep-rows-from-collapsing-after-save-and-then-reopening/834058/2 "2019-05-16T15:18:40Z")
Some formatting stuff does not trigger Excel’s “this file has changed” flag. Dunno why. Change the rows to the way you want them, then change the contents of a cell somewhere. _Then_ save. If needed, you can then change the contents of the cell you changed back to what they were and save again. ---
**Author:** ![Si\_Amigo](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/si_amigo/32/2877_2.png) [@Si\_Amigo](https://boards.straightdope.com/u/Si_Amigo)\ **Post date:** [May 16, 2019, 3:53pm UTC](https://boards.straightdope.com/t/excel-quest-how-to-keep-rows-from-collapsing-after-save-and-then-reopening/834058/3 "2019-05-16T15:53:30Z")
> [@KneadToKnow](#): > > Some formatting stuff does not trigger Excel’s “this file has changed” flag. Dunno why. > > Change the rows to the way you want them, then change the contents of a cell somewhere. _Then_ save. > > If needed, you can then change the contents of the cell you changed back to what they were and save again. I had high hopes for a simple fix such as this but alas it’s not working. But it did inspire me to try a different approach. I copied the information from the rows into new rows and then deleted the offensive rows. Now there is peace in my Excel world. Thanks! ---
**Author:** ![KneadToKnow](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/kneadtoknow/32/3999_2.png) [@KneadToKnow](https://boards.straightdope.com/u/KneadToKnow)\ **Post date:** [May 16, 2019, 3:56pm UTC](https://boards.straightdope.com/t/excel-quest-how-to-keep-rows-from-collapsing-after-save-and-then-reopening/834058/4 "2019-05-16T15:56:07Z")
Whatever works! Good job! ---
**Author:** ![TroutMan](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/troutman/32/6721_2.png) [@TroutMan](https://boards.straightdope.com/u/TroutMan)\ **Post date:** [May 16, 2019, 6:10pm UTC](https://boards.straightdope.com/t/excel-quest-how-to-keep-rows-from-collapsing-after-save-and-then-reopening/834058/5 "2019-05-16T18:10:15Z")
Glad you found a solution, but problems like this bug me when I don’t know the cause. To satisfy my curiosity, are you using Office 365? Is there a chance that you or another user have the file opened from some other device, and your change to row height was continually overwritten by the other device?