| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel - How to get tab to go to next unlocked cell across columns
Is there any way to use Excel as a form for data entry and have the enter
and/or tab key take you to the next cell for data entry when the next cell. Specifically, I have a form setup and it has merged fields at different places. I need the ability to enter across a line and at the end of that line for the next enter or tab to take me back to column A on the next unlocked cell. Is this possible? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel - How to get tab to go to next unlocked cell across columns
Make sure the cells you need to tab to are Unlocked. Once that is done,
protecte the sheet (with or without a password) and clear the check box next to "Select Locked Cells". Once that's done, tabbing will move you left to right then down. [Enter] will move you according to the settings in: Excel Options, [Edit] tab and the "Move Selection after Enter" setting. "Linda" wrote: Is there any way to use Excel as a form for data entry and have the enter and/or tab key take you to the next cell for data entry when the next cell. Specifically, I have a form setup and it has merged fields at different places. I need the ability to enter across a line and at the end of that line for the next enter or tab to take me back to column A on the next unlocked cell. Is this possible? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel - How to get tab to go to next unlocked cell across columns
Jerry
Note the "merged fields" Tabbing to unlocked cells on a protected sheet goes out the window when you have merged cells. Depending upon which cells are merged Tab can get stuck on a row and never move down. Gord On Thu, 22 Apr 2010 08:20:05 -0700, JLatham wrote: Make sure the cells you need to tab to are Unlocked. Once that is done, protecte the sheet (with or without a password) and clear the check box next to "Select Locked Cells". Once that's done, tabbing will move you left to right then down. [Enter] will move you according to the settings in: Excel Options, [Edit] tab and the "Move Selection after Enter" setting. "Linda" wrote: Is there any way to use Excel as a form for data entry and have the enter and/or tab key take you to the next cell for data entry when the next cell. Specifically, I have a form setup and it has merged fields at different places. I need the ability to enter across a line and at the end of that line for the next enter or tab to take me back to column A on the next unlocked cell. Is this possible? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel - How to get tab to go to next unlocked cell across columns
Depends on how the cells are merged.
See my reply to Jerry. Gord Dibben MS Excel MVP On Thu, 22 Apr 2010 08:14:01 -0700, Linda wrote: Is there any way to use Excel as a form for data entry and have the enter and/or tab key take you to the next cell for data entry when the next cell. Specifically, I have a form setup and it has merged fields at different places. I need the ability to enter across a line and at the end of that line for the next enter or tab to take me back to column A on the next unlocked cell. Is this possible? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| tab to next unlocked cell | Excel Discussion (Misc queries) | |||
| Bypass unlocked cell on protected worksheet in Excel 2003? | Excel Discussion (Misc queries) | |||
| Inserting comment in unlocked cell of protected Excel worksheet? | Excel Worksheet Functions | |||
| Moving from unlocked cells to unlocked cells in an excel form | Excel Worksheet Functions | |||
| How do i enter a note in excel to an unlocked cell on a protected. | Excel Discussion (Misc queries) | |||
Hybrid Mode
