This may seem easy to more advanced users, but I can't seem to find this out there.
I have a complex Excel worksheet. It has various formulas/calculations throughout the sheet.
Unfortunately, these cells trigger the Inconsistent Error Warning (green triangle), and over the few thousand cells, this makes for quite an ugly sheet.
I am aware you can disable this globally, and it is possible to individually disable the checking… but is it possible to hide a range? EG: I4:JQ151.
As you can imagine; individually hiding every cell is too much, and global disabling is a minefield for other parts of the sheet that DO need validation.
Cheers in advance, and sorry if this is a nooby question.
Best Answer
You can do this for a range by:
Opton 2 via vba: select your cells and run the following macro