Missing underline and Date

S

SLS

I am new to Excel and was trying to type a word then do
underline after that for a line to write on, but as soon
as I click of the cell the line disappears. Why, and can
I keep that from happening. Also I would like to be able
to add a start date and the other dates automatically
follow. Ex: If I type in April 13, 1994 for a Sunday the
next day Monday would read April 14, 1994. Is this
possible and how is it done in terms a newbie would
understand.
 
R

Ragdyer

Don't understand the first part of your question, and the second part is
none to clear also.
But, as far as dates incrementing:
Enter a date in A1
In A2 enter this formula,
=A1+1
Click in A2, and place the cursor over the small black square in the lower
right corner of the cell (fill handle), and when it turns into a skinny
black cross, click and drag down to copy the formula for maybe ten rows.
When you release the mouse, you'll see a column of dates which increase by a
day.
Now click in A1, and change the date.
You'll see the entire column of dates change to follow the new date.

Is this the information that you're looking for?
 
S

schauenb

I mean if I type a line, EX: Sign Here__________________
in a cell when I click on another cell it looks like
this, Sign Here with no line.
 
F

Frank Kabel

Hi
you probably just don't see the line as it's hidden by the border line.
why not use 'Format - Cells ' Border' for this?

For your second question simply use
=A1+1
and format this cell as date
 
R

Ragdyer

When designing forms, and the underline is needed, for dates or signatures,
it's usually best to use the *next* cell.
Try to adjust your form so that you can place the underline in the following
cell, and then choose from <Format> <Cells> <Borders> a "heavy" line that's
easily discernable.
 
Top