I hide a lot of cells, when I use Ctrl + F to search the hidden cells, I cant find it, could anyone help me?
Press Cltr + F and click 'Find All' . it will show list of all cells even if these cells are hidden.
One by one also works, cell address will be shown in the address bar
Thanks, I have tried, but it only shows the cells that I didn't hide, so I still can't find the hidden cells.
It would be good if your share your file so to better understand the requirement. Thanks