Forum Discussion

tommyho's avatar
tommyho
Copper Contributor
Jul 26, 2019

Search the cell that I hide

I hide a lot of cells, when I use Ctrl + F to search the hidden cells, I cant find it, could anyone help me?
excel
tauqeeracma's avatar
tauqeeracma
Iron Contributor
Jul 26, 2019

tommyho 

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

 

 

  • tommyho's avatar
    tommyho
    Copper Contributor
    Jul 26, 2019

    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 

    • tauqeeracma's avatar
      tauqeeracma
      Iron Contributor
      Jul 26, 2019

      tommyho 

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

Resources