Forum Discussion
KarinEN64
Jan 18, 2019Copper Contributor
Cannot expand hidden rows in Excel Office 365 for Mac!
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
- Rich99Iron ContributorHi, 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