This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I've tried all the tips and tricks I found in the help section as well as google searches, including "go to", "format and unhide"...nothing has worked.
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Use Ctrl-A to select all, then right-click a row number (at the far left) and choose UnHide (works if the rows were hidden) or resize the row height on a visible row (works if the rows are just very short) or turn off Data Filters (works if the sheet is filtered).
Try this:
Thank you so much for trying to help me. How do I attach a file here? I'm not sure I'm seeing that capability. Also, I wonder if this problem is unique to my computer or version of excel that I have?
Did you select all and adjust row height?
Have you disabled macros ? - there may be code preventing you from showing those rows.
Can you share a copy of the file - remove everything that is visible....
I'm on a mac, but yes, I've tried to select all, then unhide (didn't work). I've tried "go to", A1, adjust row height to 100, it shows row 5 but if I try to click on entire row 5, it hides again. Nothing has worked.