Hi

Take a look at the Group and Outline function.
Mark any number of columns that you wish DataGroup and OutlineGroup
Thos columns will now be hidden, and you will see a "+" sign inserted above
the column headers.
Clicking the + sign will make them visible again, and the sign will change
to -. Clicking the - sign will hide them again.

--

Regards
Roger Govier

"sby" wrote in message
...
Hi

This is a big ask but does anyone know how to data in one column to show
different data.
What I want is to have a column with data and at the bottom have a button
which when you press it changes the data to something different (ie: a
hidden
column) and when you click it again it put the original data back.
I want this so I do not have to have more columns on a sheet.

Thanks

SBY