underline

[afdmello]

I input data into a cell and then I want some space blank and again add
units. I want the blank area to have underline for people to fill in the
data how do I go about it.

I tried using the space bar with underline selected. In this way I can see
the underline in the formula bar but when i hit enter I cant see it in the
sheet??

afd

 

[Bob Umlas]

Give all the cells which you want to show the underline a bottom border.
Then with all of these cells selected, use conditional formatting and enter
this formula (substitute the real active cell for B1 here):
=B1<>""
then click the format button and the patterns tab and select None for the
border. This way, when something is entered, the underline (border)
disappears and re-appears if they blank out the cell.
HTH

Bob Umlas

 

[afdmello]

Thank you Bob. Incidentally my question was wrong.

I am now making a soft copy of the work permits to be printed.
I will enter : Mr. of production. or for eg date
time hrs
when I print I want the space between Mr. and of production ; time and hrs
to have a line.

Afd