May 03 2022 07:15 AM
This was asked of me and I am not sure if there is another answer,
If I have hidden rows/columns how would someone else know that when opening a workbook WITHOUT noticing that the columns may say A|B|F|G|H showing that I have hidden C\D\E?
OR if I were to hide the column headings...?
Is there a way to see that somewhere that there are hidden columns/rows?
TIA
May 03 2022 09:11 AM
Solution
An interesting question! On a number of levels.
Why does one hide rows or columns in the first place? Off the top of my head, I can think of at least a couple potential reasons for hiding columns...sometimes just because they're what we call "helper columns," used for processing/calculating, but off central stage because it's only the end result that matters; sometimes because they contain variables or factors that aren't for public consumption or inadvertently;nt alteration (e.g., percentage rates of this or that).
In general, I'm not aware of an easy or automatic way to flag the presence of hidden rows or columns.
Why does it matter? Who's asking? (I ask, not to be rude, but the context of a question like you've asked needs also to be taken into account. If it's just a hypothetical, that's one thing; if there's a security or data integrity issue at stake, that's another.)
May 03 2022 10:09 AM
May 03 2022 09:11 AM
Solution
An interesting question! On a number of levels.
Why does one hide rows or columns in the first place? Off the top of my head, I can think of at least a couple potential reasons for hiding columns...sometimes just because they're what we call "helper columns," used for processing/calculating, but off central stage because it's only the end result that matters; sometimes because they contain variables or factors that aren't for public consumption or inadvertently;nt alteration (e.g., percentage rates of this or that).
In general, I'm not aware of an easy or automatic way to flag the presence of hidden rows or columns.
Why does it matter? Who's asking? (I ask, not to be rude, but the context of a question like you've asked needs also to be taken into account. If it's just a hypothetical, that's one thing; if there's a security or data integrity issue at stake, that's another.)