• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Disappearing words in an excel cell

Ufoo

Member
Hello excel experts, is there a way to write instructional words in an excel cell; which disappear when I click on the cell? Thanks
 
Without VBA, I think the answer is no. There is a trick that might suffice though.

If you type your instructions, using appropriately formatted text, in one column and then reduce the column width to 2pts it will spill over adjacent blank cells. Type any content into the cell and the instructions vanish.
 
Without VBA, I think the answer is no. There is a trick that might suffice though.

If you type your instructions, using appropriately formatted text, in one column and then reduce the column width to 2pts it will spill over adjacent blank cells. Type any content into the cell and the instructions vanish.
Thanks. This trick serves the purpose
 
Back
Top