If you don't want to rearrange the original data, you could also use Format>Conditional Formating to change the cell font color to the background color for all cell values <> 1. That will make all data "invisible" unless values are 1. If data values are typed or paste special values...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.