HELP! I can't "unhide" my rows

%3CLINGO-SUB%20id%3D%22lingo-sub-1279108%22%20slang%3D%22en-US%22%3EHELP!%20I%20can't%20%22unhide%22%20my%20rows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1279108%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20lengthy%20excel%20worksheet%20(200%2B%20rows)%20that%20I%20had%20hidden%20some%20rows%2C%20but%20now%20I%20can't%20%22Unhide%22%20them!%20Any%20suggestions%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1279108%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1279205%22%20slang%3D%22en-US%22%3ERe%3A%20HELP!%20I%20can't%20%22unhide%22%20my%20rows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1279205%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F608191%22%20target%3D%22_blank%22%3E%40Twobizzy515%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20should%20be%20able%20to%20unhide%20by%20clicking%20in%20the%20upper%20left-hand%20corner%20of%20the%20spreadsheet%20(which%20selects%20all%20rows%20and%20all%20columns)%20and%20then%20selecting%20Format....Rows....Unhide%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1279576%22%20slang%3D%22en-US%22%3ERe%3A%20HELP!%20I%20can't%20%22unhide%22%20my%20rows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1279576%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F425987%22%20target%3D%22_blank%22%3E%40mathetes%3C%2FA%3E%26nbsp%3B-%20it%20still%20won't%20unhide%20the%20rows....%20%3CLI-EMOJI%20id%3D%22lia_disappointed-face%22%20title%3D%22%3Adisappointed_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1279997%22%20slang%3D%22en-US%22%3ERe%3A%20HELP!%20I%20can't%20%22unhide%22%20my%20rows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1279997%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F608191%22%20target%3D%22_blank%22%3E%40Twobizzy515%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou're%20clicking%20on%20this%20corner%3F%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22mathetes_0-1585947701439.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F182036i55DFD2B8A2C341F7%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22mathetes_0-1585947701439.png%22%20alt%3D%22mathetes_0-1585947701439.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EWhat%20happens%20when%20you%20click%20there%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDoes%20it%20all%20turn%20gray%20(or%20indicate%20that%20it's%20highlighted%20all%20rows%20and%20columns%3F%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22mathetes_1-1585947816685.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F182038iDA18FCE7331379BD%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22mathetes_1-1585947816685.png%22%20alt%3D%22mathetes_1-1585947816685.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EHow%20did%20you%20hide%20the%20rows%20in%20the%20first%20place%3F%20Did%20you%20lock%20or%20protect%20the%20sheet%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1285354%22%20slang%3D%22en-US%22%3ERe%3A%20HELP!%20I%20can't%20%22unhide%22%20my%20rows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1285354%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F425987%22%20target%3D%22_blank%22%3E%40mathetes%3C%2FA%3E%26nbsp%3B-%20Yes%2C%20clicking%20in%20that%20corner%2C%20highlights%20the%20entire%20page.%20Clicking%20on%20Format%2C%20and%20Unhide%2C%20and%20nothing%20happens.%20I%20do%20not%20believe%20I%20locked%20the%20page.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1285480%22%20slang%3D%22en-US%22%3ERe%3A%20HELP!%20I%20can't%20%22unhide%22%20my%20rows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1285480%22%20slang%3D%22en-US%22%3Eare%20you%20sure%20there%20are%20rows%20hidden%3F%20Do%20the%20numbers%20%22skip%22%3F%3CBR%20%2F%3EMy%20next%20guess%20is%20that%20they%20aren't%20hidden%20but%20just%20made%20to%20a%20very%20small%20height.%3CBR%20%2F%3Eif%20you%20highlight%20the%20whole%20sheet%20(as%20done%20above)%20you%20can%20double%20click%20the%20line%20between%20any%202%20rows%20to%20auto%20adjust%20the%20row%20heights.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1285547%22%20slang%3D%22en-US%22%3ERe%3A%20HELP!%20I%20can't%20%22unhide%22%20my%20rows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1285547%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F570951%22%20target%3D%22_blank%22%3E%40mtarler%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20at%20my%20wits'%20end.....%20Would%20you%20take%20a%20look%20at%20it%3F%20It's%20the%20page%20tab%20%22Quantities%22%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1285576%22%20slang%3D%22en-US%22%3ERe%3A%20HELP!%20I%20can't%20%22unhide%22%20my%20rows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1285576%22%20slang%3D%22en-US%22%3Eyou%20have%20a%20filter%20on.%20click%20on%20the%20'data'%20tab%20and%20click%20Clear%20under%20the%20sort%20%26amp%3B%20filter%20group.%3CBR%20%2F%3Eor%20click%20on%20the%20funnel%20icon%20next%20to%20Quantity%20Available%20and%20either%20'select%20all'%20or%20'clear%20filter'%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1285575%22%20slang%3D%22en-US%22%3ERe%3A%20HELP!%20I%20can't%20%22unhide%22%20my%20rows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1285575%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F608191%22%20target%3D%22_blank%22%3E%40Twobizzy515%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20see%20the%20problem--and%20your%20wits%20are%20hereby%20relieved.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou've%20been%20filtering%20out%20a%20lot%20of%20rows%20under%20the%20header%20%22Quantity%20Available%22--%20just%20go%20to%20that%20little%20funnel%20in%20the%20header%20and%20allow%20it%20to%20select%20ALL%20rows.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOR%20turn%20off%20the%20filter%20altogether.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22mathetes_0-1586194355652.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F182417i654A1C9E89F3EEE7%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22mathetes_0-1586194355652.png%22%20alt%3D%22mathetes_0-1586194355652.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1285589%22%20slang%3D%22en-US%22%3ERe%3A%20HELP!%20I%20can't%20%22unhide%22%20my%20rows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1285589%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F425987%22%20target%3D%22_blank%22%3E%40mathetes%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eo.m.g........%20Thank%20you!!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1285591%22%20slang%3D%22en-US%22%3ERe%3A%20HELP!%20I%20can't%20%22unhide%22%20my%20rows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1285591%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F570951%22%20target%3D%22_blank%22%3E%40mtarler%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eo.m.g......%20thank%20you!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

I have a lengthy excel worksheet (200+ rows) that I had hidden some rows, but now I can't "Unhide" them! Any suggestions?

10 Replies
Highlighted

@Twobizzy515 

 

You should be able to unhide by clicking in the upper left-hand corner of the spreadsheet (which selects all rows and all columns) and then selecting Format....Rows....Unhide

Highlighted

@mathetes - it still won't unhide the rows....

 

Highlighted

@Twobizzy515 

 

You're clicking on this corner?

mathetes_0-1585947701439.png

What happens when you click there?

 

Does it all turn gray (or indicate that it's highlighted all rows and columns?

mathetes_1-1585947816685.png

How did you hide the rows in the first place? Did you lock or protect the sheet?

Highlighted

@mathetes - Yes, clicking in that corner, highlights the entire page. Clicking on Format, and Unhide, and nothing happens. I do not believe I locked the page. 

Highlighted
are you sure there are rows hidden? Do the numbers "skip"?
My next guess is that they aren't hidden but just made to a very small height.
if you highlight the whole sheet (as done above) you can double click the line between any 2 rows to auto adjust the row heights.
Highlighted

@mtarler 

 

I am at my wits' end..... Would you take a look at it? It's the page tab "Quantities"

Highlighted

@Twobizzy515 

 

I see the problem--and your wits are hereby relieved.

 

You've been filtering out a lot of rows under the header "Quantity Available"-- just go to that little funnel in the header and allow it to select ALL rows.

 

OR turn off the filter altogether.

mathetes_0-1586194355652.png

 

Highlighted
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'
Highlighted

@mathetes 

 

o.m.g........ Thank you!!

Highlighted

@mtarler 

 

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