5 {{ upvoteCount | shortNum }}
5 {{ upvoteCount | shortNum }}

Need some help with Excel - simple problem

by Barbara Eyre
4 replies
  • OFF TOPIC
    • |
I'm using Excel to make a form someone fills in (prints out to fill in) and am having a minor, but important issue. The following is a simplified example, but it gives you an idea of what I'm trying to accomplish.

Date: ______________________

Name: ______________________

In Excel, when I make the ________________ it wants to print preview and print those lines as _ _ _ _ _ _ _ _ _ _ __ and I think that looks terrible and unprofessional.

So, if I'm doing ______________ on the screen, how can I tell it to do the same in print preview AND when I print the form?

Thanks in advance.
  • Profile picture of the author CWreports
    Barb.

    Select the cells/area where you want the lines...go to FORMAT>>BORDER and select a border type for the bottom portion of the cell.

    That should do it.

    Carol
    Signature
    “I must create a system or be enslaved by another man’s.” W.Blake
    {{ DiscussionBoard.errors[241486].message }}
  • Profile picture of the author CWreports
    Barbara,

    Then do this. Type in something the desired length of your line and then underline it.
    Make the FONT Color White so it won't show up.


    Hopefully that'll work.

    Carol
    Signature
    “I must create a system or be enslaved by another man’s.” W.Blake
    {{ DiscussionBoard.errors[243817].message }}
  • Profile picture of the author jimbojones1877
    Hi Barb you can try using the Drawing Toolbar to just draw the line instead of doing the underscore (_____)
    {{ DiscussionBoard.errors[256808].message }}

Trending Topics