It would be helpful to include what version of Excel you are using.
I’m fairly certain you can not do it in 2000. In 2007, there may be an option, but I am not sure. It may involve some VB scripting.
i am working on microsoft office 2003.