Missing underline and Date

  • Thread starter Thread starter SLS
  • Start date Start 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.
 
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?
 
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.
 
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
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top