Results 1 to 2 of 2

Thread: Data Form

  1. #1
    5 Star Lounger
    Join Date
    Feb 2001
    Youngstown, Ohio, USA
    Thanked 0 Times in 0 Posts

    Data Form

    It is possible to highlight a range and use Data | Form to create a simple input form. Is there a way to make this persistant? Also, is there a way to tinker with the form's setup to change the way the data is input (ie "Enter" moves to the next field, or the next record after the last field is filled)?

  2. #2
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Redcliff, Alberta, Canada
    Thanked 5 Times in 5 Posts

    Re: Data Form

    If the labels are at the top of a column Excel will recognize them as labels and create the form for you. You will get the same form each time.
    When using the form each record will take up one row.
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

Posting Permissions

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