'hidden text' in micosoft excel
Posted on 2003-03-10
This one is Urgent, but not too difficult for you experts I don't think...
I am creating a template on Excel and I am a bit of a novice, so hopefully you guys will find this a really easy one!
I am having a nightmare trying to get some text to be 'hidden' ie. I want the text to show on the template but I do not want it to show on the print copy. Obviously this is possible , and I know how to on microsoft word. I have tried highlighting hidden text from Word and copy/pasting it to the required cell in Excel, but this doesn't seem to work either. I have been faffing around with this for some time now and have been told that you may be able to help! I really hope so!
I tried the method of making a 'text box' which works fine for most things, however there is one box which has a formula applied to it and so I don't think that I can put it in a text box.
Other suggestions have been to change the offending text to white or to just delete it every time we use the template. These would both work for text, but again would be no good for the cells with formulas applied to them. Anyway I can't expect the user to delete unwanted text everytime they print a new quote.
It sounds like a simple one, but I have tried every other avenue and you guys are my last hope. I have never used this expert exchange thing and don't even know how to get my answer, if there is one! I have no problems with attaching the template so that anyone can have a look at it for themselves. Just let me know!