Results 1 to 7 of 7
  1. #1
    2 Star Lounger
    Join Date
    Nov 2002
    Posts
    134
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Form in Excel ? (2003/SP2)

    I have an Excel spreadsheet with 8 columns and infinite rows. It needs to be populated a row at a time. Is there a way I can have the user automatically return to the beginning column after entering data into the final cell of a row? I know in Access, it can be done by hitting enter. Unfortunately, the form needs to stay in Excel.

    I should mention that it's not set up as a form, just formatted to look like a table.

    Thanks.

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

    Re: Form in Excel ? (2003/SP2)

    1) If the user selects the table, the Tab key will act the way you want.

    2) You can unlock the cells in the 8 columns (in the Protection tab of Format | Cells), then protect the worksheet (Tools | Protection | Protect Sheet). The tab key will then also do what you want. You cna even specify that the user cannot select locked cells, if you wish.

  3. #3
    2 Star Lounger
    Join Date
    Nov 2002
    Posts
    134
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Form in Excel ? (2003/SP2)

    Thank you Hans! I'm not sure what you mean by "Select the Table," but protecting the worksheet is perfect!

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

    Re: Form in Excel ? (2003/SP2)

    By selecting the table i meant, select (for example) A1:H100, or columns A:H. Pressing tab from a cell in column H will take you to the next row, column A.
    Attached Images Attached Images
    • File Type: png x.PNG (9.0 KB, 0 views)

  5. #5
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Form in Excel ? (2003/SP2)

    If you select a cell in the first column and use tab to move across, then pressing enter will automatically take you down one row and back to the first column, without having to select the table.
    FWIW.
    Regards,
    Rory

    Microsoft MVP - Excel

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

    Re: Form in Excel ? (2003/SP2)

    True, that's yet another method. Both that one and selecting the table are fragile - one "wrong" click and you break the pattern.

  7. #7
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Form in Excel ? (2003/SP2)

    Too true! <img src=/S/yep.gif border=0 alt=yep width=15 height=15> Protection is the way to go.
    Regards,
    Rory

    Microsoft MVP - Excel

Posting Permissions

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