Software·43,883 discussions

hide a colum in excel then auto unhide on at date

Locked

I would like to hide a colum in excel then auto unhide on at date

Normal use of sheet will have a colum hidden
once a date is reached the hidden colum is then unhidden and now is in use and will remain unhidden.

Cheers

Steve

Topic

Clarifications

In reply to hide a colum in excel then auto unhide on at date

Clarifications

I’m not sure about unhiding a column but you can do this…

In reply to hide a colum in excel then auto unhide on at date

Set a date to the desired date….
Run a function (if date = ??? then the value in the cell = ????) where ??? = your desired dates & values.

See this link for some more info…

http://www.meadinkent.co.uk/datesandtimes.htm

There are many more examples, this was the first Google hit I got.

You could possibly run a macro against the date to unhide the column but sometimes people have macros disabled.

Edited for – check these out also…

http://tinyurl.com/ybfstf7

In addition….

In reply to I’m not sure about unhiding a column but you can do this…

If you have a few hundred rows in the column you want to hide….

I would probably copy that column to a column to the far right of the sheet….set the text color to white & lock the cells so they can’t be selected….then run the function to display the contents from that cell in the cell you desire it to be displayed.

[Author]

Replies