Home

Search the cell that I hide

%3CLINGO-SUB%20id%3D%22lingo-sub-774496%22%20slang%3D%22en-US%22%3ESearch%20the%20cell%20that%20I%20hide%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-774496%22%20slang%3D%22en-US%22%3E%3CP%3EI%20hide%20a%20lot%20of%20cells%2C%20when%20I%20use%20Ctrl%20%2B%20F%20to%20search%20the%20hidden%20cells%2C%20I%20cant%20find%20it%2C%20could%20anyone%20help%20me%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-774496%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-774677%22%20slang%3D%22en-US%22%3ERe%3A%20Search%20the%20cell%20that%20I%20hide%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-774677%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F382435%22%20target%3D%22_blank%22%3E%40tommyho%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPress%20Cltr%20%2B%20F%20and%20click%20'Find%20All'%20.%20it%20will%20show%20list%20of%20all%20cells%20even%20if%20these%20cells%20are%20hidden.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20527px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F124583i1C3CA4D25CDC1F26%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Hidden%20Cells.JPG%22%20title%3D%22Hidden%20Cells.JPG%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-774759%22%20slang%3D%22en-US%22%3ERe%3A%20Search%20the%20cell%20that%20I%20hide%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-774759%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F382435%22%20target%3D%22_blank%22%3E%40tommyho%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EOne%20by%20one%20also%20works%2C%20cell%20address%20will%20be%20shown%20in%20the%20address%20bar%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20537px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F124589iDCAE42DD9D6D37C7%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-774779%22%20slang%3D%22en-US%22%3ERe%3A%20Search%20the%20cell%20that%20I%20hide%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-774779%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%2C%20I%20have%20tried%2C%20but%20it%20only%20shows%20the%20cells%20that%20I%20didn't%20hide%2C%20so%20I%20still%20can't%20find%20the%20hidden%20cells.%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F239215%22%20target%3D%22_blank%22%3E%40tauqeeracma%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-774783%22%20slang%3D%22en-US%22%3ERe%3A%20Search%20the%20cell%20that%20I%20hide%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-774783%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F382435%22%20target%3D%22_blank%22%3E%40tommyho%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20would%20be%20good%20if%20your%20share%20your%20file%20so%20to%20better%20understand%20the%20requirement.%20Thanks%3C%2FP%3E%3C%2FLINGO-BODY%3E
tommyho
New Contributor

I hide a lot of cells, when I use Ctrl + F to search the hidden cells, I cant find it, could anyone help me?

4 Replies

@tommyho 

Press Cltr + F and click 'Find All' . it will show list of all cells even if these cells are hidden.

 

Hidden Cells.JPG

 

@tommyho 

One by one also works, cell address will be shown in the address bar

image.png

 

Thanks, I have tried, but it only shows the cells that I didn't hide, so I still can't find the hidden cells.

@tauqeeracma 

@tommyho 

It would be good if your share your file so to better understand the requirement. Thanks

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
38 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies