Search the cell that I hide

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

@tommyho 

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

 

Hidden Cells.JPG

 

Highlighted

@tommyho 

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

image.png

 

Highlighted

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 

Highlighted

@tommyho 

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