Forum Discussion
Hidden Rows in Excel Spreadsheet
Hi Eric,
You may select entire sheet (click on the triangle icon on top left of cell A1), after that Home->Format->AutoFit Row Height (or Row Height if you'd like to make all of them same size)
Thank you for your answer! I've tried to do the steps you indicated and it works for all visible rows, but the rows that are hidden(minimized to the smallest size possible) do not get re-sized. They stay hidden. In order to get them to be re-sized also, I have to enlarge them so that they are at least viewable first and this is not an options as there are thousands of rows that I need to do this for.
Eric, if rows were hidden through Hide menu, when select all rows, right click menu and Unhide.
If rows have zero or close to it height, when select all rows and AutoFit row Height - empty rows will be returned to default height, other ones autofitted.
