How to find out all the hidden columns?

[Peter]

Is there a way to find out all the hidden columns in a project file? For
example, I take over a project file from someone but some columns have been
hidden but I don't even know the name of the columns.


Thanks,

Peter

 

[JackD]

View menu / Table: / More Tables / Edit will show you the structure of the
table.

I'd say that if the columns are hidden then the previous owner didn't really
need them and you probably don't either.

If you want to know which columns have data in them you can either insert
them and inspect them manually or use something like my CheckFields macro to
do it for you. You can find the macro on this page about 4/5 of the way
down.
http://masamiki.com/project/macros.htm

 

[Peter]

Hi Jack,

View ...More Tables ...Edit seems to only show unhidden columns.

Peter

 

[Jan De Messemaeker]

Insert, Column gives a dropdown list of all possible columns (hundreds).
Those that are not visble are hidden

 

[JackD]

It should show columns with zero width. That is what I consider hidden. The
other columns are simply not displayed. Those other colums always exist,
they just aren't displayed.

 

[Peter]

Hi Jack,

So your definition of "hidden" is column with zero width not column which is
hidden by the action "Hide Column". I'm trying to figure out how to find the
ones hidden by the action "Hide Column".

Peter

 

[Peter]

Is there a way to find out the columns which are hidden by the action "Hide
Column"?

Thanks,

Peter

 

[JackD]

You can't know what they were. There is no history of whether a column was
ever shown or not.
All you can know is if there is data in it. I gave you a way to find all
custom columns with data.
The point is to display the ones you need.