Results 1 to 6 of 6
  1. #1
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Form Question? (e2k (9.0.6926 SP-3))

    My spreadsheet looks like this:

    <pre>Last First
    ===== ======
    Brown Tom
    Smith John

    </pre>



    When I click Data, Form

    The form opens with dashes to the left of each field.

    <pre>=====: Brown
    =====: Tom
    </pre>


    How do I get Last and First appear as labels to the left of each field?

    <pre>Last: Brown
    First: Tom
    </pre>


    Thanks, John

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Form Question? (e2k (9.0.6926 SP-3))

    Delete the row with the ==== in them, so the last and first are the header. <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

    Steve

  3. #3
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Form Question? (e2k (9.0.6926 SP-3))

    The first two lines were selected Click Windows, Freeze Panes

    The dashes are there for readability

    Is removing the lines of dashes the only solution?

    Thanks, John

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Form Question? (e2k (9.0.6926 SP-3))

    If you format Last and First differently, for example make them Bold, Excel will interpret them as column headers (field names). But then it will see ====, ==== as the first record.
    The ==== look very old-fashioned, as if you were forced to use a typewriter. I'd remove them.

  5. #5
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Form Question? (e2k (9.0.6926 SP-3))

    Youíre right, that is old fashion, from now on Iím going in a new direction, no dashes and a bold title line.

    Thanks, John

  6. #6
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Form Question? (e2k (9.0.6926 SP-3))

    You could format the cells in the first row with a double line lower border and then delete the second row.
    Legare Coleman

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •