Hide/visually block sections of a spreadsheet based on a checkbox?

[Zylet]

For example, if I make a checkbox labelled "N/A", and it's checked, rows 40-50 will have some visual indicator that they're N/A (e.g. partially transparent window, line out).

If it's not possible with a checkbox, is there another way to do it?

[modytrane]

See attached example.
You can change the Rows selection from "5:8" to other range.
Hope this helps.

Please Login or Register  to view this content.