Cannot expand hidden rows in Excel Office 365 for Mac!

New Contributor

I have downloaded an excel file to my Mac where many columns and rows are hidden. I want to expand them but when I mark the rows before and after the "dubbel line" with hidden rows and then right clic on "expand rows" nothing happens.

The excel sheet is not looked since I can open the rows one by one by dragging one line at the time down wards, but it takes for ever to open them one by one - very time consuming....

What should I do to unlock the hidden rows???

I have tried the Control+Shift+9 command as well....

1 Reply
Hi, it sounds like the rows are not actually hidden but the row height is set very low, why not try highlighting the rows and setting row height to a sensible value. That should open them all up.

Rich