Forum Discussion

Twobizzy515's avatar
Twobizzy515
Copper Contributor
Apr 03, 2020

HELP! I can't "unhide" my rows

I have a lengthy excel worksheet (200+ rows) that I had hidden some rows, but now I can't "Unhide" them! Any suggestions?
excel
mtarler's avatar
mtarler
Silver Contributor
Apr 06, 2020
you have a filter on. click on the 'data' tab and click Clear under the sort & filter group.
or click on the funnel icon next to Quantity Available and either 'select all' or 'clear filter'
Twobizzy515's avatar
Twobizzy515
Copper Contributor
Apr 06, 2020

mtarler 

 

o.m.g...... thank you!

 

  • RayBNN's avatar
    RayBNN
    Copper Contributor
    Jul 31, 2023
    This worked for me and I stopped pulling my hair out, I was going to distribute the sheet to people that aren't comfortable with Excel...
  • jmcelroy's avatar
    jmcelroy
    Copper Contributor
    Apr 05, 2022
    KAzim2000 approach worked for me.
  • KAzim2000's avatar
    KAzim2000
    Copper Contributor
    Dec 18, 2021

    For others who may run into this hidden rows problem try View > Freeze Panes > Unfreeze 

Resources